Free SQL Server permissions transfer tool-- Just thougth I'd pass it on, looks like something that could make our lives a lot easier. Give it a try, its working for me. download at:http://www.idera.com/freetools
Welcome to the forum... Thanks for sharing the info... MS has the script to move the logins but not the permissions... How to move databases between computers that are running SQL Server http://support.microsoft.com/kb/314546 MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.