sql server - Why there is an extra "(1 row(s) affected)"

Question

The SSMS shows an extra (1 row(s) affected) every time when I execute insert/update. For example, execute the following SQL

declare @a table (a int)
insert into @a values (1), (2)
update @a set a = 3 

And the SSMS will display the following message.

(2 row(s) affected)

(1 row(s) affected)

(2 row(s) affected)

(1 row(s) affected)

I didn't find any database/server trigger. What could cause the extra (1 row(s) affected)?

Answer 1

That usually means you have the actual execution plan option turned on. The execution plan is sent as an extra rowset, resulting in an extra (1 row(s) affected) message.

To disable actual execution plan press Ctrl+M.