Below query can be used to check logins and associated server roles granted to them.

1> select suser_name(suid) as 'login',role_name(srid) as 'role' from master..sysloginroles
2> go

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.