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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.