//this is the line that does it Close tableCursor1 since i deallocate the cursor anyway, I think for now I just won't close it. That way my code will work. If any SQLServer7 gurus think this is a dangerous thing to do, let me know. I'm pretty new to this whole stored proc paradigm. thx, -jonb