• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2149
  • Last Modified:

ssms Drag and Drop

Problem
I can't drag and drop a table into a view on Management Studio and my brother who is using an older version (not R2) can drag and drop.

I can
In an empty query window, I can drag a table name, a column name etc. but in a view I can't drag nothing.

Did they take this away in R2??

Facts
SQL Server --> 2008 R2
SSMS Version --> 10.50.25
Windows 7 Pro
0
LJG
Asked:
LJG
  • 3
  • 3
1 Solution
 
Vijaya Reddy Pinnapa ReddyCommented:
I have tried it.It seems that feature is not available in 2008 R2
0
 
DcpKingCommented:
I don't see this, but I may be using SSMS differently.

I right-click the view name, select Script View As,    Create To,     New Query Editor Window
and get the code for the view up in a window that I can edit as normal.

OTOH, if you just straight go into Design mode on a View you can't drag table names or column names into the code are in 2008R2 or 2012. You have to play in the picture window at the top, that wastes (to my mind) about half the real-estate of the screen!

hth

Mike
0
 
LJGAuthor Commented:
See Graphic Attached - It will make more sense.

Problem
I can't drag and drop a table into a view on Management Studio and my brother who is using an older version (not R2) can drag and drop.

I can
In an empty query window, I can drag a table name, a column name etc. but in a view I can't drag nothing.

Did they take this away in R2??
SSMS-Window.jpg
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
DcpKingCommented:
Well, I just tried it with a copy of 2008R2, dragging a table from the tables list in the Object Explorer, and it popped up fine in the part of the View display that you indicate with your drawing (I'd never thought of doing that before -  I just right-clicked and selected Add Table when I used it).  

I can also have some fields in a table diagram unchecked, and, if I drag that field from the column list in the object explorer into the table diagram the field will become checked.

My SSMS is 10.50.3720.0 for 2008R2, and it's running under WinXP/64, but I can't find any drag and drop setting that might enable it specifically. Sorry
0
 
LJGAuthor Commented:
I don't have the answer yet, but I'm giving DcpKing the points because he showed me there is a newer version.  I've asked another question about what file(s) to use for updating.

http://www.experts-exchange.com/Programming/Editors_IDEs/Q_27845062.html

If I get it to work, I'll come back and tell you.

Thanks everyone
LJG
0
 
DcpKingCommented:
My copy is the RTM of the Developer's Edition - about $50 from Amazon! What are you running yours under - Win 7 or Vista?
0
 
LJGAuthor Commented:
Just and added comments

If you want to update your version of SQL Server 2008 R2 see acperkins answer on the below question.
http://www.experts-exchange.com/Programming/Editors_IDEs/Q_27845062.html

After updating I still can't do drag and Drop on a VIEW, but as before the update, I can do drag and drop on a query.


Versions I am running
SQL Server --> 2008 R2 Express
SSMS Version --> 10.50.40
Windows 7 Pro


Thanks everyone for the help
LJG
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now