How to get the deleted rows in a table?

If you are using SQL Server 2008 or 2008 R2 there is a feature called Change Data Capture that you can use.  

Take a look at these tips for the details.

http://www.mssqltips.com/sql-server-tip-category/108/change-data-capture/

Chary,

In addition to Ray's recommendation, here are a few other ideas depending on the situation:

• You can also use triggers (http://www.mssqltips.com/sql-server-tip-category/59/triggers/) depending on the version of SQL Server to capture the data before it is deleted.
• If you have a situation where you have data deleted in your production environment and an earlier version of the exists in disaster recovery, you could use a comparison tool to determine the data differences.  Here are some of those tools - http://www.mssqltips.com/products.asp?catid=27.

HTH.

Thank you,
Jeremy Kadlec