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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-02-12 : 06:02:42
|
| Dear All,is there any way to generate daywise scripts in database? i mean all the transactions wether insert update or delete....i need all the changes on that particular date(with in 24 hours)....is there any procedure or function for this?i've almost 1200 tables in that database.note : due to replication is not possible for my scenario, i'm thinking in different ways to achieve my purpose.this is my requirementhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96959VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-12 : 13:35:49
|
| You can capture them with SQL Trace and save them to a table to later replay on another system.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
is there anyway to generate day wise scripts