Originally posted by belewe92614
My stored procs go into an endless loop @ once every month. When I restart the database all goes back to normal.
Any idea on why this is happening or how to avoid it?
Thanks so much
S1 It is not clear what you mean by "go into an endless loop". Are you using recursion in stored procedures, triggers, both, or do you mean something else entirely? Try posting one or more of the stored proc tsql along with the appropriate table, etc. ddl tsql.