I just couldn't help but laughing when I saw this solution to a problem. Okay, we're running out of "cursors" (ie. because we are not managing them properly). Instead of looking into this leak, just make the max # bigger... sooo smart. *cough*
This kind of crap is what gives software people a bad name. :-(
It's obvious that he knew that he was running out, and that it was set to 255. He probably already knew how to change it, since he knew what it was set to. This is just the kind of answers you get out of people who weren't trained very well. There's a lot of people who don't really know that much, but passed some certification course, and can spout off about various technologies, but not really know what they are talking about.
ReplyDeleteAnyway, to properly answer this question, you'd need a lot more information. Like how many users/queries are running on this thing. Without that simple amount of information, you can't possibly know whether 255 cursors is enough, and whether or not to even bother looking for ways to cut down on usage of cursors, or whether you should just increase the max.