如何找到上次更新特定行的人？ [英] How to find who updated a particular row last time ?

问题描述

上次有可能找到上次改变桌子特定行的人吗？

是否有可能找到谁是用户登录数据库并上次执行了一些SP？

是否可以在特定日期从LOCAL系统连接到LIVE数据库？

< br $> b $ b



很多谢谢

Hi,

Is it possible to find who altered last time a particular ROW of a table last time ?
Is it possible to find who are the user logged into database and executed some SP last time ?
Is it possible who are connect to LIVE database from LOCAL system on a particular day ?



Many many Thanks

推荐答案

假设你不是说要自己记录信息，但希望SQL服务器为你做这些，看看这里：在SQL Server 2008中进行审计 [ ^ ] - 它可能并不完全是您想要知道的，但它至少可以帮助您快速解决所需的问题！

Assuming that you don't mean to record the information yourself, but want SQL server to do it for you, have a look here: Auditing in SQL Server 2008[^] - it may not be exactly what you want to know, but it shoudl at least get you up to speed with want questions you need at ask!

您可以在表格中添加两个额外的列l捕获上次修改的用户和上次修改时间。您必须在更新表时将登录的用户名和更新时间传递给数据库。

谢谢

Hi,
You can add two extra columns in table which will capture the last modified user and last modified time. You have to pass the logined user name and updated time to the data base while updating the table.
Thank You

您好，



您可以在表格中添加两个额外的列，这些列将捕获上次修改的用户和上次修改时间。您必须在更新表时将登录的用户名和更新时间传递给数据库。



谢谢

Hi,

You can add two extra columns in table which will capture the last modified user and last modified time. You have to pass the logined user name and updated time to the data base while updating the table.

Thank You

这篇关于如何找到上次更新特定行的人？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！