>Hi,
>
>I'm using SQL 7.0 SP1. I have two Databases. I did a backup from my Database 1. I did a restore to my database 2. Why I don't see my users with Entreprise Manager section Users... It weird, because if I run the select statement "Select * from sysusers", i saw my users...Is it a bug of Entreprise Manager...
>
>Thank in advance,
I have seen this problem before. Sometimes just closing and launching SQL/EM fixes the problem.
Also, under certain scenarios SQL/EM messes up the information about login names, roles and groups when you backup a database and restore it in a different database/server from the one you original backed up. You can use the following commands to clean up the user information in the restored database and then recreate them back again using EM
use yourdatabase
go
sp_droprolemember 'db_owner', 'youruser'
sp_droprolemember 'otherroles', 'youruser'
sp_revokedbaccess 'youruser'
go
Hector Correa