Logon Triggers Not Supported
I am unable to use SQL Prompt's autocomplete features within a logon trigger. Is there any way this can be supported?
use master go create trigger [trgAudit] on all server for logon as begin -- can't declare any @vars using autocomplete declare @var int = 1 -- can't write an IF statement, like below if (@var = 1) begin select 1 end end
0 · Share on Twitter