SSMS - dragging column names to query window doesn't add square brackets - by richbrownesq

Status : 


Sign in
to vote
ID 544232 Comments
Status Active Workarounds
Type Bug Repros 5
Opened 3/24/2010 4:06:09 AM
Access Restriction Public


If i drag a column (or list of columns) which have spaces from SSMS Object explorer to a query window, the column names are not qualified/quoted with square brackets meaning. This gives syntax errors when running queries. This is particularly frustrating when dragging a column set to a window as you have to manually add the square brackets to each column.
Sign in to post a comment.
Posted by Microsoft on 5/17/2011 at 4:28 AM
Hello Rich,

There is a similar bug that we are tracking for this issue - . Given this, I am going to resolve your issue as duplicate of the other issue. In case you have any question or comments then contact me directly at

Nikhil Kumar
Posted by Microsoft on 4/26/2011 at 12:00 PM
Hi Rich,

Thank you for sharing this feedback about the drag from OE feature in SSMS. This is just an update to let you know that we are tracking this as part of other issue 421541 which was filed earlier and is about a similar issue. 429116 will be closed as a duplicate of 421541. We will keep you posted about the status of 421541.

thank you

Posted by Jamie Thomson on 3/24/2010 at 5:38 AM
Totally agree with this. Check this other related submission:

Improvements required for dragging columns from Object Explorer