Home Forums SQL Server 2017 SQL Server 2017 - Development SSMS 17.4 edit query text truncated RE: SSMS 17.4 edit query text truncated

  • 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