Wednesday, August 09, 2006
After reading about SQL Server 2005's Try-Catch block, I used the syntax:
BEGIN CATCH TRAN_ABORT
{ sql_statement | statement_block }
END CATCH
Apparently, the TRAN_ABORT keyword has been removed... either that or it exists in a different form because it shows up as a syntax error; removing the TRAN_ABORT gives me the desired output.
BEGIN CATCH TRAN_ABORT
{ sql_statement | statement_block }
END CATCH
Apparently, the TRAN_ABORT keyword has been removed... either that or it exists in a different form because it shows up as a syntax error; removing the TRAN_ABORT gives me the desired output.