开发者

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

开发者 https://www.devze.com 2023-03-09 00:34 出处:网络
Is it possible to find the time when the row was updated into a table. For Example IDNAMECOURSE ------------------

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

0

精彩评论

暂无评论...
验证码 换一张
取 消