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
Symptoms
The “Number of servers exceeds 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.
“Unable to open SQL Server connection” when installing application with repository database on a remote server
Applies to
ApexSQL Monitor, ApexSQL BI Monitor, ApexSQL VM Monitor
Symptoms
The “Unable to open SQL Server connection” error appears in the Configuration step of the ApexSQL Monitor installation when the remote SQL Server instance is specified in the Server name field of the Central repository database section
Server-side components installation is repeatedly prompted in loop, even when already installed
Applies to
Brief description
Server-side components installation is forced indefinitely even when server-side components are already installed on the machine hosting a SQL Server instance the tool is connecting to
“Internal server error”, missing performance data, page cannot load or corrupted pages issues occur after application update
Applies to
ApexSQL Monitor, ApexSQL BI Monitor, ApexSQL VM Monitor
Symptoms
The “Internal server error” warning message appears in the various application pages, pages without performance data or corrupted pages are displayed, or page cannot be loaded issues might be encountered after the application is updated to a newer version.
ApexSQL Model 2018 R2 isn’t backward compatible with R1
Applies to
ApexSQL Model
Symptoms
When trying to load ApexSQL Model project file with from ApexSQL Model R1 version in ApexSQL Model R2 version you will get empty diagram with no objects loaded.
