Solutions Products Downloads Prices Support

ApexSQL DBA
Automate critical tasks for database administration

ApexSQL Audit
ApexSQL Backup
ApexSQL Defrag

ApexSQL Discover
ApexSQL Job
ApexSQL Log

ApexSQL Manage
ApexSQL Plan

ApexSQL Propagate
ApexSQL Recover

ApexSQL Developer Integrate database changes and automate deployments

ApexSQL Analyze
ApexSQL Build
ApexSQL Compare
ApexSQL Complete
ApexSQL Data Diff

ApexSQL Decrypt
ApexSQL DevOps toolkit
ApexSQL Diff
ApexSQL Doc
ApexSQL Enforce

ApexSQL Generate
ApexSQL Mask
ApexSQL Model
ApexSQL Pump
ApexSQL Refactor

ApexSQL Script
ApexSQL Search
ApexSQL Source Control
ApexSQL Trigger
ApexSQL Unit Test

What's new What's next

Database administration
Automate critical tasks for database administration

Auditing and compliance
Database backup
Disaster recovery
Forensic auditing

Index defragmentation
Inventory management
Load testing
Multi-DB script execution

Object level restore
Query optimization
Server compare

SQL job automation
Transaction log reading
Transactional replication

Database development
Integrate database changes and automate deployments

Continuous delivery
Continuous integration
Custom application auditing
Data compare
Data import/export
Data masking
Database DevOps
Database documentation

Database modeling
Dependency analysis
Developer productivity
Development best practices
Documentation
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 documenation
SSIS documenation
SSIS package compare
SSRS documenation
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

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

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

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

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

ApexSQL Trigger

ApexSQL Unit test

“Cannot insert the value NULL into column ‘ColumnName’, table ‘TableName; column does not allow nulls. INSERT fails.” error
How can I increase the timeout for connecting to my SQL Server?
SQL Server Management Studio is crashing with ApexSQL Complete installed
The ‘Runtime Error (at -1:0): Cannot import dll:<utf8>%AppData%\Local\VCLStylesSkin\VclStylesIno.dll.’ error is encountered when uninstalling application
What to do if you’re experiencing performance issues with Visual Studio / SQL Server Management Studio while using ApexSQL add-ins
Conflicts between SSMS native Intellisense and the ApexSQL Complete hint-list
SQL Server Management Studio crashing with ApexSQL Complete installed due to Data Execution Prevention (DEP) incompatibility
The “Value ‘0’ is not a valid value for Interval. Interval must be greater than 0” error is encountered in SQL Server Management Studio with ApexSQL Complete installed
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
Memory usage of SQL Server Management Studio and Visual Studio spikes with ApexSQL Complete
System.IO. FileNotFoundException: Could not load file or assembly ‘Microsoft. VisualStudio. CommandBars’
An “Insufficient credentials” error is displayed when attempting to install the server-side components
Functionality in ApexSQL Complete is disabled
Connection to SQL server fails
The “System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation” error
ApexSQL Log shows the “Unknown recovery model” message and cannot connect to the database
Internal error: Expression error ‘Runtime Error (at 202:207): External exception E0434352
INSERT permission denied on object ‘AUDIT_LOG_TRANSACTIONS’ error is shown
The “This program cannot display the webpage” error is encountered when generated CHM documents are copied to a network drive
The auto-complete hint-list or SQL Server Management Studio, itself, ‘freezes’ when using auto-complete