Configuring Word Wrap and Virtual Space in SQL Server Management Studio

Too many of us spend time manually wrapping lines when editing TSQL. Would you do that in Word? We'll show you how to enable word wrap and how the 'virtual space' option works, a great time saver if you like to put comments at the end of lines and align them. Watching this is a great reminder to spend a few minutes exploring the SSMS options to make it work the way you work.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

289C2664FA on 10/20/2010

Great tips.

Calvin Johnson on 10/22/2010

Thanks

Anu Banerjee on 10/22/2010

very good...just excellent

Yelena on 10/22/2010

Thanks for making this available to watch!

Faisal Lodhi on 10/22/2010

Thank you! Learned SOmthing New.

josh on 10/22/2010

nifty little goodies

Ary Mirochnik on 10/22/2010

Very helpfull video.

Alexander on 10/22/2010

very nice

947C03EA21 on 10/22/2010

Thanks for the tips.

kishore on 10/22/2010

nice video..

50D4B114AA on 10/22/2010

I tried to select line numbers and the numbers never appeared. I attempted to turn off and on several times and even closed the query window and tried to open a new one - all without success. Can you help? ---apcassidy@aol.com

Sean on 10/22/2010

I did not know that SSMS had word wrap, that is going to help a lot with some of the bigger stored procedures.

SQLSharma on 10/22/2010

Good stuff! More index tuning sessions please.

FD928096BE on 10/22/2010

Great stuff

Alok on 10/23/2010

Very helpful, keep up the good work... :)

Theresa Hadden-Martinez on 10/24/2010

Although this is a little thing, I will find it very helpful.

Johanna on 10/24/2010

Good night I found the presentation very good sql server 2008, but I have a problem with sql server 2005 to run the upgrade advisor for database sql server 2000, is showing the following messages and not to do: Object reference not set to an instance of an object. (VIEWCHECKOPT) and Several Issues upgrade not can be detected by Upgrade Advisor. To view undetectable Issues, click "Tell me more about this issue and how to resolve it." I would greatly appreciate your contribution to this major problem I have. Johanna M.

Diana Dee on 10/25/2010

It might be nice if you change the colors back to standard. Thanks.

James Lawrence on 10/26/2010

I will make use of these suggestions!

anand on 10/27/2010

Good Trick.

Margie on 11/5/2010

Wow, I really needed this video today. I am very new to SQL Server and the line number comment was exactly what I was looking for when I run in to errors! Thanks!!

Carrie on 11/8/2010

great tips that I wasn't aware of

Don Nesbitt on 11/24/2010

Good to have an idea as to what is available and where to look for it.

HD on 1/9/2011

I dont know about word wrap feature.. Thanks

Enrique Hernandez on 2/12/2011

Great tips, small things that make your life a little bit easier. Thanks

A Alagu Ganesh on 3/21/2012

Good