question

Katie 1 avatar image
Katie 1 asked

auditing mechanism in SQL SERVER 2008

Hello, Is there any utility or stored procedure available in SQL SERVER 2008 where i could see all the user activity ,like what that particular user is doing with the DB? Auditing like Login, schema changes, inserts, logout. I know i could use profiler to some extent so see the login activity at the server level, not sure if it works at the DB level too .But is there any other way could see the specific user activity ?
sql-server-2008security
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
DaniSQL avatar image
DaniSQL answered
SQL server 2008 has a built in feature and on how to set up auditing see this articls [here][1], [here][2] and [here][3]. To see whats happening in your server and get a detailed information about the sessions running on your SQL Server you can use Adam Machanic's [sp_whoisactive][4] stored proc [1]: http://msdn.microsoft.com/en-us/library/dd392015(SQL.100).aspx [2]: http://www.bradmcgehee.com/2010/03/an-introduction-to-sql-server-2008-audit/ [3]: http://www.simple-talk.com/sql/database-administration/sql-server-audit-magic-without-a-wizard/ [4]: http://sqlblog.com/blogs/adam_machanic/archive/2009/12/03/who-is-active-v9-57-fast-comprehensive-dmv-collection.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.