Post reply

New SetOpts value in 2012?

  • February 20, 2014 at 11:54 am

    #283819

    Hi,

    we have found the bit value 262144 (included in 262402) for the set_options (setopts in sys.syscacheobjects) in sys.dm_exec_plan_attributes. You can also use Kalen Delaney's excellent view sp_cacheobjects.

    I have not found any description on what that value represent and why this is occurring.

    Leif Haraldsson

  • March 1, 2014 at 12:27 pm

    #1693336

    I found the answer my self. The value 262144 represents a plan that has "SET ROWCOUNT" > 0.

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

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