sql server profiler- Trace the direct queries only!

• S_Kumar_S

  SSCrazy Eights

  Points: 9037

  More actions

  October 21, 2015 at 2:30 am

  #321568

  HI All

  Is there a way to setup a trace to show only direct TSQL statements triggered on my server? Pls note I don't want to capture Procedure calls or the statements called within the procs.

  Actually many people are firing direct SQL statements on server. And some are coming from entity framework as well. I just want to capture those.

  thx

  Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  October 22, 2015 at 1:51 am

  #1834826

  Put a filter on the host name and filter out anything that's not the server.