[研究]SQL Server 那些版本、等級支援伺服器稽核（Server Audit）?
2025-04-02
ChatGPT 說在 SQL Server 中，「伺服器稽核（Server Audit）」功能只有在 Enterprise 版和特定的高階版本（如 Datacenter 或 Developer）才可用，而 Standard 版及更低版本（如 Express）不支援 這個功能。敝人實際測試並非如此。
根據下面網址，至少 SQL Server 2016 有 ，但沒提到要 Enterprise 才支援
https://learn.microsoft.com/zh-tw/sql/relational-databases/security/auditing/sql-server-audit-action-groups-and-actions?view=sql-server-2016
3.2. SQL Server Audit Support in Different Editions and Versions
https://logbinder.helpspot.com/index.php?pg=kb.page&id=79
根據這篇，有更詳細說明
| Edition \ Version | SQL Server 2008 and 2008 R2 | SQL Server 2012 and 2014 | SQL Server 2016* and 2017 |
| Enterprise | Server- and database-level | Server- and database-level | Server- and database-level |
| Developer | Server- and database-level | Server- and database-level | Server- and database-level |
| Datacenter | Server- and database-level | N/A | N/A |
| Business Intelligence | None | Server-level | N/A |
| Standard | None | Server-level | Server- and database-level* |
| Web | None | Server-level | Server- and database-level* |
| Express | None | Server-level | Server- and database-level* |
* Database-level auditing for Standard, Web and Express editions are available starting SQL Server 2016 SP1.
(完)
