select

modifieddate

Employee

Thanks for your replay..

My requirement is if any record in any table deleted from via application then I need to cature that record in some where for future reference. I just given example one table strucure like this but idea is I Plan to create one

new table called "deletedrecords"  with Field Name called "SerialNo","TableName","DeletedRecord","CreatedDate","CreatedBy"

Whenever end user click the delete button then immediatly it will give "Table Name" and "Key ID" of the table as input to my SP's . Then I have to Take that record and store it into above table and then delete the record

in the actual table.

So I belive there are lot of query export are here defenitly any one can help me for the same.

1. I have a Table Name and a Primary Key value of the Table

2. Using the Table Name, I can get the Column Name from sys.syscolumns table.

3. Using Key ID and Table name , I can get the a record from that table

4. I don't Know how to contact fieldname and value as I mentioned above?

Please any one help me for the same.

Hi Sql Exports , I realy looking the solution from any one. Please share your thoughts.

is it possible or not?

I would suggest generating an XML document containing all the information on the rows being modified/deleted. This will be easy to generate and query on a later date. For example, you can use a "SELECT * FROM DELETED FOR XML AUTO"  for generating a simple XML document containing all the information in the rows being deleted.