Cursors are basically nasty nasty things that we try and avoid.
They are very resource hungry and slow the server. In some instances they are useful ( like rolling back & forth during updates and the like ) but mostly you can use temp tables and a few WHILE ( ...... ) loops work wonders for speed and flexibility.
Thanks!!! But I'm not using cursors....I thought I was using some, but today I reviewed all my user defined functions and stored procs and i found no one.
My "theory" is this: I'm accessing the DB with ADO 2.7, I mean, with recordsets... Am I wrong, or Recordsets are implemented with cursors ??? Occasionally my app is throwing "Automation Error" (this happens just when opening a recordset), and I have no idea whats the matter... the queries are ok. So, can this be a problem with ADO ?