如何确定特定 Sql Server 2000 数据库中任何记录的上次更改时间? [英] How can I determine the last time any record changed in a specific Sql Server 2000 database?

问题描述

我有一个很少更新的 SQL Server 2000 数据库实例.我还有一个数据库表，它没有包含每一行的创建日期或修改日期的列.

I have a SQL Server 2000 database instance that is rarely updated. I also have a database table which has no columns holding each row's created date or modified date.

有什么方法可以确定上次对整个数据库执行更新或插入的时间，以便我至少可以确定表中的特定记录何时可能发生更改?

Is there any way that I can determine the last time an update or insert was performed on the database as a whole, so that I can at least put a bound on when the specific records in the table may have changed?

注意:我正在寻找有关已发生交易的信息.如果我将来再次需要触发器，触发器可能会有所帮助，但不能解决我试图描述的问题.

Note: I am looking for information about transactions that have already occurred. Triggers may help we should I require this again in the future, but does not address the problem I'm trying to describe.

如果可以，我该怎么做?

If it can be done, how can I do it?

推荐答案

数据库的日志文件可能包含一些对您的任务有用的信息.AFAIK，数据库本身不存储上次更新"日期.

The database's log file may have some information that is useful to your quest. AFAIK, the database itself doesn't store a "last updated" date.

这篇关于如何确定特定 Sql Server 2000 数据库中任何记录的上次更改时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！