LINKS
General
Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script
Troubleshooting Home
Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script
Troubleshooting Home
MOST RECENT
SITE FEED
Support Forum
The fastest and most effective to get answers to your questions quickly. Click Here for more info.
FAQs 
Quick answers to common questions. Click Here for more info.
Troubleshooting
Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.
Knowledgebase
Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.
Online Documentation
All of our help files for download or convenient viewing online. Click Here for more info.
Videos
Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.
|
Troubleshooting Troubleshooting and Known issues with Apex SQL Tools Trial period for ApexSQL Edit doesn't reset when new version is installed SYMPTOMS When I install a new version of ApexSQL Edit, instead of getting a 30-day trial period, I get 0 days. Hence, I'm not able to evaluate the product. I have not installed this version before. RESOLUTION Please contact sales for an evaluation extension. LAST REVIEW 10 April 2008 Labels: ApexSQL Edit ...User settings disappeared after updating ApexSQL Edit to the latest version SYMPTOMS When I updated ApexSQL Edit to the latest version, all my "User Queries", templates, and snippets disappeared. CAUSE After updating ApexSQL Edit to the latest version, several folders/files in application folders are replaced with the versions found in the an installation package. Information found in user queries, snippets, templates, and application layout may be overwritten. RESOLUTION Before installing/upgrading existing version of the ApexSQL Edit application, backup the following folders and files: - Folders: o Snippets o Templates - Files o Replacements.xml o SQLFormat.xml o UserSQLFormat.xml o Favorites.xml o Queries.xml o Settings.xml All of the above can be found in the application folder (e.g. C:\Program Files\ApexSQL\ApexSQLEdit). After upgrading/re-installation, please restore the backed up files by copying them to ApexSQL Edit's application folder. LAST REVIEW 9 April 2008 Labels: ApexSQL Edit ...Application crashes at startup in Windows Vista SYMPTOMS Application crashes at startup in Windows Vista CAUSE Windows Vista's advanced security does not allow applications to modify application’s folders. RESOLUTION Option 1: Run application as Administrator.  Option 2: Give write/modify permissions to users to the application’s folder  AUTHOR Denis Mack LAST REVIEW 27 February 2008 Labels: General ...Message “Jobs object reload error” Message “Jobs object reload error” is shown in the Manage Audit Data dialog. CAUSE The "Jobs object reload error" message is shown when the user account doen't have permissions to run msdb.sp_help_job and msdb.sp_help_jobhistory. This means that the EXECUTE permission was denied on the objects 'sp_help_job' and 'sp_help_jobhistory', database 'msdb', and schema 'dbo'. RESOLUTION Add 'execute' permission for the user to, at the very least, msdb.sp_help_job and msdb.sp_help_jobhistory. You can run the following script from the administrator account to do this (change AUDITOR to the name of audit user). LAST REVIEW 17 January 2008 Labels: ApexSQL Audit ...ApexSQL tools generate an error after installation of Service Pack 1 (Beta version) for Windows Vista 32-bit After installing a beta version of Service Pack 1 for Windows Vista 32 bit, all ApexSQL Tools stopped working and generated the following error: Problem signature: CAUSE This is a known error that occurs after installation of Windows Vista-32 bit Service Pack (Beta). This occurs for some non-ApexSQL Products as well. Click here for more information. RESOLUTION We recommend removing/uninstalling this beta version of the Service Pack 1 for Windows Vista 32-bit. LAST REVIEW 22 October 2007 Labels: General ...Menu items and toolbars are not displayed in ApexSQL Edit SUMMARY When I open ApexSQL Edit, the toolbars and the explorers' windows are hidden and only the Query Editor is visible.  CAUSE The layout file in the application directory is corrupted. RESOLUTION Close ApexSQL Edit. Go to ApexSQL Edit's application directory and delete the ApexSQLEdit.layout file. The next time you open ApexSQL Edit, the toolbars and menu items will be displayed. LAST REVIEW 16 October 2007 Labels: ApexSQL Edit ...How do I add a brace to a code template? If you are using C# as output language, then you should add a space between "<" and ">". For example, to output the following: public class ReadOnlyBase<RequestInfo> It must be written as: public class ReadOnlyBase<%= "<" + ClassName %>Info> LAST REVIEW DATE 12 October 2007 Labels: ApexSQL Code ... |
© 2007 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use