Thursday, April 16, 2009
Ever wanted to see who was in a windows group?

As a SQL DBA, I used to be able to see this kind of information using SQL 2000, but that part of the GUI got left behind in SQL 2005/2008, however, there is a stored procedure that you can use to see this information:

xp_logininfo 'BUILTIN\Administrators', 'members'

This lists all the users who belong to a given group, in this example, it lists the members of the Administrators group, good stuff to know if you need to know just who can administer the SQL box that your Dynamics GP / Great Plains is running on!