Hi
I am doing sql 2000 to 2005 migration.
I am following the back up and restore method to do the migration.
After migration i run a script to transfer logins and passwords from sql 2000 to sql 2005 as in http://support.microsoft.com/kb/246133/
After migration I need to assign a database role created to a login /user .I need to do this through scripting.
Please help me on how to do this through script .
Thanks
You can script the permission in SQL 2000 and use the same in SQL 2005 for such requirement.
No comments:
Post a Comment