Applies to
ApexSQL Complete
Symptoms
Sometimes conflicts occur between the ApexSQL Complete hint-list and SSMS’s native Intellisense. In such cases, SSMS’s native Intellisense may overlap the ApexSQL Complete hint-list as shown below:
The ALM files are bulking up and using too much space
Applies to
ApexSQL Log
Summary
This article explains what to do when ApexSQL Log temporary files (.ALM type files) take too much space or when the number of .ALM files is too great
“Check-in failed Source control error: Cannot checkin pending changes” error
Applies to
ApexSQL Data Diff
Symptoms
“Check-in failed Source control error: Cannot checkin pending changes” error can be encountered during the synchronization to the Team Foundation Server repository, when the synchronization script exceeds 300 MB in size This error can be also encountered if the connection speed between local machine and Team Foundation Server hosting service is slow.
“Connection was failed with message: ‘The executable did not complete within the allotted time’” message
Applies to
ApexSQL Data Diff
Symptoms
“Connection was failed with message: ‘The executable did not complete within the allotted time’” message can be encountered during the recomparison after synchronizing to the Mercurial source control repository, when the synchronization script exceeds 300 MB in size. This message can be also encountered if the connection speed between local machine and Mercurial hosting service is slow.
“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.”
Applies to
ApexSQL Audit, ApexSQL Monitor
Symptoms
The error message is telling you that the ‘PRIMARY’ filegroup is full. This article explains how to resolve this error is encountered when working with application. The error will prevent storing any audited or monitored data into a central repository database
User defined snippets, auto-replacements, aliases, executed queries, tab navigation are not available after the upgrade
Applies to
ApexSQL Complete
Symptoms
After the add-in is updated to the 2016.01.0072 version, auto-replacements, custom created snippets, aliases, executed queries, tab navigation are not imported properly from previous version.
How to manually install and uninstall ApexSQL Log 2014 server side-components
Applies to
ApexSQL Log 2014
Summary
This article explains how to manually install and uninstall the server side components when it is not possible to utilize ApexSQL Log installer or when server side components need to be (un)installed on the passive cluster node.
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
Applies to
ApexSQL Recover, ApexSQL Log
Summary
This article explains how to manually edit script created by ApexSQL Recover or ApexSQL Log which contains ‘$’ sign in order for it to be executable by sqlcmd
“Cannot insert the value NULL into column ‘ColumnName’, table ‘TableName; column does not allow nulls. INSERT fails.” error
Applies to
ApexSQL Data Diff
Symptoms
The “Cannot insert the value NULL into column ‘ColumnName’, table ‘TableName; column does not allow nulls. INSERT fails.” error is encountered when running ApexSQL Data Diff synchronization script.
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
