Transfer Logins to lower version SQL

Angelo
Angelo Member Posts: 180
edited 2012-10-02 in SQL General
Hi All,

Is there T-Script like sp_help_revlogin to transfer logins from SQL 2008 R2 back to SQL 2000?
I am only able to find the other way (SQL 2000 to SQL 2008). :roll:

Rgds,
Angelo

Comments

  • macuxpc
    macuxpc Member Posts: 16
    I would analyze the scripts in the following two KB articles and come up with my own to achieve what you are trying to do:

    http://support.microsoft.com/kb/246133
    http://support.microsoft.com/kb/918992

    This would take quite some time, so it depends on how many users you are trying to transfer. Might be faster to do it manually.

    On the other hand, I can't imagine a business scenario going from 2008 back to 2000 :wink:
    MacUxPC
    Dynamics-NAV.org

Categories