Monitor SQL Statement Thrown by an Application

• wackoyacky

  SSC Eights!

  Points: 832

  More actions

  June 3, 2009 at 12:15 am

  #132921

  Hi guys,

  I'm trying to debug an anomaly in one of our application and I'm trying to look at the actual sql statement being thrown by the .NET application. Previously I used to get this by using SQL Profiler, but since in my current company our access to db is restricted, I can't make use of profiler.

  Do you have any other alternative for SQL Profiler which can do the same task? Is it possible to query any DMV to get the same results?

  I've tried using dm_exec_requests together with dm_exec_sql_text, but it shows the stored procedure itself rather than showing the exact stored proc call (with the parameter value passed) made by the .NET application.

  And also I can't find a way to get to the past logs in dm_exec_requests, it always have the current request.

  Any inputs would be greatly appreciated.

  Thanks,

  Enzo

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  June 3, 2009 at 5:22 am

  #1003901

  will you company not allow you to trace the db? you dont need sysadmin right to trace.

  GRANT ALTER TRACE TO [domain]\[username];

  GO

  Or

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47384

• wackoyacky

  SSC Eights!

  Points: 832

  More actions

  June 3, 2009 at 9:38 pm

  #1004397

  I'll be checking TRACE stuff and see if it works.

  Thanks.