Bharat Guru
asked on
SQL 2008 How to generate the script for all database users and there roles
I want copy the database into new server, I have created BACKUP from my primary server and restored into new server but now how can i generated the script for all uers and there roll so I can deployed it to new server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Search for sp_help_rev_login and download the script from Microsoft.
It wont do roles, but it will create create login scripts that you can take to another instance of SQL 2008.
HTH
David