FOR THE RECORD:

I was disapointed only two people on this forum tried to help solve my problem, thanks guys the input was appreciated.  I have now found the solution (or...

Ive looked into this before and never got it quite working...

the syntax you posted didnt quite work (iam SQL2000 if it helps)

I had to change it to this:

CREATE PROCEDURE TEST_ROW_COUNT

@SQLeval...

The problem is, Iam doing a large amount of dynamic SQL, I cant use a temp table to eat the output as I dont know the exact column definition of...