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

TSQL Format of Extended Event leads to syntax error

Hi,

Currently trying to format code like
ALTER EVENT SESSION [QuickCapture_BatchCompleted] ON SERVER
STATE = START
or like
ALTER EVENT SESSION [QuickCapture_BatchCompleted] ON SERVER STATE = START
by pressing Ctrl+K, Ctrl+Y

results in
ALTER EVENT SESSION [QuickCapture_BatchCompleted] ON SERVER;
STATE = START
or
ALTER EVENT SESSION [QuickCapture_BatchCompleted] ON SERVER; STATE = START
which isn't valid syntax.

The result should be
ALTER EVENT SESSION [QuickCapture_BatchCompleted] ON SERVER
STATE = START;
or
ALTER EVENT SESSION [QuickCapture_BatchCompleted] ON SERVER STATE = START;

SQL Prompt version 8.0.9.2226

Comments

Sign In or Register to comment.