dbms

Posted by Anurag under Others on 3/6/2009 | Views : 2378 | Status : [Member] | Replies : 1

Is it possibble to change the database administrator?

Reply | Reply with Attachment

Posted by: Neeks on: 3/6/2009 [Member] Bronze

0	Can you tell me what you exactly want? You can change the Owner of the database using the following command. USE database_name GO EXEC sp_changedbowner 'owner_name' -Provide the user name here to whom you want to change as an admin GO http://www.mssqlcity.com/FAQ/Admin/DBOwner.htm If there is still any query, please let me know Anurag, if this helps please login to Mark As Answer. \| Alert Moderator

Can you tell me what you exactly want? You can change the Owner of the database using the following command.

USE database_name

GO

EXEC sp_changedbowner 'owner_name' -Provide the user name here to whom you want to change as an admin

GO

http://www.mssqlcity.com/FAQ/Admin/DBOwner.htm
If there is still any query, please let me know

Anurag, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts