Tuesday, May 17, 2005

Change owner of the database

To change the owner of the present database, use the stored procedure sp_changedbowner

Syntax:
sp_changedbowner '<login>'

The ownership for databases
  1. Master
  2. Model
  3. Tempdb
cannot be changed

Only members with sysadmin role can execute the stored procedure sp_changedbowner

0 Comments:

Post a Comment

<< Home