How can I prevent the Powershell Invoke-sqlcmd truncating output at 80 columns?

Question

In Powershell, Invoke-sqlcmd is truncating my output at 80 columns

I've tried this code and things are still being truncated at the 80th column

$ans=Invoke-Sqlcmd -ServerInstance $sqlServer -Database $MyDbName -Query $SQLSCRIPT -OutputAs DataTables |Format-Table -Property * -AutoSize | Out-String -Width 4096 | Out-File $FullPathReportFileName

How can I keep it from truncating and looking like this?:

js2010 · Accepted Answer · 2019-08-28 20:21:39Z

1

What does the output look like? The way it looks on the screen is kind of an illusion. If you pipe to format-list, or select -expand property, it will probably show the whole thing. You might like this setting:

$formatenumerationlimit = 99

Or increase the size of the window.

edited Aug 28, 2019 at 20:21

answered Aug 26, 2019 at 21:02

js2010

28.3k6 gold badges82 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

cashonly Over a year ago

Just added a pic to the question

js2010 Over a year ago

What version of powershell is it? You can try piping it to ft -autosize, or increasing the width of the window.

cashonly Over a year ago

So, I ran it with a larger powershell window and it worked fine. It's strange that it's based on the width of the PS window.

mklement0 Over a year ago

$FormatEnumerationLimit, which defaults to 4, determines how many elements of a collection-valued property to display inside a column, which is unrelated to @cashonly's problem. It is worth making it clearer in the answer that increasing the size of the window is what helped.

Collectives™ on Stack Overflow

How can I prevent the Powershell Invoke-sqlcmd truncating output at 80 columns?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related