Hi,

I am using SQL Server 2012.

I have multiple inserts and updates in my procedure. I have 'set nocount ON' in the beginning of the procedure. But, everytime I execute my procedure I end up getting number of rows affected message

Is there any way to switch it off or is this a bug to be rectified by Microsoft or is there a patch available that I can download to fix this or is anything wrong with my code 🙂 ?

Any help would be greatly appreciated?

Regards

Rathi