In this video you will learn how to change owner of a database in SQL Server? video provides different following ways to do it.
1- How to change database owner using Store Procedure
2- How to change database owner using Alter Authorization statement.
Scripts:
1- How to change database owner using Store Procedure
2- How to change database owner using Alter Authorization statement.
Scripts:
Use Demo --EXEC sp_changedbowner 'New Owner Login' EXEC sp_changedbowner 'sa' -- Changing database owner using Alter Authorization to Login [TECHBROTHERS\clusteradmin] ALTER AUTHORIZATION ON Database:: Demo TO [TECHBROTHERS\clusteradmin]
How to Change the Ownership of a Database in SQL Server - SQL Server DBA Tutorial
script for check how is owner
ReplyDelete