SQL Server Performance Forum – Threads Archive
Object Modified DateIs there any possible way to find Table/Stored Procedure modified dates as this would make deploying a whole heap easier for us. Also on another note, what is the best IDE to use for writing stored procedures, we are currently only using Query Analyzer which at times can be cumbersome Thanks
I don’t believe that there is. The system tables don’t store this information. I not found anything better than Query Analyzer personally.
For the modifications of the objects, it would be better if you can deploy third party tools like Lumigent’s LOG EXPLORER or ENTEGRA which is handy tool to monitor. As Dave referred QA is better tool (from SQL 2K onwards) than any other 3rd party tool. Satya SKJ