Thursday, March 8, 2012

change a user's DB dbo connexion name

How to change a user's DB dbo connexion name?I'm not sure I understand your question. The database owner's login is the
login mapping to the database 'dbo' user. You can specify the database
owner with sp_changedbowner:
USE MyDatabase
EXEC sp_changedbowner 'SomeLogin'
Hope this helps.
Dan Guzman
SQL Server MVP
"Scan le Gentil" <scanlegentil@.hotmail.com> wrote in message
news:%23Ewezps2FHA.2364@.TK2MSFTNGP12.phx.gbl...
> How to change a user's DB dbo connexion name?
>

No comments:

Post a Comment