Post reply

SSMS 17.4 edit query text truncated

  • February 26, 2018 at 5:59 pm

    #333707

    Is there a limit to the number of characters that can be displayed when 'edit query text' is selected on an execution plan?  Can it be changed?

    Attached sqlplan.  When i select 'edit query text' the query is truncated at this part:


    and ( ( jp . coordinator_id =

  • February 27, 2018 at 7:47 pm

    #1981401

    Jackie Lowery - Monday, February 26, 2018 5:59 PM

    Is there a limit to the number of characters that can be displayed when 'edit query text' is selected on an execution plan?  Can it be changed?

    Attached sqlplan.  When i select 'edit query text' the query is truncated at this part:


    and ( ( jp . coordinator_id =

    Yes I've seen that happen - I don't know if it can be changed. Not that I'm aware of but that doesn't mean it hasn't been added at some point.
    You check to see if using sys.dm_exec_sql_text can get the query text. 

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply