July 25, 2002 at 1:43 am
Hi,
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.
Ex:
create proc sp1
as
...
exec sp2
...
go
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!
July 25, 2002 at 6:40 pm
I don't believe you can.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply