Set the max output length for Results to Text in MS SQL Studio 2019

Ran into an issue with a deployment generator script where the output was giving issues when outputting ‘Results to Text’

Steps to rectify:

• Tools->Options
• Query Results -> SQL Server -> Results to Text
• Maximum number of characters displayed in each column: 2097152

---

📇 Additional Metadata

• 🗂 Type:: note
• 🏷️ Tags:: Sql Server, Sql Server Management Studio
• 📡 Status:: #status/🌲