Very Computer

I created a temporary table in a stored procedure, and the first time I ran it I
forgot the drop table at the end of the routine. Ordinarily, I would just
execute a DROP TABLE command on it, but that returns that there is no object of
that name in the System Catalog. The trouble is, I cannot now edit that stored
procedure because it will not compile, returning an error saying that the temp
table object already exists!!! I have deleted the stored procedure, and
recreated it, reboot my machine, and stopped and started the SQL server, but to
no avail. And it gets wierder. If I change the table name to something else, and
try to add the stored procedure, it says that that newly named temp teble
already exists too!!! And I haven't even run the procedure to execute the CREATE
TABLE....

I am at my wits end - can anyone help??

Thanks in advance

Andrew

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.

Quote:> Hope anyone can shed light on this problem...

> I created a temporary table in a stored procedure, and the first time I ran it I
> forgot the drop table at the end of the routine. Ordinarily, I would just
> execute a DROP TABLE command on it, but that returns that there is no object of
> that name in the System Catalog. The trouble is, I cannot now edit that stored
> procedure because it will not compile, returning an error saying that the temp
> table object already exists!!! I have deleted the stored procedure, and
> recreated it, reboot my machine, and stopped and started the SQL server, but to
> no avail. And it gets wierder. If I change the table name to something else, and
> try to add the stored procedure, it says that that newly named temp teble
> already exists too!!! And I haven't even run the procedure to execute the CREATE
> TABLE....

> I am at my wits end - can anyone help??

> Thanks in advance

> Andrew

Thanks - you pointed me in exactly the right direction......

Andrew