• I have proc that will script out all the users, roles and their permissions if you want it.

    But I would make two other suggestion which would be simpler:

    1) import the logins from the production server to the development server then you won;t have to worry about it anymore.

    2) if you can't do that, always remeber to run sp_change_users_login for the SQL serve logins after you restore your production database.

    The probability of survival is inversely proportional to the angle of arrival.