Copy over users

[twillett40]

Can someone tell me how to copy over the users from one database to another on the same server?
I used DTS to make a duplicate copy to a new database.
The problem is I do not know how to copy over the users.

Thanks,
TW

 

[jbenson001]

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q246133&ID=KB;EN-US;Q246133&

 

[twillett40]

Thanks, but I am trying to copy over users between two databases on the same instance of SQL.

I see how what you suggested would facilitate moving between two different instances.

I'm just not sure how to do this between two databases.
I thought this would take place when I used DTS to copy the data from one database to another.

 

[druer]

I'm thinking that copying sysusers probably won't work, but if you do a select against the sysusers from the starting database, and then create dynamic sql statement to add a user with the logon name from the query you should be good to go.

Hope it helps,
Dalton

 

[twillett40]

Thanks,
druer
How do I create a dynamic sql statement to add a user with the logon name from the query.

Terry