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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2007-10-12 : 08:28:36
|
Hi,I'm using sql server database engine tuning advisor, and its reporting a bunch of syntax errors. I'm not getting any errors in my apps, and when I manually execute the sprocs from QA they aren't erroring out either. Is this something to be concerned about ? Here is an example error(the Index 'IX_Paths' on table '#Paths' is a temp table , perhaps thats why its reporting error? or perhaps I messed up the code somehow ? )Thanks very much for any help!mike123E000 exec uspDijkstraResolve @fromID=157504,@ToID=697395 1 [Microsoft][SQL Native Client][SQL Server]Index 'IX_Paths' on table '#Paths' (specified in the FROM clause) does not exist. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-12 : 09:29:54
|
| Maybe #Paths was created within a session, that session didn't get closed, and that table has persisted into the next session?Stop / start SQL Server (if you can) would kill anything & everything like that off, and you could try again.Kristen |
 |
|
|
|
|
|
Tuning logs showing errors