Home Forums SQL Server 2008 SQL Server 2008 - General Cursor fetch loops endlessly RE: Cursor fetch loops endlessly
David Burrows
SSC Guru
Points: 65138
More actions
November 22, 2013 at 7:28 am
#1668404
Gavin Lock (11/22/2013)You might be bumping into the Halloween Problem.I was able to repro your problem like this:
Gavin Lock (11/22/2013)
I was able to repro your problem like this:
Changing the cursor to STATIC will stop your query looping.
Far away is close at hand in the images of elsewhere.Anon.