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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Inserted data information in table

Author  Topic 

manju3606
Yak Posting Veteran

78 Posts

Posted - 2011-10-27 : 08:41:46
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.



Thanks

Manju

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-10-27 : 09:12:49
Duplicate
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=167229

==========================================
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.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2011-10-27 : 09:24:48
In other words...Don't Cross Post....only post once

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

paultech
Yak Posting Veteran

79 Posts

Posted - 2011-10-27 : 11:22:43
Ok i thought that you can use the orinary SQL Server Transaction Log:to get these type of information ,So please check the link below

http://www.databasedesign-resource.com/sql-server-transaction-log.html

paul Tech
Go to Top of Page

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-10-27 : 11:37:19
Still a duplicate. (and who keeps 10 years worth of tr log - see the other thread).

==========================================
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.
Go to Top of Page
   

- Advertisement -