>> FWIW, I don't think we use sql cursors in *any* of our SP's (or triggers) ... we use temporary tables. I guess this must be the reason why!
temporary tables can be just as problematic as cursors, especially if they're created via SELECT INTO.
While, in general, you'd like to stay away from cursors, sometimes it the only want to get down what needs to get done. In that case, your best bet is to use the FAST_FORWARD option on the cursor.
-Mike