What is the best way here? Triggers or transactional replication?

I know how to create the triggers? but is it a suggested procedure? i feel that if the records are...

i agreed by the suggestion given by David.  I also have thought about that.  But what about Updates.  i also need rows that have been updated.

the commands specified above cannot be used as i do not have a VFP database (.dbc).  I only have the .dbf which is a foxpro data file

no it didnt help.  Actually i m able to access the MSaccess data (.mdb) from Query Analyzer but i am not able to connect to the foxpro database.

I m using...

Binu - Reply by Sushila will give you duplicate records only.  If you want to see the distinct column value then you can use the following query:

Select distinct Column from...

Foxpro database does not have a BBF extenstion instead it has DBF extension.  if you have a DBF file then it can be imported using the import and export wizard...

i do not have the backup and begin transaction command was not issued before update.  I have heard that updates can be rolled back through transaction logs.

you can execute the query like this in QA.  The output will be stored in the c:\file.txt

DECLARE @cmd varchar(130)

SET @cmd = 'bcp ' + '"' + 'select * from pubs..titles'...

you can use master..xpcmdshell with bcp.exe.  something like this

for syntax pls refer to help on xp_cmdshell and bcp

This may help you