SET NOCOUNT ON set as default on server level

[daglugub37]

I am looking to change the default of SET NOCOUNT OFF to SET NOCOUNT ON..

in other words although there are thousands of stored procs on a DB that are not implying either way so the default is used...I am hoping to change the default instead of updating these stored procs. In the interest of improved network performance.

Also if this is possible to set on the server level; is there other factors? ie. connection ODBC settings?

 

[mrdenny]

SET NOCOUNT ON is not a server setting. It is a connection setting. You will need to modify the procs.

How much bandwidth are you planning on saving by changing this?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[daglugub37]

I wouldn't even be able to guess at how much bandwidth this would save. Thanks for clearing up that this is indeed a connection level setting.

I think I am just going to change the new proc template and let the exisinting ones be.

thanks for your help