Hi Shanky, shouldn't that be
BEGIN CATCH
IF XACT_STATE() <> 0
Ohh!! that was a mistake, thanks for pointing. Corrected it.
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
My Technet Wiki Article
MVP
No comments:
Post a Comment