Home Forums SQL Server 2008 SQL Server Newbies Trace user with sql server authentication RE: Trace user with sql server authentication
Sean Pearce
SSCoach
Points: 15999
More actions
July 30, 2014 at 7:04 am
#1733568
EXEC sp_trace_setfilter @TraceID, 11, 0, 0, @UserName;
@TraceID - Your trace number
11 - Column 11 is Login
0 - Comparison uses =
0 - Logical AND
@UserName - Your search string
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]