Home Forums SQL Server 7,2000 T-SQL SET NOCOUNT ON isn't working RE: SET NOCOUNT ON isn't working

  • June 29, 2016 at 12:51 am

    #1887502

    Run this query:

    SELECT * from syscomments

    where text like '%NOCOUNT OFF%'

    Some people have a habit to add SET NOCOUNT OFF to the code of their procedures.

    _____________
    Code for TallyGenerator