SQL Profiler: Caputure query ONLY when there is an exception

• LeelaKrishna

  SSC-Addicted

  Points: 440

  More actions

  April 19, 2010 at 4:12 am

  #217979

  Hi All,

  I am Leela from India.

  Nice to see some many Database experts helping fellow members on our site..

  SQL version: MS SQL 2005

  I have a typical scenario for which iam trying to find an efficient way..

  I need to run SQL profiler on an environment where around 100 queries would be running in a minute and i need to run the profiler for couple of days. BUT IAM INTERESTED IN CAPTURING queries ONLY that FAIL with an exception. Means the profiler trace should ONLY show the queries that gave an exception and the details of the exception also, i don't want to see successful queries in my profiler trace.

  I would like to know if there is any filtering mechanism on SQL profiler which can help getting this information.

  Thanks a lot.. Any Guidance highly appreciated.

  Regards,

  Leela

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  April 19, 2010 at 5:42 am

  #1153718

  Refer these links

  Auditing with SQL Profiler[/url]

  Mastering SQL Server Profiler - Introduction[/url]

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)