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.
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment