Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am using SQL server 2008 but still in my sql server management studio I dont have audit option under the Security menu though login, Server Rols, Credentials are there.Why?
alt text

share|improve this question
    
AH, you aren ot using SQL Server 2008. As per Brian you are running a prerelease version that you never updated to the "real" one. And likely - you also dont run an enterprise version. –  TomTom Dec 6 '13 at 17:15
add comment

migrated from stackoverflow.com Jul 23 '10 at 12:50

This question came from our site for professional and enthusiast programmers.

2 Answers

Hmmmm.... your server version is 10.0.1442, which is a pre-RTM build version. Are you running a CTP version of SQL Server. SQL Server 2008 RTM was build 10.0.1600. My guess is that you have a pre-release version of SQL that did not yet include that feature. I would install a post-release version, preferably at least SQL Server 2008 + SP1 (10.0.2531). I think you find the feature then.

share|improve this answer
add comment

The feature is built on top of Extended Events and audits server and database events and groups of events. Database level auditing is supported only by the Enterprise and Developer editions. In SQL Server 2012, all editions support server level audits

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.