Home SQL Server How can I change the database owner?
How can I change the database owner? PDF Print E-mail
Written by Siva   
Tuesday, 11 December 2012 07:50

 

 

--------------------------------------------------------------------------------

How can I change the database owner?

--------------------------------------------------------------------------------

 

Answer:

 

You can use the sp_changedbowner system stored procedure to change the database owner.

Read about the sp_changedbowner stored procedure in SQL Server Books Online.

This is the example to make the user John the owner of the pubs database:

 

USE pubs

GO

EXEC sp_changedbowner 'John'

GO

 

 

 

 

 

Last Updated on Tuesday, 11 December 2012 07:53
 
 

Advertisement

Featured Links:
HREmail.com
Looking for job? Try HREmail.com
Want to have CMS based Websites?
Try siliconwebcreators.com to CMS based websites.
VM Solutions Inc
For best VM solutions..
Digital Procedure Inc.
Looking for Oracle /SAP /Weblogic Consulting services? visit digitalprocedure.com