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:
- Launch SQL Server Profiler to write logs
- Enable Auditing
精彩评论