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

Question

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)

Matthieu Cormier · Accepted Answer · 2019-02-11 14:29:06Z

101

Use:

SET NOCOUNT ON

to suppress these messages and use the command below to enable the messages.

SET NOCOUNT OFF

2,2051 gold badge23 silver badges34 bronze badges

answered Sep 4, 2009 at 3:29

9,6586 gold badges43 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Av Pinzur · Accepted Answer · 2009-09-04 03:28:29Z

22

run this command:

set nocount on

answered Sep 4, 2009 at 3:28

2,22815 silver badges15 bronze badges

...everywhere! stored procs, triggers. the lot