且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在SQL Server中查找记录插入时间

更新时间:2023-01-22 17:07:24

所有事务(插入,删除,更新)都记录在MS SQL Server中,您可以使用事务日志文件查看器查看它们的发生时间. />
请记住,其中一些非常昂贵,有些存在兼容性问题,因此请自己寻找合适的一款:

http://www.red-gate.com/products/dba/sql-log-rescue / [ ^ ]

http://www.apexsql.com/sql_tools_log.aspx [
All of the transactions(insert, delete, update) are logged in MS SQL server and you can see their occurrence time with transaction log file viewers.

And remember that some of them are very expensive and some have compatibility problems so search for suitable one for yourself :

http://www.red-gate.com/products/dba/sql-log-rescue/[^]

http://www.apexsql.com/sql_tools_log.aspx[^]


请参阅:

http://www.sqlservercentral.com/Forums/Topic855408-8-1.aspx#bm855753 [ ^ ]
Refer this:

http://www.sqlservercentral.com/Forums/Topic855408-8-1.aspx#bm855753[^]


查看此内容

http://***.com/questions/6175326/how-to-find-the-time-of-a-row-updated-into-a-table-in-sql-server-2005 [
See this

http://***.com/questions/6175326/how-to-find-the-time-of-a-row-updated-into-a-table-in-sql-server-2005[^]

EDIT------>

In that link this is there

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