One of the new feature in Microsoft SQL Server 2008 is track the changes on a table. You can enable change tracking on a table using Change Data Capture feature.
Greenbay, Wisconsin’,60000,1000)
Insert into Mytable values (2, ‘Rainbow Colors’,’21, East st,