Options

Software crashes when Trigger Code starts with semicolon

Jelluh!Jelluh! Posts: 4
Hi

The Source Control (latest version) crashes when a trigger starts with a ;
For example the code below will let the software crash:
ALTER TRIGGER [dbo].[trgCrashResult]  ON [dbo].[Example]
AFTER UPDATE, INSERT
AS
	;WITH cteTableExpression AS --This line let the software crash
	(
                     .......
        )
        Update ...... etc etc.


Please fix the software that it won't crashes on semicolons or any other characters.
Also please specify (when the software does crash) on which sql object it crashes!
It took me 4 hours to find the object which was causing the problem. :roll:

Rgds
Sign In or Register to comment.