Category
Product Version
Topic
Subtopic
ApexSQL Offline Activation Failed to login (4375394)
Merge License files, the file should look like the one from below:
ApexSQL Licensing Permissions Requirements (4373139)
When trying to open ApexSQL 2022 version products, an "Internet connection is required to continue" message comes up. ... ApexSQL 2022 version tool does an internet connection verification process by pinging id.quest.com <br>And needs to reach <span style="font-size: 11.0pt;"><span style="font-family: "Calibri",sans-serif;"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flicensing.ism.quest.com%2F&data=05%7C01%7CNodier.Garcia%40quest.com%7Cebe23feb25c24b96aa7708dbb45616ad%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638302054068664027%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=07YCu2O3DF5omdsa8njCOb9hDj%2Flsdo02nXJzjwJvp8%3D&reserved=0"
How to activate ApexSQL software manually (4216052)
To activate an ApexSQL product online, a Hardware ID and a product activation key are needed. ... To manually activate an ApexSQL product online: ... Navigate to ‘ Product activation’ web page ... Select the ApexSQL product to be activated from the ‘Product’ pick list and the appropriate product version from the ‘Version’ pick list
Fatal action guard: guarding against inadvertent execution of code that may damage or destroy data in SQL Server (4282375)
Fatal action guard: guarding against inadvertent execution of code that may damage or destroy data in SQL Server "<p> There are many opportunities, before, during and even after to guard against potentially fatal actions that may damage or destroy data, like executing an Update or Delete statement without a Where clause.
What to do if you’re experiencing disabled Code structure viewer pane (4292236)
Symptoms ... After clicking on the Code structure command in the ApexSQL Complete menu, the Code structure pane appears on the left side of the query tab, but without any code structure displayed and with buttons disabled
SQL Server Management Studio crashing with ApexSQL Complete installed due to Data Execution Prevention (DEP) incompatibility (4213649)
Problem signature: ... table { table-layout: fixed; width: 100%; } .table, .td, .th { border: none; border-collapse:collapse; } Cause ... ApexSQL Complete was incompatible with DEP prior to version 2013.04.0023 which could cause DEP to block the execution of the add-in
This file cannot be generated because it exceeds the maximum file-size (4292973)
Symptoms When exporting data to XLSX Excel file format from the Results grid context menu using ApexSQL Complete feature Export to Excel, you might get the following informative message: ... ApexSQL Complete cannot export data that exceeds Excel specifications and limits.
SQL Server Management Studio is crashing with ApexSQL Complete installed (4213648)
This article explains the reported defect that SQL Server Management Studio crashes sometimes with ApexSQL Complete installed ... Symptoms ... SQL Server Management Studio is crashing when the Auto–complete feature is enabled while hovering mouse pointer over a function or any other object containing tooltip
Memory usage of SQL Server Management Studio and Visual Studio spikes with ApexSQL Complete (4214946)
This article explains about an excessive memory usage problem when the ApexSQL Complete Auto-complete option is enabled with the Syntax error highlighting option ... Symptoms ... Memory usage increases up to 70+% when using ApexSQL Complete
The auto-complete hint-list or SQL Server Management Studio, itself, ‘freezes’ when using auto-complete (4214963)
Symptoms ... This article explains what to do when the ApexSQL Complete hint-list requires too much time to load or occasionally “freezes” SQL Server Management Studio. ... Problem ... If Windows 8 or Windows 10 is the OS and Windows defender is turned on, it may negative impact ApexSQL Complete hint-list performance.
CPU usage spikes while using ApexSQL Complete (4211395)
Symptoms ... CPU usage increases by 50+% as long as the Syntax error highlighting options is enabled in ApexSQL Complete ... Cause ... Since the Syntax error highlighting option is checking objects in a separate thread, additional resources are used.
User defined snippets, auto-replacements, aliases, executed queries, tab navigation are not available after the upgrade (4213668)
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.
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 (4216397)
Summary ... This article explains the reported defect that SQL Server Management Studio crashes randomly after couple of hours of active work with the Auto-complete feature enabled ... Symptoms ... SQL Server Management Studio is crashing with the following error report:
Conflicts between SSMS native Intellisense and the ApexSQL Complete hint-list (4213619)
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:
Export to Excel (4307428)
This article describes the ways of exporting data from the Results grid to an Excel file (.xlsx) ... The Export to Excel feature is used to export results from the Results grid to Excel. ... To export data from the Result grid to an Excel file, select the desired data from the Result grid, right-click and from the context menu choose the Export to Excel command:
How to import executed queries from SSMS Tools Pack to ApexSQL Complete (4212806)
This article explains how to import executed queries from another SSMS Tools Pack into ApexSQL Complete, as it is not compatible with other third party applications/add-ins, and therefore importing executed queries need to be done manually.
How to install ApexSQL add-ins and integrate them into SQL Server Management Studio and Visual Studio (4296678)
In this article we will explain how to install ApexSQL add-ins and integrate them into SQL Server Management Studio and Visual Studio. ... Installation of ApexSQL add-ins can be done in two ways:
How to customize tab colors in SSMS (4214368)
This article describes how to set a custom connection color to a query tab in Microsoft SQL Server Management Studio (SSMS) using a feature called Tab coloring in ApexSQL Complete. ... Description
SQL snippets (4298730)
Applies to ApexSQL Complete Summary This article describes the use of built-in snippets in ApexSQL Complete as well as creating and using new snippets. ... Description Built-in snippet library The built-in snippets can be accessed from the snippets library.
Execution alerts (4211694)
This article describes how to set and use the Execution alerts feature. ... Description ... This feature analyzes SQL code, that is about to be executed, against a defined set of rules with the ability to block query execution and produce a warning message, that provides the option to Proceed or Cancel, in which case the script will either be executed or the execution will be aborted, respectively
How to perform an advanced data search in the results grid (4210750)
Summary ... This article describes how to search through the results grid to find text, wildcards, and regular expressions. ... Although this might sound straightforward, there is no native SSMS functionality to search through the Results grid.
Tab navigation (4211295)
Summary This article describes how to use the Tab navigation feature to organize and save opened tabs, explore closed tabs and re-use them. ... Description To enable the Tab navigation feature, from the Options window check the Enable tab navigation option, under the Tab navigation tab:
Text auto-replacements (4216171)
Summary ... The Auto-replacement feature allows to replace any text previously specified with the appropriate keyword, object name or any kind of SQL code. ... Using the Auto-replacement feature, auto-correct common typing errors, add some often-used SQL statements, and in that way speed up SQL coding.
How to remove add-ins just from Visual Studio while retaining them in SQL Server Management Studio (4296672)
This article describes how to uninstall (manually remove) one or more ApexSQL add-ins from Visual Studio, without affecting the functionality in SQL Server Management Studio. ... In this article, the example covers removing ApexSQL Complete, but the manual remove process works the same way for all ApexSQL add-ins that support integration into Visual Studio.
Executed queries (4209392)
Applies to ApexSQL Complete Summary This article describes how to manage executed queries, search its content and re-use them, using the Executed queries feature. ... Description: To enable the Executed queries feature, check the Log executed queries option: Once the feature is enabled, the information about the executed queries can be accessed through the Executed queries window, which can be initiated from the ApexSQL Complete menu and a click on the Executed queries command from the drop-down list: This will open the Executed queries window: The Executed queries window show the information about the date and time of the execution, status of the query (Successful,
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All