只是想知道更新命令发生后是否可以查看表上的更改?
just wondering if it is possible to view the changes of an update command on a table after it has happened?
交易日志会存储此类信息吗,即这是先前/当前值,这是新/更改后的值
would the transaction log store this kind of information i.e this is the previous/current value this is the new/changed value
不确定是否可行.服务器是ms sql 2008
not sure if this is possible. the server is ms sql 2008
推荐答案事务日志中确实包含信息,尽管对其进行解码并不容易-我写了一篇博客文章,其中包含对事务日志中的简单更新语句进行解码的示例- sqlfascination /2010/02/21/decoding-a-simple-update-statement-in-the-transaction-log/
The transaction log does contain the information, although decoding it is not trivial - I wrote a blog post with an example of decoding a simple update statement in the transaction log - sqlfascination/2010/02/21/decoding-a-simple-update-statement-within-the-transaction-log/
但是,根据正在执行的更新,日志中的条目会变得更加复杂,并且没有有关如何对其进行解码的文档.对它们进行逆向工程非常困难.
However, depending on the update being performed the entries in the log get a lot more complex and there is no documentation available on how to decode them. Reverse engineering them is quite difficult.
我永远不建议使用这种检查日志的技术来检索数据,仅从内部学习/法医的角度来研究它是值得的.
I would never recommend that this technique of inspecting the log is used to retrieve data, it is only worth looking into from an internals learning perspective / forensic perspective.
更多推荐
在更新语句后查看更改的值
发布评论