4

I recently installed SSMS 18.1 and I am having an issue when trying to drag and drop table names from the object explorer to the query window. For example, I am writing a query and dont want type out the table name I would drag and drop the table into the query editor and the name will be there.

This is the error I get: "An exception has been encountered. This may be caused by an extension".

Any help would be appreciated.

3

Follow this feedback item for updates on the issue:

SSMS Crash when dragging table from Object explorer into new query window

Microsoft SQL Server (Product Manager, Microsoft Azure) responded · Jun 14, 2019

Issue has been identified and a fix is being made. It will be rolled out with the next update of SSMS 18.

In the meantime, you could revert to SSMS 17.9.

2

This is known issue and a very annoying error because the SSMS is freezing and not responding (even for mouse clicks OK on the error message), and we need to kill the SSMS process, in case we want to continue working. That really can ruin all ours today's work, if we not save one in a while, and no available fix for that now!

Microsoft response is: "Issue has been identified and a fix is being made. It will be rolled out with the next update of SSMS 18".

As I explain here, till will be fixed, you can work around:

  1. just press ENTER or ESC button on the keyboard and it un-freeze;
  2. save your work;
  3. Reopen the query window
-2

This is clearly mentioned in the known issues section of the release notes for SSMS 18.1:

Users may see an error when dragging a table object from the Object Explorer into the Query Editor. We are aware of the issue, and the fix is planned for the next release.

Its not a major issue since intellisense will offer auto-completion on your table names anyway but if you find it a major blocker you can always revert back to a previous version. SSMS 17.x can be installed side by side while you wait for SSMS 18.2 to be released.

  • I am curious to know why my answer has been down-voted. If anybody would be kind enough to provide clarity I would very much appreciate it. – Mr.Brownstone Jul 23 at 13:43

protected by Community Jul 19 at 17:12

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.