Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitch0219
Starting Member
4 Posts |
 Posted - 2011-08-23 : 09:45:41
|
Hi Guys,Is there some kind of a script or SP where i can identify any changes made to all tables within a database on a give date ?my database crashed due to a data entry, we have around 400 tables, I was wondering if there is a way to write a SP to give me a list of changes that were made to any of those tables on a particular date.Thank You so much !  |
|
|
gwilson67
Starting Member
42 Posts |
Posted - 2011-08-23 : 22:11:27
|
| Yes there is a script that can tell you what has changed to a particular date/time. Are you uusing SQL Server 2008?Greghttp://www.freewebstore.org/tsqlcoderepositoryPowerful tool for SQL Server development |
 |
|
|
|
|
|
Script to analyze changes