Hello folks I am on SQL2K5 enterprise edition. I want to refresh staging database with production. Before I do that I want to script out the users with their roles/permission so I can restore the staging permission after database restore. I tried to use generate script but it scripts only the users NOT their respective roles / permissions. Thanks in advance.