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

The application’s GUI disappears and cannot be displayed when using multi-monitor setup

Applies to
ApexSQL Data Diff, ApexSQL Diff, ApexSQL Generate and ApexSQL Script

Symptoms
If the multi-monitor setup is used, while working with mentioned applications, the following issues could be experienced:

How to solve missing schema issues in scripts for databases with SQL Server 2000 compatibility

Applies to
ApexSQL Script

Summary
This article describes how to create correct scripts with ApexSQL Script for objects that contain schemas other than dbo

By product

General

ApexSQL Audit

ApexSQL Backup

ApexSQL Compare

ApexSQL Complete

ApexSQL Data Diff

ApexSQL Decrypt

ApexSQL Diff

ApexSQL Doc

ApexSQL Doc for MySQL

ApexSQL Enforce

ApexSQL Generate

ApexSQL Log

ApexSQL Monitor

ApexSQL Plan

ApexSQL Recover

ApexSQL Refactor

ApexSQL Script

ApexSQL Search

ApexSQL Source Control

ApexSQL Trigger

ApexSQL Unit test

Popular

  • “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
  • “Object reference not set to an instance of an object” message is shown on SQL Server Management Studio startup
  • “Invalid activation code” error is encountered when trying to activate the product using the automatic activation process
  • “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.”
  • SSMS IntelliSense completion mode does not work
  • The “System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation” error
  • 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
  • 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
  • Object reference not set to an instance of an object
  • A “Error 404” error is encountered when linking a database to Team Foundation Server in a different domain from the host
  • Unable to install server-side components on the remote machine
  • ApexSQL Log shows the “Unknown recovery model” message and cannot connect to the database
  • “Unable to open SQL Server connection” when installing application with repository database on a remote server
  • Microsoft .NET framework 4.7.1 was not found
  • This file cannot be generated because it exceeds the maximum file-size
  • A System Out Of Memory exception is thrown when working with large databases in ApexSQL Source Control
  • ApexSQL Log cannot remotely connect to a SQL Server 2008/2008 R2
  • An “Insufficient credentials” error is displayed when attempting to install the server-side components
  • 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

Software

What's supported

Requirements

Testimonials

Sales

Support plans

Renewals and upgrades

Licensing

Help

Support

Resend keys

News

Blog

Company

Contact

About

Gold Partner
  LinkedIn     

© 2022 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy