Format SQL Errors with CREATE SERVER AUDIT SPECIFICATION

NicCain

SQL Prompt finds syntax errors where trying to parse the following (which is valid and executes in SSMS without any problems).

/* Create the audit specification for DDL changes */
USE [master]
GO

CREATE SERVER AUDIT SPECIFICATION [ServerAudit_DDL_Changes]
FOR SERVER AUDIT [Server Audit DDL]
ADD (SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP),
ADD (DATABASE_OBJECT_CHANGE_GROUP),
ADD (SCHEMA_OBJECT_CHANGE_GROUP),
ADD (SERVER_OBJECT_CHANGE_GROUP),
ADD (DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP)
WITH (STATE = ON)
GO


SQL build 10.50.1600
SQL Prompt build 5.1.6.35

James B

Thanks for spotting this. I've logged it as a bug for our developers to take a look at (ref. SP-4017)