What is the TRACE to see all the sql statements run

• TNV

  Mr or Mrs. 500

  Points: 526

  More actions

  June 18, 2009 at 6:08 am

  #99768

  Hi,

  What is the TRACE to see all the sql statements sent by the client?

  Thanks,

  TNV

• DNA_DBA

  SSCrazy Eights

  Points: 9118

  More actions

  June 19, 2009 at 4:08 am

  #1012256

  you can use profiler to trace the queries being run and you can also get it to generate a script to enable tracing.

• myheadhurts

  Ten Centuries

  Points: 1262

  More actions

  June 19, 2009 at 12:43 pm

  #1012613

  - Start Profiler

  - File Menu / New Trace

  - 'Events Selection' Tab

  ---- Uncheck all except Stored Procedures RPC: Completed (and maybe TSQL:SQLBatchCompleted )

  ---- Check 'Show all columns'

  ---- Ensure 'Text Data' column is checked

  ---- Click 'Column Filters...' button

  --------Poke the client name into LIKE field of LoginName or NTUserName (depending on security model) then click OK

  -- Back on the 'Trace Properties' page click 'Run' button

  -MarkO

  "You do not really understand something until you can explain it to your grandmother" - Albert Einstein