Post reply

Sysobjects Tempdb

  • October 3, 2008 at 8:54 am

    #126628

    Hello to all

    How can i know which tables are created on tempdb and aren't used anymore, in sysobjects? and the space that they are using?

  • October 3, 2008 at 11:03 am

    #880611

    Temp tables will be automatically dropped when the connection that created them is closed. You don't have to (and in fact can't) manage the tables in TempDB directly.

    2005 does cache temp tables that are used often, so that it doesn't have the expense of recreating them. Don't worry about that

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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