I have MS SQL Server 2000 Standard Edition with SP2 installed.
I create a new Trace Template which must capture all the activity(login, logout, sp, statements etc).
In my database I have a lot of stored procedures which are called from others.
create proc sp1
exec sp2
How can I filter the output so the execution of sp2 (if this is called from sp1) not to appear in the output. I mean I need in the output only the stored procedure with nestlevel = 1.
In the Filters tab from Profiler NestLevel doesn't appear (I select it in Data Columns tab). I try also by creating the trace from TSQL, but the results was the same.
Thank you very much for any ideea!