TSQL Format of Extended Event leads to syntax error
Fatherjack
Posts: 1 New member
in SQL Prompt
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
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
Tagged:
Comments
I've reproduced this issue locally, I'll log a ticket and we'll get a fix out soon
Thanks!
James
Redgate Software