sql server - SET NOCOUNT ON using ADO is not supressing PRINT messages -


in application using following code:

set ors = oconn.execute("set nocount on; execute mysp;") 

mysp returns print messages , application returning them errors.

how make print messages don't show won't trigger error in application?

i tried set set nocount on; doesn't seem fix it.

set nocount on suppresses (n) row(s) affected message.

to stop print statements executing inside procedure, need remove them print statements procedure definition.


Comments