SQL Server Group Trace | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
SQL Server Group TraceMy problem is as follows. I have user thats is a member of to AD groups A, B, C and D. These groups A, B, C, D are members in group AA, BB etc. And the the group AA, BB are Windows group Windows Group Logins in the SQL 2005 sp4 server. I’m using SQL Server Profiler and make a trace for Audit. The trace gives med Login that are in use. But is possible to trace what AA, BB, CC group that grants him permission to the server without lookin throw the hole AD and different groups he is member of.