Home Forums SQL Server 2012 SQL 2012 - General One script to drop all temporary tables RE: One script to drop all temporary tables

  • January 16, 2014 at 7:01 pm

    #1680935

    Not enough time to check, but does tempdb.sys.tables show temp objects that aren't yours? Also, does it provide a name that is "droppable"?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service