>>>>I see, let me try. Also check your PM and I'm still wondering how can I quickly jump to the Help on the Error Message.
>>>
>>>I read it, but I have problems with connection to my SQL Server right now. Adobe is downloading its Update and get ALL my network power :-)
>>
>>No rush, I'm manually setting parameters in this SQL statement now. I hate manual typing... :)
>
>HA!
>I think you will not have problems with that. You should use all 6 pairs of hands (Buddha) :-))))
>I just sent you a PM, no need to write ALL parameters.

http://www.setfocus.com/TechnicalArticles/sql-server-2005-tsql-2.aspx

Yes, I need to write Kevin about it.

I found that it should be

-- If the error renders the transaction as uncommittable, we must rollback
		IF XACT_STATE() <> 0
            BEGIN
            --print 'Rollback transaction' 
			ROLLBACK TRANSACTION
            END

       RAISERROR (@ErrorMessage , @ErrorSeverity, @ErrorState, @ErrorNumber)

I already implemented the code in few procedures, now I would have to update them all :) Trust, but check! (Doverjaj, no proverjaj).