SSMS 17.4 edit query text truncated

• Jackie Lowery

  SSCommitted

  Points: 1889

  More actions

  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 =


• Sue_H

  SSC Guru

  Points: 90860

  More actions

  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