Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can anyone help? I am using SQL management studio (sql server 2008) to run queries and some of the fields that come back are varchar(max) for example and it has a lot of information - Is there a zoom feature to open the window and show me the contents with vertical and horizontal scrollbars?

I remember there was, i thought it was F2 but i must have been mistaken as it doesn't work

Now i have to scroll horizontal on the field and its really difficult to see everything

Also some of the fields contain new line codes etc so it would be great if the zoom feature would display the info using the new line codes etc

Any body know how to do this?

share|improve this question

You can return just the column using the SQL Statement, and put the output into Text Mode (CTRL T) which will show the value with line breaks. You'll also need to tell SSMS that you want to see more than 2000 characters (I think that's the default) by changing that in the Options for SSMS.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.