HomeDatabaseSQL Server 2005: Configure Max Number of Characters Displayed in Each Column

SQL Server 2005: Configure Max Number of Characters Displayed in Each Column

It is sometimes necessary to modify the number of characters displayed in a query result set, especially when you are dealing with results containing a large number of columns. To configure the maximum number of characters displayed, do the following…


1. Open SQL Server 2005 Management Studio.

2. Click Tools and select Options.

3. In the Options dialog box, double-click on Query Results in the left pane.

4. Select Results to Text in the left pane.

5. Towards the bottom of the right pane, change the box for Maximum number of characters displayed in each column to the desired value.

6. Click OK.

7. Click OK on the resulting confirmation box telling you that the changes will only be applied to new SQL Server Query Editor window.

Now open a new Query Editor window and execute a query to make sure the results are as desired.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android