Printer-friendly versionSend to friendPDF version

When you run stored procedure or queries, you would notice a message on the status bar that shows the number of rows affected. In stored procedure if you set 'SET NOCOUNT ON' then it stops this message from showing and saves substantial amount of time for the run. Reference: http://msdn.microsoft.com/en-us/library/ms189837.aspx