We recently changed the network administrator username on
the network where I work but all of our SQL 7 databases
still show the old name as the owner. How can this be
changed? thanks.Hi,
Use the below procedure in Query analyzer to change database owner,
sp_changedbowner 'Login_name'
Thanks
Hari
MCDBA
"Ken" <kklasser@.mindspring.com> wrote in message
news:e86601c3f070$3ad66b80$a601280a@.phx.gbl...
> We recently changed the network administrator username on
> the network where I work but all of our SQL 7 databases
> still show the old name as the owner. How can this be
> changed? thanks.
No comments:
Post a Comment