There is already an object named '##Temp' in the database

Question

I have a stored procedure on SQL Server 2000. It contains:
select ... into ##Temp ... ... drop table ##Temp

When I run the stored procedure with ADO a second time, it prompts:
There is already an object named '##Temp' in the database.
Could anyone kindly tell me what's wrong?

user_7073804 · Answer

For me this solution works :

IF (SELECT object_id ='#Temp') IS NOT NULL
BEGIN
   DROP TABLE #Temp
END

There is already an object named '##Temp' in the database

5 Answers