of course if depends on the level of granularity of the grants for your current QA-accounts.

IMO scripting all grants may be the easiest approach.

Then, use restore db and run the scripts you generated in the previous step.

btw: When using SQLusers, we tend to use the same user names, but ensure sql passwords are different on every SQL instance.

After restore we can just use "ALTER USER" to resync. the accounts.

You will also need the generated scripts in this case, because of security being altered at QA side as part of the next release.

( but I hope that is included in your upgrade scripts )

Keep in mind when dropping objects, the grants for those objects that have been granted at object level, will also vanish.

Play it safe and always script it all before you start the next level and have your regular backups in plance.

You may even want to make some sqlagent jobs that will perform it all for you, or use Allens powershell variant to restore your production dbs to QA ( you'll need to modify the script a little bit if you want to fix it all )

Test Your SQL Server Backups with PowerShell[/url]