Home Forums Article Discussions Article Discussions by Author Discuss content posted by shiva challa List all Usernames, Roles for all the databases. RE: List all Usernames, Roles for all the databases.

  • September 25, 2008 at 9:14 am

    #877090

    KDASQL (8/28/2008)

    Is there anyway we can make this work in SQL 2000. I need to run this on a SQL 2000 box.

    Please advise.

    Thank you.

    You can't run this script on SQL Server 2000 as the script is based on the catalog views which are newly introduced in SQL server 2005. This script can be changed to work on SQL 2000 fairly quickly using the below table mapping (source: SQL server 2005 books online).

    systable in 2000 = view in 2005

    -------------------------------

    syslogins = sys.server_principals

    sysusers = sys.database_principals

    sysmembers = sys.database_role_members

    Kindest Regards,
    Shivaram Challa
    (http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
    Forum Etiquette: How to post data/code on a forum to get the best help[/url]