我可以找到对数据库结构/过程进行特定更改的用户吗？
我试图找出对 Microsoft SQL 2008 R@ 数据库结构进行特定更改的人（我有一个已更改的过程）..假设我有 DBO 访问权限，这可能吗？是否有任何类型的日志可以向我显示进行更改的人员的 SQL/Windows 登录用户名、他们进行更改的时间以及他们进行了哪些更改？服务器的 IT 管理员可以使用此类日志吗？如果有的话叫什么名字？
谢谢！
I am trying to find out who is the person who did a specific change on the Microsoft SQL 2008 R@ database structure (I have a procedure which was altered).. given I have a DBO access, would that be possible? Any kind of logs to show me the SQL/Windows logon usernames of the people who did changes, when they did them, and what changes they made? Would such log be available with the IT Administrator of the server? What is it named if any?
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
简短的回答是，除非您在发生更改时已经有一些审核系统，否则您无法查看更新的历史数据。
您可以做的是尝试使用一些第三方工具（例如 ApexSQL Log ）读取事务日志并检查是否t 中的某处写有类似的信息。日志。
我知道事务日志中写入了很多可用于审核的历史数据，但我不能 100% 确定是否能找到用户名。
如果您想设置一个系统来跟踪此情况，您可以尝试 DDL 触发器、SQL 跟踪 等等...
Short answer is you can’t see historical data for updates unless you already had some auditing system in place at the time change happened.
What you can do is to try reading transaction log using some third party tool like ApexSQL Log and checking if there is info like this written somewhere in t. log.
I know there is a lot of historical data written in transaction log that can be used for auditing but I’m not 100% sure about finding username.
If you want to setup a system that will track this going forward you can try DDL triggers, SQL Traces and more…
或许可以使用默认跟踪。查看以下博客：
http://www.eraofdata.com/blog/tag/ default-trace/
向下滚动到“示例 5：找出谁进行了更改”
It might be possible to use the default trace. Check out the following blog:
http://www.eraofdata.com/blog/tag/default-trace/
Scroll down to "Example 5: Finding out who made changes"