move users

hi all
how can i move all users from one sql instanz to another ?
with all corresponding privilegs?
i have to move 10 databases from one sql server to a second and then
delete the databases on the first one.
thankx for your help
mike schwarz
www.ctek.ch
These should get you going:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Mike Schwarz" <ctek@.ctek.ch> wrote in message
news:%23cLwTDMrEHA.2776@.TK2MSFTNGP14.phx.gbl...
> hi all
> how can i move all users from one sql instanz to another ?
> with all corresponding privilegs?
> i have to move 10 databases from one sql server to a second and then
> delete the databases on the first one.
> thankx for your help
> mike schwarz
> www.ctek.ch
>
|||thank you for the reply... seems to be a very hard task, lots of options
and possibilities. it seems that the SID is the most common problem. i
will try this with the utility you gave me the link
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!