开发者

SQL Server 2008: Can I view past user actions?

I am fairly new to SQL Server administration and was wondering if there is a way to query the system to开发者_开发知识库 track user actions. The user has appropriate permissions. I would just like to see what they are doing each day.

I'm wondering two main things: 1) Can I see a history of tables they've only VIEWED? 2) Can I see a history of tables they've MODIFIED (insert, update, delete)?

Many thanks in advance!

-->> S.K.


I know the following approach:

  1. Launch SQL Server Profiler to write logs
  2. Enable Auditing
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜