SQL Server – Change Database Owner

  By , ,

Below is the T-SQL script to change DB owner.​​ 

 

EXEC​​ sp_changedbowner​​ 'owner_name';

 

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL Server – Get VLF Counts for All Databases in an Instance
  2. SQL Server – Get Database Owner Names via T-SQL
  3. SQL Server – Resolve Error 5030 to Rename Database
  4. SQL Server – Get Index Creation Date
Tagged  , , , , , , , , , .
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *