locked
Is SQL Audit at database level only for Enterprise Edition? (SQL 2012) RRS feed

  • Question

  • Hi All,

    Question: Is SQL Audit at the database level possible in other versions of SQL 2012 besides Enterprise?

    The 70-462 exam guide states on page 250 that "Only SQL Server 2012 Enterprise edition supports database-level auditing in production environments."

    The root of my confusion is the part about "production environments."  Are they referring to database-level auditing working also in Developer edition?

    Thanks,
    Eric

    Wednesday, November 12, 2014 12:48 AM

Answers

  • Hello Eric,

    see Features Supported by the Editions of SQL Server 2012 => Security: Yes, the "Fine Grained Auditing" is only available in Enterprise Edition.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Ashwin Menon Wednesday, November 12, 2014 10:55 AM
    • Marked as answer by SQL Server dude Wednesday, November 12, 2014 5:46 PM
    Wednesday, November 12, 2014 6:26 AM
  • Hi.

    All editions of SQL Server support server level audits. Database level auditing is limited to Enterprise, Developer, and Evaluation editions.

    Refer below MSDN article.

    SQL Server Audit (Database Engine)

    database-level auditing working also in Developer edition?

    Yes developer edition does support all the features of Enterprise version, but as per licensing is concerened you can not use developer edition on your production servers.


    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page

    • Proposed as answer by Donghui Li Wednesday, November 12, 2014 9:04 AM
    • Marked as answer by SQL Server dude Wednesday, November 12, 2014 5:46 PM
    Wednesday, November 12, 2014 6:55 AM
  • Thank you both!  Sometimes the typos in books are very confusing.  I'm glad this one was more obviously confusing than the others.
    • Marked as answer by Donghui Li Wednesday, December 10, 2014 11:16 AM
    Wednesday, November 12, 2014 5:47 PM

All replies

  • Hello Eric,

    see Features Supported by the Editions of SQL Server 2012 => Security: Yes, the "Fine Grained Auditing" is only available in Enterprise Edition.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Ashwin Menon Wednesday, November 12, 2014 10:55 AM
    • Marked as answer by SQL Server dude Wednesday, November 12, 2014 5:46 PM
    Wednesday, November 12, 2014 6:26 AM
  • Hi.

    All editions of SQL Server support server level audits. Database level auditing is limited to Enterprise, Developer, and Evaluation editions.

    Refer below MSDN article.

    SQL Server Audit (Database Engine)

    database-level auditing working also in Developer edition?

    Yes developer edition does support all the features of Enterprise version, but as per licensing is concerened you can not use developer edition on your production servers.


    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    Praveen Dsa | MCITP - Database Administrator 2008 | My Blog | My Page

    • Proposed as answer by Donghui Li Wednesday, November 12, 2014 9:04 AM
    • Marked as answer by SQL Server dude Wednesday, November 12, 2014 5:46 PM
    Wednesday, November 12, 2014 6:55 AM
  • Thank you both!  Sometimes the typos in books are very confusing.  I'm glad this one was more obviously confusing than the others.
    • Marked as answer by Donghui Li Wednesday, December 10, 2014 11:16 AM
    Wednesday, November 12, 2014 5:47 PM