Patrick Ge (6/19/2013)
Thanks for sharing. I have a similar monitoring in place using event notification but it's much simpler than yours. I only monitor changes to functions, stored procedures for selected databases (purely because of the requirements). Event notification is just awesome.
Thanks, I started with a limited set - then it became difficult to manage with all the 'cases' of what data to capture. So a generic 'just-the-facts' system seemed in order.
Event Notification is great - for procedures (you mentioned) I include the "Trace" events and track when each procedure is loaded into/ unloaded from the cache - Lets me track in-use, last used, details about procedures (Over time I should get an indication of the legacy junk that has accumulated)