Track last row of table

Question

Hi Sir i want to know how can i track the changes or identify the latest Insert Update and Delete from table ?

Senthilkumar · Answer

Hi Shubham In SQL Server 2005 and earlier versions there is no inbuilt functionality to know which row was recently changed and what the changes were. However in SQL Server 2008 a new feature known as Change Data Capture (CDC) has been introduced to capture the changed data For detailed explination with examples please visit http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/