RE: Scripting out permission for database?

SSC Guru

Points: 323504

November 14, 2012 at 9:43 am

you'll need to get a copy of sp_help_revlogin from microsoft; there are different versions, depending on 2000/2005, maybe even for 2008 and above, i don't quite remember.

assuming you are going to do a backup from Prod and Restore on the new server, you should be good with that...object permissions are stored int eh databases themselves, and the procedure above will carry the correct sids along with it, so that makes it fairly seamless.

don't forget all the other things on production, like certificates, linked servers,

and more; theres a current thread on side by side server migration you might want to peek at:

http://www.sqlservercentral.com/Forums/Topic1384265-391-1.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!