|
|
| |

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 |
See also this link:
How can I change the object owner?
|
|
|