Posted by Dan Guzman on 08/09/06 12:43

> Did Microsoft decide to do away with the
> TRAN_ABORT keyword?

Yes. Many changes were made during the development cycle.

> I did find some other articles (including MS SQL Server 2005 BOL) that
> entirely left out the TRAN_ABORT keyword.

The latest Books Online (plus mskb articles) is the authoritative reference.
Articles written based on pre-release software may be interesting from a
historical perspective but might not reflect reality.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"NiTiN" <emailme.nitin@gmail.com> wrote in message
news:1155124815.629986.82920@i3g2000cwc.googlegroups.com...
> Hi!
>
> I've been trying out SQL Server 2005's new Try-Catch exception handling
> and I tried using the following form:
>
> SET XACT_ABORT ON
> BEGIN TRY
> END TRY
> BEGIN CATCH TRAN_ABORT
> END CATCH
>
> However, I get a syntax error on TRAN_ABORT.... removing it gives me
> the expected output. Did Microsoft decide to do away with the
> TRAN_ABORT keyword?
>
> The syntax above (with the TRAN_ABORT) can be found at:
> http://www.informit.com/articles/article.asp?p=327394&seqNum=8&rl=1
>
> I did find some other articles (including MS SQL Server 2005 BOL) that
> entirely left out the TRAN_ABORT keyword.
>

• Next in forum: Re: Table structure and data transfer from SQL2000 to Access (.mdb)
• Prev in forum: Re: SQL Server 2005 and file systems, any recommendations
• Thread view: Re: TRAN_ABORT gone?

[Reply to this message]