How to stop SQLServer writing extraneous stuff eg (1 rows affected)
Use:
SET NOCOUNT ON
to suppress these messages and use the command below to enable the messages.
SET NOCOUNT OFF
run this command:
set nocount on
Use:
SET NOCOUNT ON
to suppress these messages and use the command below to enable the messages.
SET NOCOUNT OFF
run this command:
set nocount on