July 20, 2010 at 8:35 am
Hi,
We have a situation on SQL 2008 where there were a number of updates made by the dev team that need to be rolled back.
Is there any easy way to see (query) what stored procs were altered in the last 24 hours and what was altered? Or is this something that we should have prepared for in the first place?
Thanks,
Matt
July 20, 2010 at 8:54 am
Your only real option at that point once the damage is done and you have no trail is to get a log reader and see if that can find the offending transactions and undo them. It's a third party software package purchase. Otherwise, yeah, you have to plan for that sort of thing and protect against it.
July 20, 2010 at 8:56 am
Bad news, but thanks for the direction...
July 20, 2010 at 8:57 am
Another thing you might do is restore a prior backup someplace and find a SQL compare type tool to at least see what was changed in the procs. Red Gate SQLCompare is awesome for that.
July 20, 2010 at 8:57 am
Well, you should always be prepared by the form of backups. The justification of course being for what you are dealing with now and the loss of time and $$.
To view create and modify dates on stored procedures, you can use the following query.
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
As far as knowing exactly what was changed... well, you would need to restore a prior version to a new or staging database and compare. Of course, this solution would shift depending on what you have for backups. (standard backups or snapshots)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply