--Start counting messages and show number of rows affected SET NOCOUNT OFF --Stop counting messages and do not show number of rows affected SET NOCOUNT ON