I have SQL 2000, and I would like to change the owner of one of the DB? Can you tell me how?
Thanks.sp_changedbowner
Russell Fields
"Hubco" <anonymous@.discussions.microsoft.com> wrote in message
news:DEE96313-0F74-4E75-9545-B2F4D55AECB0@.microsoft.com...
> I have SQL 2000, and I would like to change the owner of one of the DB?
Can you tell me how?
> Thanks.|||look at the system stored procedure sp_changedbowner in books online.
Ex:
EXEC sp_changedbowner '<new owner>'
--
Vishal Parkar
vgparkar@.yahoo.co.in|||Hi,
Please refer BOL for Sp_changedbowner system stored procedure
Thanks
Hari
MCDBA
"Hubco" <anonymous@.discussions.microsoft.com> wrote in message
news:DEE96313-0F74-4E75-9545-B2F4D55AECB0@.microsoft.com...
> I have SQL 2000, and I would like to change the owner of one of the DB?
Can you tell me how?
> Thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment