SQL Exceptions

• Ram:)

  SSCrazy

  Points: 2246

  More actions

  October 27, 2010 at 11:45 am

  #240306

  Hi,

  I am able to capture sql exceptions using begin try... end try..

  But I am unable to do the same with the error like..''Invalid Column Name" etc..

  Please can any body suggest how to do this..

  Regards

  Ram..

  🙂

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 27, 2010 at 4:35 pm

  #1243237

  You can't.

  See this: Using TRY...CATCH in Transact-SQL

  Look for "Compile and Statement-level Recompile Errors".

  -- Gianluca Sartori