how to get todays Inserted and updated records in sql server 2005

[praCash]

Hi Guys,

I have a remote database ie; sql server. I need to get the data every day from that database, I want to get updated and newly created data only and bump in to my db tables on dailybase, but those tables are not having created date and update date columns ,

how i can achive this.?

do i have to read the log data of the table?

Please advice me in this.
Thanks in advance.

Thanks & Best regards
Prakash

[rsrinivasan]

Try to use this utility "tablediff.exe" , which campares two tables and gives some report.

[praCash]

Try to use this utility "tablediff.exe" , which campares two tables and gives some report.

Thanks for the reply.
I will try and let you know the result