We don't have any direct option in SQL Server
But, we can use either one of the following options
1. You can use Database snapshot and Identify the changes since the snapshot was created.
2. You can use CDC (Change Data Capture) in SQL Server 2008
3. You can use FN_DBLOG(NULL,NULL) to read Log records until shrink/clear the transactions
4. You can use Tracing Trigger and track the changes
Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions
Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator