SQL Server Performance Forum – Threads Archive

Removing the "rows affected" output line

Hi, When I run my SQL, I get the following displayed (see below). Is there any way to remove the "(x row(s) affected)" line? Thanks in advance, Cheers,
SCG. ======== Example Output ========== (1 row(s) affected) (1 row(s) affected)
Total Number of Transactions Processed : 11 (1 row(s) affected) (1 row(s) affected)
Total Number of Transactions Processed : 6

---

SET NOCOUNT ON will do —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

Excellent! Thanks.

---

]]>