Yes, you are correct. It's even more important for ADO access because you can get errors under some circumstances if there's no SET NOCOUNT ON in SP.
>Just so I am 100% clear on this <s>. If I connect to a database using OleDb or something and then execute a stored procedure the server will tell the client "nn rows affected" as many times as I have update statements in my SP (If I don't SET NOCOUNT ON)?
>
>If that is the case it is very important to SET NOCOUNT ON in every SP (unless you are debugging <s>)
>
>Please correct me if I made and wrong statements.
--sb--