Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tonydang2002
Starting Member
15 Posts |
 Posted - 2008-12-30 : 18:51:32
|
| Hi,I have a task to restore a prod db to DEV and I want to keep all users, roles along with all the permission in DEV like they were before the restore. Does anyone know what would be the best way to handle this? Is there a way to script out all users, roles, permissions that I currently have on DEV db before the restore so that I can re-apply after the restore?Thanks,TD |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL2005 - how to restore users, roles, permissions