Thank you very much for your answers and your time.


>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.