restoring from 7 to 2000

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
>