Before jumping into doing a restore, are you doing log shipping or do you have a standby that you may be able to recover the tables from?  Please check to...

For anyone who stumbles upon this, this is a known issue and is addressed in SP2 for SQL 2005.

What did the script look like that you used?

The list of system tables: 

sysobjects

sysindexes

syscolumns

systypes

syscomments

sysfiles1

syspermissions

sysusers

sysproperties

sysdepends

sysreferences

sysfulltextcatalogs

sysindexkeys

sysforeignkeys

sysmembers

sysprotects

sysfulltextnotify

sysfiles

sysfilegroups

What have you managed to delete so far?  Have you successfully deleted these in all databases or is this isolated?

Dude, how did you become a senior DBA without knowledge of the existence of system tables?  They have always existed.  Even MS.Access has system tables, just hidden.  Where have you...

We have had similar experiences here where a number of temp tables are stranded even after all connections have been closed or terminated.  Our experience with this was in dev...

We actually are already following best practice and using explicit drop statements but have experienced some unusual behavoir such that under certain circumstances where an error or other disconnect occurs,...