when you execute a T-SQL statement (INSERT, UPDATE, SELECT, DELETE) in a new query window, you see a message that says how many rows affected in the result window. How to disable this?
SET NOCOUNT OFF
SET XACT_ABORT ON
SET NOCOUNT ON
SET XACT_ABORT OFF