How to change the SharePoint logo on every page

Our new SharePoint 2007 site is up and running. Over 1,000 pages, each with our customized logo in the upper left hand corner. Uh-oh, it worked fine on the test server, but not on the production server. That's because every page was created from some nifty template which points to the test server to look for the logo, and the test server is no longer available. Not only does it look bad, but for reasons known only to the various SharePoint gods, you can't switch a document library to Explorer View until SharePoint has finally decided that the logo can't be found. This takes about 20 seconds. The natives were restless, and the high chieftan announced that Something Had To Be Done. After manually changing a hundred pages, I decided there has to be a better way. Well, an easier way.
I don't believe in mucking with the SharePoint SqlServer database. I don't go out with those who do. But I did it here, after testing it first on another department's production server (that's another story). Here's what you do...
use WSS_Content
update Webs
set SiteLogoUrl = '/ImageLibOnHomePage/LogoFilename.jpg'
where SiteLogoUrl = 'http://TestServer/ImageLibOnHomePage/LogoFilename.jpg'
It turns out I didn't need the "http://TestServer" part anyway! SharePoint happily defaults to the local server. So now it both works and is server-independent.

Posted in: sharepoint site logo