copy users and roles from one database to another in a SQL server 1

[shanghai2004]

Dear Expert,

Is there a way to copy users and roles from one database to another (but not tables and views) in a SQL server?

Thanks

 

[NoCoolHandle]

In Enterprise Manager

Right Click on your Database
Select "All Tasks"->"Generate SQL Script"
Select "Options"
Check "Script Database Users And Database Roles"
UnCheck everyting else
Select OK or.. Go back to the "General" tab and select "Preview"


HTH


Rob