PDA

Click to See Complete Forum and Search --> : changing Dadabase Owner in Sql2000

hthm
June 27th, 2006, 07:01 AM
hi there ..

in Sql 2000
how to change the owner of the DB after it is created


thanks..
Shuja Ali
June 27th, 2006, 07:07 AM
You can use sp_changedbowner stored procedure to change the owner of the database. EXEC sp_changedbowner 'NEWUSER' Remember the account under which this command will be executed should be member of the sysadmin group.