Script out SQL permissions for groups

[NCjuggler]

I have an upgrade project that involves installing Microsoft SQL 2005 I have several Microsoft SQL 2000 database that I have backup and restored to a Microsoft SQL 2005 database and am concerned that the groups & permissions will not carry over properly. Some permissions are set with Windows domain authenticification and others are set individually on the server.

Is there a method to script out a file to restore groups/permissions to the new server?

Thanks in advance for any answers or suggestions.

 

[mrdenny]

All permissions are included in the database backup and will come across correctly. This thread (thread962-1324602) has scripts to script out permissions.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog