Home Forums SQL Server 2005 Development Global Temp Tables: Triggers Vs Stored Procedure RE: Global Temp Tables: Triggers Vs Stored Procedure
Paul White
SSC Guru
Points: 150468
More actions
July 6, 2009 at 10:46 pm
#1020877
I only looked quickly, I admit, but if you want to preserve log information over a transaction boundary, why don't you use a table variable instead?
Table variables aren't affected by transactions.
Paul
Paul WhiteAll articles available on SQL.kiwi@SQL_Kiwi