我认为你不能使用CDC做到这一点 - 你需要使用触发器或审计功能。 />


基于此建议 [ ^ ]与Microsoft一起登录。



有关审核SQL Server的方法的文章 [ ^ ]

I want see date and time and users that modified data in sql server
I used cdc (Change Data Capture) to trace deleted and updated data in my table. now I whant know when this change is happened and who change data? (user that login in my application)

I don't think you can do that using CDC - you will need to use Triggers or the Audit capability.

Based on this suggestion[^] logged with Microsoft.

Article on methods for auditing SQL Server[^]