Get only updated and newly record

[Abdul Rahman Hamidy]

Dear All, I have a database in MSSQL 2005 which i am doing DDL,DML from c# code. i am looking for a tool in MSSQL 2005 which can i get only updated and newly inserted records in a file, that i can use through my c# code. such a tool is available in MSSQL 2005?

Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan

[Christian Graus]

Put a date stamp on your data, and request data that's been modified or inserted since the last time you asked for it.

Christian Graus Driven to the arms of OSX by Vista.

[Abdul Rahman Hamidy]

would you please provide me more information

Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan

[Abdul Rahman Hamidy]

In fact, what i am doing is, the application which i am developing is used in multiple locations. i have local server and multiple remote servers, I would like to send remote servers updated and newly insertd data via email to local server, and local server should get the data and update the system. I am not going through replication.

Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan

[Shyam K Pananghat]

As Christian suggested add a date column. add one more column named flag. Let say flag 1 is for insert and 2 is for delete 3 fro update.. Use Triggers appropiately to insert these flags and date to your extra columns.. Then you can easily compare at a leter point of time.. and should solve your problem... :)

Shyam.. My Blog dotnetscoups.blogspot.com