END CATCH appears on two lines in the Results

I have sql like:

 BEGIN TRY
 ...
 END TRY
 BEGIN CATCH
 ...
 END CATCH

After getting an estimated plan, I get two lines in the statement tree:

 END CATC
 H

alt text

avatar image By gbritton 93 asked Sep 14, 2016 at 08:18 PM
more ▼
(comments are locked)
avatar image Aaron Bertrand ♦ Sep 14, 2016 at 08:36 PM

Thanks, I can repro this issue, we'll investigate.

avatar image Aaron Bertrand ♦ Sep 19, 2016 at 03:25 PM

It seems that this is how the query text is rendered in the XML we received from SQL Server - there is a carriage return and line feed in that very spot, which makes it render that way in our statement tree.

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x455
x39
x1

asked: Sep 14, 2016 at 08:18 PM

Seen: 325 times

Last Updated: Sep 19, 2016 at 03:25 PM