Posted by Erland Sommarskog on 06/30/05 00:44

jsfromynr (jatinder.singh@clovertechnologies.com) writes:
> I am trying to restore a database from backup on another system [my
> client's] but I had to follow some weired steps.
>
> Step 1. Restore the database from EM 's GUI.
> [Users as on My machine get restored but their logins are not
> activated. So I have to follow the next steps]
>
> sp_helpuser shows me the userName but null LoginName and
> DefaultDatabase
>
> Step 2. Create a new login , grant access to the DB
>
> Step 3. Then run the script to change the ownership from earlier DB
> user to new user.
>
> Step 4. In EM make new user as dbo.

Look at sp_change_users_login in Books Online.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]