113 reputation
3
bio website
location
age
visits member for 2 years, 4 months
seen Aug 23 '12 at 13:24

Aug
22
comment Microsoft SQL Server 2008 - Catching user role changes with SQL Server Profiler?
Thank you! I think I found where it happens, it's a SP: StmtCompleted event that reads sp_dropsrvrolemember [NPTAD\vmuser], [sysadmin]. Does this mean that somewhere this exact line of code is being executed or is this an output of the results of executing code?
Aug
22
awarded  Scholar
Aug
22
awarded  Student
Aug
22
awarded  Supporter
Aug
22
accepted Microsoft SQL Server 2008 - Catching user role changes with SQL Server Profiler?
Aug
21
asked Microsoft SQL Server 2008 - Catching user role changes with SQL Server Profiler?