personally i think it's a bug... if you strip the sp code down to:

Return (Select count(*) From MyTable);

Return -1;

you get -1 for the...

very interesting thread...

nobody's mentioned xp's yet.

i've never used them so i don't really know, but it seems to me that your proprietary logic might be embedded into an extended stored...