Who owns which server roles

• mngong

  SSCertifiable

  Points: 6167

  More actions

  November 3, 2006 at 8:14 am

  #75086

  Need help with what to query to find out which users own what server roles

  Thanks for your time

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 3, 2006 at 8:46 am

  #669812

  If you mean you want to find the members of server roles, use SP_HELPSRVROLEMEMBER.

  Greg

  Greg

• mngong

  SSCertifiable

  Points: 6167

  More actions

  November 3, 2006 at 8:52 am

  #669814

  Thanks Greg

  Got it right after posting .