... until the collector arrives ...

This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)

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'

Blog Archive