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
精彩评论