How to stop SQLServer writing extraneous stuff eg (1 rows affected)

Viewed 39206

Is there a command I can run inside my SQL script so that it stops outputing information about each operation that gets run?

ie I don't want to see this:

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
2 Answers
Related