Anakim
Oct 20th, 2000, 04:55 AM
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?
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?