Applies to
Problem description
ApexSQL Audit is not manageable through the application interface because of the faulted connection to the central repository database.
Cannot browse for folder in Auditing agent properties dialog – The “Accessing remote folder from the location not possible” error is encountered
Applies to
Problem description
The “Accessing remote folder from the location not possible” error is encountered when trying to select a temporary folder destination when adding SQL Server for auditing or editing one that was already added.
SSMS IntelliSense completion mode does not work
Applies to
Symptoms
After installing ApexSQL Complete and disabling SQL auto-complete in add-in options, the SQL Server Management Studio (SSMS) IntelliSense does not show up.
Stored procedures and functions do not show in the hint-list
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
