Inserting to an error log

Question

Inserting to an error log

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Define a table variable, then insert the error information into the table variables first. After you issue the rollback, then insert the information from the table variable into your error log table.

The table variables are not affected by transactions.

Dean Cochrane Ten Centuries Points: 1022 More actions · Answer 2

Dean Cochrane

Ten Centuries

Points: 1022

January 22, 2009 at 6:06 am

#931069

Of course. I should have thought of that. Thanks.