• Tara (8/31/2009)


    I am getting blank.

    If you are getting blank using fn_get_sql then probably your query has zero cost plan, hence not stored in cache. If you turn on flag 2861(By default its off) then SQL text with zero cost plan will be stored in ur memory and hence fn_get_sql will print something. But after you are done, I think u should turn off this flag.