‘Maximum characters per column’ option in QA | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

‘Maximum characters per column’ option in QA

hello !<br />in Query Analyser, there is an option ‘Maximum characters per column’ (go to Tools/Options/Results tab)<br /><br />is there a way to set this option directly in sql !?<br />I didnt find any SET options corresponding to this option <img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />(<br /><br />so, do we must to use QA interface to set this option or is there any other way to set it !?<br /><br />thanks for help !!!<br /><br />nicolas<br />
I know how to do it from the osql line. Its the -w flag. So if you are executing a stored procedure, you can do it that way. Let me see if I can find a way from within sql code while in the QA window.
Not as far as I know using a SQL Statment for QA. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
thanks for flag tip in osql ! nicolas

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |