Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
change dbo
- Thread starter jvande
- Start date
tlbroadbent
MIS
Which version of SQL server are you running and how did you associate the wrong user with DBO?
In SQL 7 and SQL 2000, you can use the system stored procedure "sp_changedbowner" to change the database owner. The following example comes from SQL BOL.
This example makes the user Albert the owner of the current database and maps existing aliases to the old database owner to Albert.
EXEC sp_changedbowner 'Albert' Terry L. Broadbent
Programming and Computing Resources
In SQL 7 and SQL 2000, you can use the system stored procedure "sp_changedbowner" to change the database owner. The following example comes from SQL BOL.
This example makes the user Albert the owner of the current database and maps existing aliases to the old database owner to Albert.
EXEC sp_changedbowner 'Albert' Terry L. Broadbent
Programming and Computing Resources
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question