October 24, 2005 at 9:30 am
What is the best way to see which views and stored procdures have changed in the last month?
October 24, 2005 at 9:47 am
Implement change management and see what you changed. other than that sql server doesn't keep that info.
October 24, 2005 at 9:48 am
You'll need a third party program.
Ortherwise you could try to script out all views, stored procedures and run a text-difference analyzer on it.
October 24, 2005 at 11:17 am
Or restore a copy of the db from a month ago and use a third-party differencing program to compare this db with the current version and highlight schema differences.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply