CODEWITHSUNDEEP
sqlsql-servert-sql
user565993
user565993

Reputation:

SQL Management Studio can't drag table / object from Explorer to Query Editor

Ok guys, SQL Management Studio can't drag table / object from Explorer to Query Editor

I tried , and I don't know where to enable this future again :( Tried options menu... Aaaaa... Some one please save my day!

Upvotes: 4

Views: 9276

Answers (7)

user24842657
user24842657

Reputation: 1

you can also just copy-paste the tables on to the file instead of dragging.

Upvotes: 0

KumarHarsh
KumarHarsh

Reputation: 5094

If you open SSMS in 'Run as Administrator' mode then Drag Drop file won't work.

Close SSMS and open SSMS normally. Drag-drop file feature will work.

Upvotes: 4

Gilberto
Gilberto

Reputation: 69

Interestingly enough, I went to download ShellExview as a previous post displayed. http://www.nirsoft.net/utils/shexview.html#DownloadLinks I found that different versions of the Office libraries were loaded in memory, for me it happened as I am loading Visio 2010 and 2016 at different times. A reboot fixed the issue.

(Exported the list before reboot when the issue was present and after reboot) Exported View of the ShellExportApplication

Upvotes: 1

NightShovel
NightShovel

Reputation: 3252

I was copying a large file in the background which seems to mess this up. When the file was finished copying, drag and drop worked again.

Upvotes: 0

Rm558
Rm558

Reputation: 5002

Fixed by hitting the ESC key a couple of times in my case.

Upvotes: 11

Craig
Craig

Reputation: 21

In SSMS 2012 (maybe other versions too), go to "Tools|Options|Text Editor|General" and click "Drag & Drop text editing". That should do the trick.

Upvotes: 2

RThomas
RThomas

Reputation: 10880

First... does drag drop still work on other programs that aren't SSMS? I doubt that this is a feature you can turn on/off within SSMS. It probably is something deeper in the OS.

If so - is the shift key or ctrl key on your keyboard stuck down? I would also check options in the start menu. Disabling drag/drop and right/click can be done at the system level or by group policy - but again it would affect more than just SSMS.

I've also heard of various viruses disabling drag/drop but again, it seems strange it would only affect SSMS.

Upvotes: 2

Related Questions