To select all sql database roles query the systusers table and not the sysroles table, because it does not exist. All roles are stored in the sysusers table
select * from dbo.sysusers where issqlrole = 1

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.