如何在SQL Server中查找记录插入时间 [英] How to find record inserted time in sql server

问题描述

如何在SQL Server中查找记录插入时间?表格中没有任何日期字段.

请给我解决方法.

Bye

Hi,

How to find record inserted time in sql server? There is no any date field in the table.

Please give me solution.

Bye

推荐答案

所有事务(插入，删除，更新)都记录在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://stackoverflow.com/questions/6175326/how-to-find-the-time-of-a-row-updated-into-a-table-in-sql-server-2005 [

See this

http://stackoverflow.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.

这篇关于如何在SQL Server中查找记录插入时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！