dbms

Posted by Anurag under Others on 3/6/2009 | Views : 1327 | Status : [Member] | Replies : 1
Is it possibble to change the database administrator?




Responses

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

Up
0
Down
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

Login to post response