Search code examples
sqlsql-servert-sql

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!

Solution

  • 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.