• 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]