TSQL Format of Extended Event leads to syntax error

FatherjackFatherjack Cornwall, Devon, and ReadingPosts: 1 New member
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.