sp_send_dbmail: avoid (n rows affected)

Question

Calling sp_send_dbmail: successful execution, but at the ends appear an extra line with rows affected by the query.

Is there any way to avoid thiks line?

Thanks!!!

Instead of creating new tags, please see if you can use existing tag. This will make your question more clear — Saju, Feb 11 '13 at 13:36

score 4 · Answer 1 · answered Jul 21 '15 at 17:51

4

What cgsabari says is true but incomplete. You need to set NOCOUNT in the query you are passing to @query parameter. Otherwise it won't work

answered Jul 21 '15 at 17:51

Nicolasllk

score 2 · Answer 2 · answered Mar 24 '14 at 15:05

2

Try the below query

SET NOCOUNT ON
--some queries
SET NOCOUNT OFF

It avoids the row(s) affected message.

answered Mar 24 '14 at 15:05

cgsabari

2 Answers2