ANSWERED - How to tell if a temp table exists in SQL Server

Search the GP Tables

Search by TABLE NAME

Search by FIELD NAME

These are our EHW scripts. All of our scripts for Dynamics GP can be found here

	EHW Scripts
	No records to display.

Isaac 8/9/2011 7:24:59 AM

How to tell if a temp table exists in SQL Server

This line of code will tell you if a temp table exists in the temp database, so you avoid all those errors..

Tested in SQL 2000 & 2005:

Version: Unknown or N/A

Section: SQL Scripts

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables