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