Post reply

set statistics io does not stick

  • September 4, 2011 at 1:16 am

    #242653

    At one point, I ran

    SET STATISTICS IO ON

    SET STATISTICS TIME ON

    because, well I needed the information. However after running

    SET STATISTICS IO OFF

    SET STATISTICS TIME OFF

    it didn't obey my command

    every single command I ever ran since I switched it on, I get the statistics displayed, which makes PRINT output pretty difficult to find between all the parse, compile and execution time output

    What am I overlooking?

    Thanks,

    Henk

  • September 4, 2011 at 1:36 am

    #1376835

    In SSMS

    Tools>Options>Query Execution>SQL Server>Advanced

    there are check boxes here for SET STATS....are they on or off?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • September 4, 2011 at 2:13 am

    #1376838

    They were on, now that they're off it's fixed.

    I must have set them to ON at one time.

    Thanks,

    Henk

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

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