Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kappy
Starting Member
30 Posts |
 Posted - 2002-05-29 : 14:12:12
|
| Hi-This problem has occured a few times, and I don't know the cause. When I create a stored procedure that uses temp tables, I receive the following error:Msg 267, Level 16, State 1Object '#tempCustomer' cannot be found.The procedure is basically a large select statement, and typically I work with temp tables when creating the statement and then compile it into a stored procedure. Once I try to run the procedure the error comes up. Is it something I'm doing wrong? When I change the name that I'm using for the temp table to something else, it works fine. I am using 6.5.Thanks!Edited by - kappy on 05/29/2002 14:16:32 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-05-29 : 14:19:22
|
Well ... let's see the stored procedure! Our crystal balls are on the blink  setBasedIsTheTruepath<O> |
 |
|
|
|
|
|
Temp Table cannot be found