Hi Dave,

Thank you. I am trying this right now on sql serve 2008 R2. I can see the Rowcounts option in profiler, which is great. However, when I run the proc via the web application, I see a number 127 being displayed in profiler whereas when I run the actual procedure, its only 48 rows.

Interestingly if I profile the same proc via query analyzer, there is a column called Integer Data which seems to return a value that matches the output rows from my proc.

I will keep investigating.

Thanks,

Sainath