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 |
|
manju3606
Yak Posting Veteran
78 Posts |
 Posted - 2011-10-27 : 08:41:13
|
| Hi to all,I have 10 years data in database now what i want is i want to know witch data is inserted on witch date. But but .. in my database there is no information regarding inserted data means no one table has column like datetame , modify date or TIMESTAMP . So now please can any one tell me how can i get the inserted information. ThanksManju |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-27 : 09:05:50
|
| Unless there's something on the table to give the info or cdc is enabled for it then you are probably stuck.Other options are looking at the transaction log or restoring backups and doing diffs on the data.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Inserted data information in table