asked
Error:: Auditing in Sql server 2008 r2 Standrad edition
I am trying to do auditing in sql server 2008 r2 but iam not able to perform audit. ** IN ERROR It says auditing is not available in this edition of sql server**. But what msdn link says [
http://technet.microsoft.com/en-us/library/cc280525(v=sql.100).aspxit][1] works fromm sql server 2008 r2. how to know what is the problem to my server/does it really doesn't work in sql server 2008 r2!!!!!. -->May be i think it doesn't work in standard edition sql server,maybe it work in higher editions of sql
server.Is it right Correct me if iam wrong. what is possible way to do auditing in sql server 20088 r2. I am attaching images for information what is problem. ![alt text][2] ![alt text][3] [1]:
http://technet.microsoft.com/en-us/library/cc280525(v=sql.100).aspx [2]: /storage/temp/1766-audit+failure.png [3]: /storage/temp/1767-my+sql+server+version.png
SQL2012 and later have some basic auditing for server, but in SQL 2008 it's an Enteerprise feature. "All editions of SQL Server support **server level audits**. Database level auditing is limited to Enterprise, Developer, and Evaluation editions." [
http://msdn.microsoft.com/en-us/library/cc280386.aspx][1] If you need audits in SQL Server 2008, you could use Extended Events. Read more about Extended events at: [
http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/01/a-xevent-a-day-31-days-of-extended-events.aspx][2] [1]:
http://msdn.microsoft.com/en-us/library/cc280386.aspx [2]:
http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/01/a-xevent-a-day-31-days-of-extended-events.aspx
It was my first thought too, but according to MSDN it should work with server level audits, but the link is for SQL 2014 and maybe it was an Enterprise feature in SQL 2008R2.
The 2008 R2 version of the link specifically mentions that it is Enterprise Edition only -
http://msdn.microsoft.com/en-us/library/cc280386(v=sql.105).aspx
I got the Answer it is What i taught.Auditing doesn't work on standarad edition and below editions. It works in Enterprise Edition only.
15 People are following this question.
