SQL: Changing database owner

SQL Add comments

If you've ever setup a table and want to change the owner details  you can run the below sample script in your SQL IDE e.g. Query Analyzer \ Aqua DataStudio to change database owner:

sp_changeobjectowner '[DOMAIN\user.name].databasename' , 'dbo'

Bookmark and Share

0 responses to “SQL: Changing database owner”

Leave a Reply

Leave this field empty:

Powered by Mango Blog. Design and Icons by N.Design Studio