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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply