Restore of users when moving a database from one server to another...

Hi
When moving a SQL server database from one server to another you get
problem with the users.
Is there a easy way to recreate or fix the users that the database
allready contains or do I need to remove all security settings and
reapply them?
Thanks
/MagnusHi
You can create a Script about the database users and execute this when you restore database. Initially you should erase the users that has the new database and subsequently to execute the script in the Query analyzer
The Script you can create for Enterprise Manager, Rigth Click about the database, All Task, Generate SQL Script
*********************************************************
When moving a SQL server database from one server to another you ge
problem with the users
Is there a easy way to recreate or fix the users that the databas
allready contains or do I need to remove all security settings an
reapply them|||Look at sp_change_users_login in BOL.
Mike Abraham
"Magnus Wettemark" <magnus.wettemark@.staffware.dk> wrote in message
news:ec837e09.0402110332.3f9d9f17@.posting.google.com...
> Hi
> When moving a SQL server database from one server to another you get
> problem with the users.
> Is there a easy way to recreate or fix the users that the database
> allready contains or do I need to remove all security settings and
> reapply them?
> Thanks
> /Magnus