>To elaborate on Sergey's response, if you don't want a result set, issue:
>
>Set NoCount On
>
>In your stored procedure. It is off by default. When you encounter a statement that should return a result set, be sure to issue
>
>Set NoCount Off
Hi John,
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?
--sb--