-
Does anybody know how to suppress the '(20 Rows affected)' messages that are given when, for example, inserting some rows into a table?
I'm using SQL Server a Stored Procedure on SQL Server which Inserts data before joining Inserted data in a further select. When called the procedure executes the Insert, which says 'ah ha I've affected n rows'; the calling line from VBScript then receives a null recordset which sort of screws things up a bit!
Any ideas?
-
No Worries
It's okay no need for assistance, just come across (not literally! I'm no deviant - well not to that extent) a likkle command called 'NOCOUNT'.
Everything is dandy now.