Another quick question; am I correct in believing that sys.server_principals and sys.server_role_members are system views that return data relevant to the server and not one of the databases? I'm wondering because we've defined the roles at the database level only. When I perform a SELECT * against both of those views I do not see our database roles at all. I do see server roles listed.
I should mention that I'm doing this on a SQL Server 2008 R2 instance.
Kindest Regards, Rod Connect with me on LinkedIn.