User Monitoring On 2008R2

SQL Server Administration
1

Morning all,

Just a thought, is there any way to monitor what the users are doing/accessing/updating in 2008R2 Management Studio...?

Thanks

Dave

2

SQL Server Auditing is one way

3

You can use a couple of other methods. Take a look at http://www.dcac.co/applications/hosted-by-you/sp_who3