>
I was under imptression that SET NOCOUNT doesn't affect actual result set return. What's the reason for turning it off in this case?
<

The SQL Select might be used for populating an intermediate result-set, one that you don't want returned to the client...