2010-03-11

SQL Server dbo Login Name

In SQL Server 2005, you cannot change the login name associated with the dbo user through the various management tools or by using sp_change_users_login. You must use the following command:

sp_changedbowner 'newloginname'