Page 1 of 1

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

Posted: Wed 27 Nov 2019 18:24
by Thenrich
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

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

Posted: Thu 28 Nov 2019 11:26
by alexa
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.