SQL Server Performance

'Maximum characters per column' option in QA

Discussion in 'General DBA Questions' started by skweeky, Sep 1, 2004.

  1. skweeky New Member

    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 />
  2. ChrisFretwell New Member

    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.
  3. satya Moderator

  4. skweeky New Member

    thanks for flag tip in osql !

    nicolas

Share This Page