dbatools Invoke-DbaQuery truncates results at 90 characters

Question

I'm using Invoke-DbaQuery to spool current application settings to a text file ahead of an application refresh but see the output is truncated at 90 characters. Does anyone know how to get past this limitation?

The old Invoke-SqlCmd had a "-MaxCharLength" parameter but that doesn't work with Invoke-DbaQuery. — Ken, Sep 23 '21 at 17:15

score 0 · Answer 1 · answered Sep 23 '21 at 17:34

0

Piping the output to "Out-String -Width 200" fixes this issue.

answered Sep 23 '21 at 17:34

Ken

77
9

dbatools Invoke-DbaQuery truncates results at 90 characters

1 Answers1