We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I'm searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the database permissions manually. We are running 300 databases on one SQL server. Is a script available to help us?
December 22, 2008 3:13 PM
October 23, 2013 2:10 PM