Solutions Products Downloads Prices Support

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server

Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server

Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server

ApexSQL Compare and Sync Toolkit for SQL Server

Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server

Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server

Spotlight Cloud hosted SQL Server monitoring and diagnostics

LiteSpeed High-speed SQL Server backup, compression and restore

Database administration
Automate critical tasks for database administration

Auditing and compliance
Database backup
Disaster recovery
Forensic auditing

Index defragmentation
Inventory management
Load testing
Object level restore

Server compare
SQL job automation
SQL Server monitoring

Transaction log reading
Transactional replication

Database development
Integrate database changes and automate deployments

Continuous delivery
Continuous integration
Data compare
Data import/export
Data masking
Database DevOps
Database documentation
Database modeling
Dependency analysis
Developer productivity

Development best practices
Documentation
Multi-DB script execution
MySQL data compare
MySQL documentation
MySQL schema compare
Object decryption
Object refactoring
Packaging and deployment

Schema and data scripting
Schema compare
Script comparison
SharePoint documentation
SQL formatting
SQL Server documentation
SQL source control
SQL unit testing

SSAS documentation
SSIS documentation
SSIS package compare
SSRS documentation
Statement auto complete
Static code analysis
Test data generation
Text and object search

Solution center

Troubleshooting

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 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

Cannot uninstall add-in even when SQL Server Management Studio and Visual Studio are closed

Applies to
ApexSQL add-ins

Symptoms
This article explains how to resolve an uninstall problem when SQL Server Management Studio and Visual Studio are closed and the uninstall info message still appears, informing that SQL Server Management Studio or Visual Studio is running on a machine

CHM file shows no content

Applies to
ApexSQL Doc

Summary
This article describes why CHM documentation output cannot be seen and how to fix it

Craniate ERM Diagram “Component Licensing” dialog is shown when graphical dependencies are included

Summary
This article explains what to do when the ”Component Licensing” dialog appears with the message “ERM Diagram 4.1. You have xx days remaining of your evaluation” when using the Visual dependencies feature

The “System.OutOfMemory” error

Applies to
ApexSQL Diff, ApexSQL Log, ApexSQL Doc, ApexSQL Doc for MySQL

Summary
This article explains what to do when the System.OutOfMemory exception is encountered

The “System.FormatException” error is encountered when documenting a specific database

Applies to
ApexSQL Doc

Summary
This article discusses how to solve the “System.FormatException” error that is encountered when documenting a database

Not enough time to create documentation

Applies to
ApexSQL Doc, ApexSQL Doc for MySQL

Summary
This article explains what to do when the “ApexSQL Doc has waited for HTML help compiler work result for 600 seconds. Result was not produced for this time” error is encountered

The “An internal error has occurred. This program will now close” error

Applies to
ApexSQL Doc, ApexSQL Doc for MySQL

Summary
This article explains what to do when the "An internal error has occurred. This program will now close" error is encountered at the final stage of the CHM compilation

Access to the path “C:\Program Files\ApexSQL\ApexSQLDoc\ Intermediary\Temp####'” is denied

Applies to
ApexSQL Doc, ApexSQL Doc for MySQL

SummaryThe “Access to the path ‘C:\Program Files\ApexSQL\ApexSQLDoc\Intermediary\Temp####’ is denied” error is encountered during database documentation in Windows Vista or higher

Page 1 of 212 »

By product

ApexSQL Doc for MySQL

ApexSQL Source Control

ApexSQL Trigger

ApexSQL Unit test

“Object reference not set to an instance of an object” message is shown on SQL Server Management Studio startup
“Cannot insert the value NULL into column ‘ColumnName’, table ‘TableName; column does not allow nulls. INSERT fails.” error
The ‘Runtime Error (at -1:0): Cannot import dll:<utf8>%AppData%\Local\VCLStylesSkin\VclStylesIno.dll.’ error is encountered when uninstalling application
“Could not allocate space for object ‘<object_name>’ in database ‘<database_name>’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.”
The ‘Sqlcmd: Error: Syntax error at line XYZ near command ‘X’ in file ‘file_name.sql’.’ error is encountered when running SQL script via sqlcmd utility
The “System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation” error
“Invalid activation code” error is encountered when trying to activate the product using the automatic activation process
SSMS IntelliSense completion mode does not work
Object reference not set to an instance of an object
Restore job fails during the log shipping process and the ‘System.Data.SqlClient.SqlError: …. An earlier log backup that includes LSN can be restored.’ error is encountered
A “Error 404” error is encountered when linking a database to Team Foundation Server in a different domain from the host
“Runtime error 217 at XXXXXXXX” error is encountered when starting installation process
“Unable to open SQL Server connection” when installing application with repository database on a remote server
ApexSQL Log shows the “Unknown recovery model” message and cannot connect to the database
A System Out Of Memory exception is thrown when working with large databases in ApexSQL Source Control
“RESTORE LOG is terminating abnormally” error is encountered in during the restore database step in the log shipping job
This file cannot be generated because it exceeds the maximum file-size
ApexSQL add-ins do not integrate with SQL Server Management Studio 18 GA version
An “Insufficient credentials” error is displayed when attempting to install the server-side components
ApexSQL Log cannot remotely connect to a SQL Server 2008/2008 R2