Log query errors

• danielpila

  Newbie

  Points: 9

  More actions

  July 18, 2011 at 4:41 am

  #253789

  Hi,

  I would like to log the queries which execution causes an error, to detect errors on my applications the user can´t see, for example, if I forgot to fill a field and them have an insert like

  insert into table (A,B) values (,valueB)

  this causes an error but maybe the user dont see this error, I want to tack this errors to improve my application.

  Thnaks in advance

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  July 18, 2011 at 12:13 pm

  #1354404

  You can setup a trace to do that. Look into the Errors and Warnings Event Category:

  http://technet.microsoft.com/en-us/library/ms177448.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato