Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Dec 2009
    Location
    Canada
    Posts
    87
    Thanks
    0
    Thanked 8 Times in 8 Posts
    Just wondering how one would go about generating a report on the active directory user/group rights to all the databases, queries, reports, etc in a particular database on a 2000 SQL server?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    If you can connect to it using SQL Server 2005 or 2008 Management Studio, then you have the option of doing things with SQL Server Reporting Services. Otherwise it is a pretty complex task, and you have to work with the system tables in SQL Server. Unfortunately I don't have access to a SQL Server 2000 system any more.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •