SQL Complete doesn't open connections from different servers when restoring query windows

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Thenrich
Posts: 101
Joined: Sun 21 Dec 2014 19:47

SQL Complete doesn't open connections from different servers when restoring query windows

Post by Thenrich » Wed 27 Nov 2019 18:24

I have different query windows opened to two different servers and databases. When I restart SSMS, it asks for a connection to one server only. When the connection of a restored window is changed to a server that is not opened in the Object Explorer, SQL Complete is not aware of the database objects. Resetting and refreshing the cache doesn't do anything and there's no error message and there are no valid table suggestions.

SSMS 18.4
SQL Complete 6.2.37

alexa
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

Re: SQL Complete doesn't open connections from different servers when restoring query windows

Post by alexa » Thu 28 Nov 2019 11:26

We will fix this issue in the next product update and will notify you once it's available for downloading.

For your information, this happens only with SSMSv.18.

At the moment, it can be fixed by selecting the option 'Enable document restoring' option in the 'General' section of the 'Options' window.

Post Reply