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
I am at my wits end - can anyone help??
Thanks in advance