WOW... I finally got around to checking some of my cursor code to make sure I was using those declaration flags he mentioned and sure enough I wasn't.

My sprocs executed...

I wanted to follow up and thank you guys for the suggestions and let you know what I did.

We've upgraded to SQL2000, and are getting a better handle...

I always avoid cursors but they are, unfortunately, necessary sometimes. I did notice a huge difference between SQL7 and SQL2000. SQL7 would just fold in two as soon as you tried...