View Single Post
  #2 (permalink)  
Old 01-05-09, 06:31
Martijnvs Martijnvs is offline
Registered User
 
Join Date: Jan 2004
Location: The Hague/Utrecht, NL
Posts: 396
There is no specific command, but you can use this query:
Code:
select sr.name, sl.name
from syssrvroles sr, syslogins sl, sysloginroles slr
where sl.suid = slr.suid
and sr.srid = slr.srid
and sr.name like "sa_role"
In the last line, you can substitute sa_role with any role-name you want to know the members of.
__________________
I'm not crazy, I'm an aeroplane!
Reply With Quote