Moss/Sps Database with wrong DBO
Ok , so what happens when you let a ruckie Sharepoint Admin/Developer install your company's sharepoint? yes ladies and gentlemen - he installs it under HIS login 'MyDomain\HisUserName' . Problems ? yes, and what if he decides to leave the company and go freelance or something ? yes boys and girls his login and mailbox is been deleted . problem ? yes - all the DBs runs under his permission and not body knows it until a restart to the machine is made - aghhh :s
Solution ? yes
USE
whichever_database
EXEC sp_changedbowner 'MyDomain\Administrator'