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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-06-01 : 14:40:49
|
| Hi,I want to restore database from prod to dev. Problem is that how to keep existing users and their permissions on dev. Any script to do it. I just want to keep/restore users with permission which they already have in dev not from prod. Any help will be appreciated.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-06-01 : 15:06:10
|
| Hi Tara,I right clicked on dev database, selected task and generate scripts, then selected specific database objects and selected uses. That will script out all user statement like create user .... for login .... default_schema ....My question is whether permission will remain same once I run this script on dev after post restore.Thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
refresh database from prod to dev sql server 2008