Post reply

set nocount off

  • September 11, 2008 at 3:21 am

    #382620

    Is it necessary to set nocount off at the end of a Stored Procedure ? What it can have if it is not set to off ?

  • September 11, 2008 at 4:30 am

    #870194

    I would have expected it revert when the stored procedure has ended, and SQL Server Magazine seems to confirm this:

    "The SET NOCOUNT ON statement remains in effect until the stored procedure or batch containing it ends or until the SET NOCOUNT OFF statement is executed. ..."

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply