How can we help you today? How can we help you today?

Format SQL Errors with CREATE SERVER AUDIT SPECIFICATION

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
NicCain
0

Comments

1 comment

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

Add comment

Please sign in to leave a comment.