Applies to
Symptoms
When typing is started in the query editor, stored procedures and functions do not appear in the hint-list of suggestions.
“Could not connect to server” error message in ApexSQL Complete
Applies to
Symptoms
After the schema cache is refreshed, with a click on the Refresh button under the Schema cache tab, the warning message “Could not connect to server” appears.
ApexSQL Add-ins and Spotlight-Tuning Pack Conflict in SSMS 18
Applies to
ApexSQL add-ins
Symptoms
After installing Spotlight Extensions – Tuning Pack into SQL Server Management Studio 18 (SSMS 18) on a system that already has any ApexSQL add-in installed, the Tuning Pack menu will not be shown in SSMS 18 main menu.
The same problem occurs if Spotlight Tuning Pack was installed before any ApexSQL add-ins.
ApexSQL add-ins tab options do not show in Visual Studio 2019
Applies to
ApexSQL add-ins
Symptoms
With the release of Visual Studio 2019 version 16.2, ApexSQL add-in tabs do not show options in these tabs, aka ApexSQL tabs are empty. This article explains how to find a solution (workaround) when this problem happens.
A System Out Of Memory exception is thrown when working with large databases in ApexSQL Source Control
Applies to
Symptoms:
Working with large databases can lead to the system out of the memory issue in SQL Server Management Studio.
Object reference not set to an instance of an object
Applies to
ApexSQL add-ins
Symptoms
With the release of Visual Studio 2019 v16.1, by default, Visual Studio 2019 blocks any synchronously autoloaded package from any extension and shows a notification to alert the user about it on the startup of application:
Indexes rebuild operations are not properly replicated
Applies to:
Brief description:
Replicating “Rebuild index” DDL operation (creating a redo script) with ApexSQL Log will:
- Create phantom insert statement in transaction log auditing results and apply them to replica
- Report job failure when tables with no primary keys are affected
ApexSQL add-ins do not integrate with SQL Server Management Studio 18 GA version
Applies to
ApexSQL add-ins
Symptoms
SSMS 18 is no longer in preview mode and is the first General Availability (GA) version of SSMS 18 is out aka
ApexSQL add-ins do not show in Visual Studio 2019
Applies to
ApexSQL add-ins
Symptoms
With the release of Visual Studio 2019, Microsoft added tags in the Extensions and Updates dialog to help quickly understand whether an extension is in Preview, is a Paid extension, or is in a Trial period. This article explains how to find the installation of ApexSQL add-ins in the latest version of Visual Studio when ApexSQL item is not available among the main menu in the host application.
Number of servers exceeds number of available server licenses. Remaining licenses: -1
Applies to
ApexSQL Monitor
Symptoms
The “Number of servers exceeds the number of available server licenses. Remaining licenses -1” error warning message appears in the Add instance page when trying to add a new SQL Server instance to monitor.
