'Comment out' icon for SQL scripts in SMSS vs VS
  Home FAQ Contact Sign in
microsoft.public.sqlserver.tools only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... sqlserver.tools Profile…
 Up
'Comment out' icon for SQL scripts in SMSS vs VS         


Author: Ed White
Date: Jun 9, 2008 15:39

In both SMSS and Visual Studio, there are icons to comment out lines (looks
like a stack of parallel lines, with the top and bottom lines longer on the
left), and to uncomment lines. When I use these icons in SMSS while writing
SQL scripts, they work as expected (i.e. they add two hyphens in front of the
highlighted lines). However, in Visual Studio, when I create a SQL Server
Project, and Add a Test Script, the same icons are grayed out (i.e.
unavailable), which I find very annoying. I've tried different Toolbars in
VS, but I can't find icons that will comment out and uncomment SQL script the
same way as SMSS does. Are such icons available in VS?
--
Ed
2 Comments
RE: 'Comment out' icon for SQL scripts in SMSS vs VS         


Author: Charles Wang [MSFT]
Date: Jun 9, 2008 22:34

Hi Ed,
I reproduced your issue at my side. This is most likely by design, however
I have not found any document clearly talk about it. I am trying to confirm
this with our product team and may need more time to get back to you. I
appreciate your patience. Currently I recommend that you manually comment
out/uncomment SQL script or edit the script in SSMS.

If you have any other questions or concerns, please feel free to let me
know.
Show full article (2.04Kb)
no comments
RE: 'Comment out' icon for SQL scripts in SMSS vs VS         


Author: Charles Wang [MSFT]
Date: Jun 16, 2008 02:17

Hi Ed,
This is a quick note to let you know that I have not been able to get the
product team's confirmation on this issue by now. I will try to follow up
them and will post back as soon as possible.

In addition, since this issue seems to be a by design issue, I also
recommend that you give Microsoft feedback via
https://connect.microsoft.com/visualstudio so that your voice can be heard
by our product team directly. You will be able to get their email
notification directly when they respond to you.

If you have any other questions or concerns, please feel free to let me
know.
Show full article (1.21Kb)
no comments