SQL Server 2008 R2标准缺少“审计"文件夹在SSMS中? [英] SQL Server 2008 R2 standard missing "Audits" folder in SSMS?

问题描述

我将以我不是DBA的事实为先兆！

I will pre-cursor this with the fact that I am NOT a DBA!

我正在尝试在SQL Server 2008 R2 Standard版上设置审核，但是安全性"部分缺少审核"文件夹.

I am trying to set up auditing on an SQL Server 2008 R2 Standard edition, but the Audits folder is missing from the Security section.

这是仅在企业版和数据中心版中与细粒度审核"相关的版本问题吗?

Is this a version issue associated with the "fine-grained auditing" that is only in the Enterprise and DataCenter editions?

任何帮助将不胜感激！

推荐答案

根据

According to Features Supported by the Editions of SQL Server 2008 R2 auditing is only available in 2008 / 2008 R2 Enterprise / Datacenter.

根据各版本支持的功能SQL Server 2012 审核已在SQL Server 2012中进行了拆分，因此现在在Standard Edition中提供了基本审核.

According to Features Supported by the Editions of SQL Server 2012 auditing has been split up in SQL Server 2012, so that basic auditing is now offered in Standard Edition.

所以您所期望的是:在SQL Server 2012之前，审核是仅限企业使用的功能(C2/CCC之外，这只是sp_configure东西，对象资源管理器中未提供).

So what you're seeing is expected: prior to SQL Server 2012, auditing was an Enterprise-only feature (outside of C2/CCC, which is just sp_configure stuff that is not exposed in Object Explorer).

这篇关于SQL Server 2008 R2标准缺少“审计"文件夹在SSMS中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！