469,148 Members | 1,333 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

stored proc runs with error after reboot.

I wrote a medium length stored proc that uses both temp tables and one
cursor.
I compiled and it ran fine.
However, we reboot our machine every weekend, and on Mondays the
stored proc gets the following errors :

Infinite loops on cursors (can't fetch the next record. Gets stuck on
one record)

AND

this message :
DBMS message: state 2. Error Code 107.
The column prefix '' does not match with a table name or alias name
used in the query. DBMS reported a severity level 16 error.

Once you go back into the proc and save it, it runs fine the rest of
the week until the next reboot on the weekend.

We tried writing the code with a creat... with recompile, but no dice.

Any ideas ????

We are running an old version of MSSQL server (6.5)

help!
Jul 20 '05 #1
0 1103

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by C Kirby | last post: by
4 posts views Thread by Nyul | last post: by
reply views Thread by mirandacascade | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.