change login name for dbo

[woyler]

Hi all,
Search is not working still, so I have another one. How do you change the login name for dbo? I want the dbo account to carry the sa login. I created the database under my login and it is now dbo's login.

regards,
Bill

 

[woyler]

Nevermind. I had run the EXEC sp_changedbowner 'sa', and it did not appear to work. I have restarted the db and it shows correctly now.

 

[mrdenny]

You don't have to restart the SQL Server for the change to take effect. You do need to force a refresh of the users list in Enterprise Manager. EM caches a lot of information, so infomation like the users lists can be out of date if you aren't careful. You are better off querying the sysusers table directly to see what the mappings are.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com