hi there ..
in Sql 2000
how to change the owner of the DB after it is created
thanks..
Printable View
hi there ..
in Sql 2000
how to change the owner of the DB after it is created
thanks..
You can use sp_changedbowner stored procedure to change the owner of the database.Remember the account under which this command will be executed should be member of the sysadmin group.Code:EXEC sp_changedbowner 'NEWUSER'