Help needed in Setting the Properties of a profiler

• Raghu Ravi

  SSC-Addicted

  Points: 420

  More actions

  September 13, 2005 at 1:45 am

  #165477

  Hi All,

  want to know the exact filter that i need to set while running a trace/profiler for the below scenarion

  I am calling a SP, SP1 which inturn calls so many SP's like SP2, SP3, SP4, SP5..

  now i want the trace to show the stmts that are getting executed for SOME SP say SP5.. and not for SP1,SP2,Sp3, SP4

  How do i go about that..

  Rite now, i am setting these filters

  HostName : My Machine Name and in the events i've included the Stored Procedures

  Note : I even tried doing it so by giving the Object_id of the SP5 in the Object_id filter but still then trace is showing all the Queries that i execute in the Query Analyzer window also

  Any help would be of great helpful

   

   

• September 16, 2005 at 8:00 am

  This was removed by the editor as SPAM

• peterhe

  SSChampion

  Points: 11469

  More actions

  September 16, 2005 at 10:39 am

  #590669

  In the event, inlcudes SP:Starting and/or SP:Complete;

  In the filters, find the TextData, under like type '%SP5%'.

  Run the trace.