david_32
asked on
trigger on a dynamic management view
can you put a trigger on a DMV?
ASKER
I want to see how long an entry stays in the dm_exec_cached_plans DMV. Effectively seeing how long a plan is cached for
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
What are you tring to achieve? Maybe a DDL trigger will do the job:
http://technet.microsoft.com/en-us/library/ms175941.aspx