Over the course of the last few months, I have made several changes (altered) to views used by the application we are installing. I have added fields to many views for reporting purposes and also a few stored procedures.
We are scheduled for an application upgrade In a few days and I have been told the view definitions will be overwritten. So now my problem, How do i find all the views and stored procedures that I have modified so that I can get a copy of them and restore it after the upgrade?
If i could see something like a last modified date ( applying to the view definition and not the last row insertion), i could easily find them instead of manually looking at 1000 views and stored procedures for my comments.
Thanks in advance.