I have a few database Roles that map to Active Directory groups.  Is
there a way to determine from either system stored procedures or tables
what Roles a logged-in user belongs to if the user is logged in with
Windows Authentication.

Essentially what I'm trying to determine programmatically with T-SQL is
if the currently logged in user has permissions to any arbitrary
object, such as a table or stored procedure.  Is this common?  Wacky?

Getting an unused number from a set of numbers?
Design: multiple columns for primary key
Whats Wrong with the Query?
TSQL Debugger Oddity
Newbie:UNION with SELECT TOP