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 r
estore database. Initially you should erase the users that has the new datab
ase and subsequently to execute the script in the Query analyzer.
The Script you can create for Enterprise Manager, Rigth Click about the data
base, All Task, Generate SQL Script.
****************************************
******************
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?|||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