How to find the time of a row updated into a table in Sql Server 2005?

Is it possible to find the time when the row was updated into a table. For Example

  ID            NAME               COURSE                   
 ----          ------             --------
  1            SACHIN              B.TECH
  2            AJITH               B.开发者_如何转开发E
  3            ASIN                M.TECH

I want to find at which time, I updated the 2nd row of a table. Not only for Updating, but also during Insertion and Deletion. Is it possible? How?

Unless you run a trace when the changes happen it is not possible.

You can use SQL Profiler

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services. You can capture and save data about each event to a file or table to analyze later. For example, you can monitor a production environment to see which stored procedures are affecting performance by executing too slowly.

SQL Server Profiler

Using SQL Server Profiler