get all members of server roles

• Urszula Dron

  SSC-Addicted

  Points: 411

  More actions

  January 12, 2005 at 12:01 pm

  #109963

  I need to list all members of server roles from about 20 servers (MS SQL 2000). Any one could help on how to get this info from system tables?

  I want to write stored procedure and run it using linked servers.

  Thanks,

• Urszula Dron

  SSC-Addicted

  Points: 411

  More actions

  January 12, 2005 at 12:17 pm

  #537104

  I found my answer: sp_helpsrvrolemember.