How do you use cloud databases? Take the survey.

long SQL text truncated

SanjivSanjiv Posts: 7 New member
Is there a limit to the SQL length size displayed in SQL Monitor? I'm noticing it's truncating text over 4k and I want access to the full SQL in cases where such log SQL commands are issued. Is there a setting to bump this up?


  • Hi @Sanjiv

    Thank you for reaching out on the Redgate forums regarding your SQL Monitor query.

    There would certainly be some truncation of long strings in SQL Monitor to allow various areas to render in an expected way. This can potentially differ in different areas - reports, alerts, config settings etc.

    Are you able to advise the area within SQL Monitor where this truncation is occurring for you so I can investigate if there are ways to change the length; or access the SQL commands in a different way for your needs.

    Jon Kirkwood | Technical Support Engineer | Redgate Software
  • SanjivSanjiv Posts: 7 New member
    @Jon_Kirkwood  The View Actual and View Estimated Plan windows display truncated SQL and as a result selecting the Copy button only copies partial SQL text

Sign In or Register to comment.