Sunday, February 12, 2012

Changing database owner ??

Hello ,
Can we change database owner in MS SQL SERVER 2000 ?
Thanks
Prasad.Look up sp_changedbowner in BOL...
"mva" <prasad_mynumpati@.hotmail.com> wrote in message
news:Opv18jqCEHA.2308@.tk2msftngp13.phx.gbl...
> Hello ,
> Can we change database owner in MS SQL SERVER 2000 ?
> Thanks
> Prasad.
>
>|||Hi,
use dbname
go
EXEC sp_changedbowner '<login_name>'
Thanks
Hari
MCDBA
"mva" <prasad_mynumpati@.hotmail.com> wrote in message
news:Opv18jqCEHA.2308@.tk2msftngp13.phx.gbl...
> Hello ,
> Can we change database owner in MS SQL SERVER 2000 ?
> Thanks
> Prasad.
>
>

No comments:

Post a Comment