We restore a production database (with around 50 users) to
a Training database on another SQL 2000 Server.
However, we find that those users on the Training Database
disappear (All has been lost except SA). However, from
one Database Role, it shows that those users (around 50)
still are members of that role.
Is it sensible for those database users disappear (As
there is no corresponding SQL Server Login created for
them) OR how can I get back those users ?
ThanksThey have a mis-match to the id for the logins in master..syslogins. Use sp_change_users_locing to
fix. There's a free GUI for that available at http://www.dbmaint.com/free_utilities.asp.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Roger Lee" <rogerlee@.nospam.com> wrote in message news:093501c36601$7bec4cb0$a301280a@.phx.gbl...
> We restore a production database (with around 50 users) to
> a Training database on another SQL 2000 Server.
> However, we find that those users on the Training Database
> disappear (All has been lost except SA). However, from
> one Database Role, it shows that those users (around 50)
> still are members of that role.
> Is it sensible for those database users disappear (As
> there is no corresponding SQL Server Login created for
> them) OR how can I get back those users ?
> Thanks|||>--Original Message--
>We restore a production database (with around 50 users)
to
>a Training database on another SQL 2000 Server.
>However, we find that those users on the Training
Database
>disappear (All has been lost except SA). However, from
>one Database Role, it shows that those users (around 50)
>still are members of that role.
>Is it sensible for those database users disappear (As
>there is no corresponding SQL Server Login created for
>them) OR how can I get back those users ?
>Thanks
>.
>You can copy across users/logins from the other DB using
DTS.
