When doing a restore from Sql 7 to Sql2000 the sysusers seems to reflect
sql7, and sa looses it rights to the database, how do you fix thisYou might be interested in these stored procedures:
sp_change_users_login
sp_changedbowner
--
Keith
"sd" <susan.dunn@.ncsl.org> wrote in message
news:%23vu0YbkLFHA.1476@.TK2MSFTNGP09.phx.gbl...
> When doing a restore from Sql 7 to Sql2000 the sysusers seems to reflect
> sql7, and sa looses it rights to the database, how do you fix this
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment