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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply