How does one check for the existence of a named table in the tempdb. Using 'exists' or ' not exists' appears to only work if the table DOES exist. When the table does NOT exist it appears that Analyzer/T-Sql simply issues an error message and then quits. In my script I am setting up a temptable to carry info forward to subscripts. I need to verify that the temptable does not exist at the outset.
Thanks for your help..
As you can probably tell, I am somewhat of a NEWBIE with SQL Server and am stuck with using SQL Server 2000 for now. Our current main production DB is Oracle.......(still)