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.

Comments:
This keyword was present in Beta 1 and removed from Beta 2, RTM and SP1.
 
Post a Comment



<< Home

This page is powered by Blogger. Isn't yours?