has anyone ever encountered this problem where they have a stored procedure which runs perfectly fine the first time you run it(takes 14 seconds) but say if i try and run it again afterwards (i.e. 2 mins or 2 hours later) it seems to get stuck in a loop and i have to cancel the job and then start it again which basically means the job is useless.
The stored procedure its running is simply updating a view.
SP RUNS ONCE THEN GETS STUCK IN A LOOP
Posted - 08/09/2007 : 09:26:42
