Auditing in SQL Server 2008R2 Standard vs Enterprise RRS feed

  • General discussion

  • My compnay is planning on moving our database to SQL Server 2008 R2. One of our main concerns is database auditing. We have been told that auditing is better and more detailed within the enterprise edition. As we all know, the enterprise edition is a bit costly. Could someone out there let me know what the specific differences in auditing are between SQL Server 2008 R2 standard vs enterprise editions?...Thanks!
    Monday, February 14, 2011 6:19 PM

All replies

  • LNYC,

    If you take a look at the edition comparison page for SQL Server 2008 R2 (http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx), you will see under the Enterprise Security category that Enterprise Edition (EE) for auditing purposed has SQL Audit and also to a lesser extent change data capture (CDC which falls under data warehousing not sure why).

    Standard Edition does not have these features, I advise you to take a look at the comparison website!

    Hope this helps,


    Monday, February 14, 2011 6:32 PM