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
Post a Comment