Ahhhh, got it, just read BOL about Fetch. It is sort of like an array with pre-defined functions (next, first, last). Nice ...

J

Thanks, no, I don't need one, I just wanted to understand what they do.

J

Thanks SQLBill,

How long did you wait after you put it in single user mode? If users are still hitting the DB will single user kick in? ...