What are the challenges you face when working across database platforms? Take the survey
Options

Format SQL Errors with CREATE SERVER AUDIT SPECIFICATION

NicCainNicCain Posts: 2
edited July 8, 2011 8:11AM in SQL Prompt Previous Versions
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

Comments

Sign In or Register to comment.