Home Forums SQL Server 2008 SQL Server 2008 - General Is temporary table creation and dropping logged anywhere in SQL SERVER? RE: Is temporary table creation and dropping logged anywhere in SQL SERVER?

  • April 19, 2015 at 4:55 pm

    #1791900

    Jeff Moden (4/19/2015)

    hurricaneDBA (4/19/2015)

    Thanks thats actually a great idea 🙂

    Ah, be careful now. There's a price to be paid with Global Temp tables. Code that uses them might not be able to run concurrently.

    My suggestion was not a global temp table but a simple audit table, i.e. one row per batch.

    😎