Posted by xAvailx on 02/13/06 19:58

>> Rather, it appears
that the identifier for SAVE TRANSACTION follows the database
collation,
whereas the identifier for BEGIN TRANSACTION is always case-sensitive!
<<

That explains why in the original stored procedure I wasn't receiving
an error if a transaction was started (It was falling in the save tran
block of the transaction handling).

Thanks for your help and time in figuring this out.

Thx.

• Next in forum: Job Executes Only First Step
• Prev in forum: Dynamic query help SQL 2005
• Thread view: Re: SQL Server 2005 - Save tran save point name case sensitive?

[Reply to this message]