Home Forums SQL Server 2005 Development Global Temp Tables: Triggers Vs Stored Procedure RE: Global Temp Tables: Triggers Vs Stored Procedure

  • 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