GilaMonster (12/27/2012)
Bhuvnesh (12/27/2012)
will this option also return value when first time exec plan get created ?Yes
is this option gives the value of 'reason for early termination' when query tried to use same plan for last time ? like if we get "timed out" , does that mean that query coudnt able to generate new plan and used plder one ?
No. Did you do the research?
yes i got few links from "Grant Fritchey" like http://www.scarydba.com/2010/11/18/reason-for-early-termination-of-statement/ but still i have these two questions.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)