long SQL text truncated

Sanjiv

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?

Jon_Kirkwood

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.

Sanjiv

@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