Knowledgebase

Where is the ApexSQL Version log file located?

2012-04-20T14:24:00.003-04:00

Applies to ApexSQL Version Summary This article explains where to find ApexSQL Version application log file Description ApexSQL Version application log file is located in C:\Users\\AppData\Local\ApexSQL\ApexSQLVersion (for Windows Vista, Windows 7 and Windows Server 2008) or C:\Documents and Settings\\Local Settings\Application Data\ApexSQL\ApexSQLVersion (for Windows XP and Windows Server

What’s the difference between Check-in and Save to a database options?

2012-04-13T15:20:00.002-04:00

Applies toApexSQL Version Summary What’s the difference between the Check-in and Save to database options in the ApexSQL Version toolbar? When should one use these options?DescriptionSave to database updates the live object only. The script under source control won’t be updated unless Yes is clicked when prompted to check it in Check-in updates only the object’s versioned script. The live

How can I see the differences between the database object and its version under the source control?

2012-04-13T15:08:00.005-04:00

Applies to ApexSQL Version Summary How to see whether the object in the database is identical to its version under source control and if that’s not the case, how to identify the differences Solution 1. Right click the object in Object Explorer and select ApexSQL Version | Reports 2. Select Database vs. source control differences to find out whether the live object differs from its

How to can I see which variables had values changed and where did that change occur while profiling SQL code?

2012-03-26T09:43:00.016-04:00

Applies toApexSQL Profile Summary How to see which variables had a value change and pinpoint the exact line where that change occurred Description 1) Right-click a procedure or a function in the Microsoft SQL Server Management Studio Object Explorer and select ApexSQL Profile | Profile stored procedure 2) Specify the values for all parameters (if any) manually, or use the default ones

How can I save performance profiling results?

2012-03-26T09:42:00.015-04:00

Applies to ApexSQL Profile Summary How to export the profiling results to a Microsoft Excel document or a PDF fileDescriptionDescription 1) Right-click a procedure or a function in the Microsoft SQL Server Management Studio Object Explorer and select ApexSOL Profile | Lazy Profile stored procedure 2) Specify the values for all parameters (if any) manually, or use the default ones 3) Click OK

What is the difference between profiling and 'Lazy profiling'?

2012-03-26T09:41:00.013-04:00

Applies to ApexSQL Profile Summary Explains the difference between profiling and 'Lazy profiling'Description 'Lazy Profiling' profiles SQL code and logs everything that happens during that process. Once finished, Lazy Profiling generates a report which aggregates the profiling results. The report can be exported to a Microsoft Excel document or a PDF file containing: a) The time needed for

What ApexSQL Diff API files to distribute along with the application?

2012-03-16T12:22:00.007-04:00

Applies to ApexSQL Diff API Summary This article explains what ApexSQL Diff API files should be distributed with the application to ensure ApexSQL Diff API functionality. Description The files that need to be distributed are: ActivationBroker.exe ApexSql.Backup.dll ApexSql.Common.Activation.dll ApexSql.Common.BackupMetadata.dll ApexSql.Common.CommonLib.dll ApexSql.Common.Decry.dll

Download links to individual installers

2011-11-11T07:12:00.011-05:00

To get individual product installer please send an email to support@apexsql.com with Product name and version requiredAbout ApexSQLApexSQL is a leading provider of SQL Server tools for database recovery, database auditing, database comparison, documentation as well as SQL Server Management Studio and Visual Studio add-ins for SQL code refactoring, code completion and database source control.

Basic steps for successful data recovery

2011-10-24T12:09:00.027-04:00

Applies toApexSQL RecoverDescriptionWhat to do immediately after data is lost in order to minimize the chance of the data being overwritten or lost beyond chance of recovery and maximize the chance for successful data recoverySolution1. Set the database to Read-Only state immediately2. Copy the database *.mdf and *.ldf files3. Restore the database with a new name using the mdf and ldf files4.

Full-text indexes are created outside the COMMIT statement in the script

2011-10-24T10:37:00.010-04:00

Applies to ApexSQL Script Summary Full-text indexes are created outside the COMMIT statement in the generated script Description This is a known limitation of SQL Server. Full-text indexes can't be created inside a transaction, so they are created before or after the COMMIT statement in the generated script. The script will be executed without errors. About ApexSQL Script ApexSQL Script

How to use the application settings created in ApexSQL Edit 2008 with ApexSQL Edit ?

2011-03-24T12:47:00.015-04:00

Applies to ApexSQL Edit Summary This article explains how to move the custom application settings created in ApexSQL Edit 2008 and use them in latest ApexSQL Edit Description Before you start ApexSQL Edit for the first time, copy the Options.xml file from the ApexSQL Edit 2008 installation folder to ApexSQL Edit %LocalAppData% folder. (e.g. from C:\Program Files\ApexSQL\ApexSQLEdit2008\ to C:

How do I register and view HxS documentation

2011-03-02T18:41:00.010-05:00

Applies to ApexSQL Doc Summary This article explains how to register and view HxS documentation Description To register HxS documentation: 1) Go to the Doc installation folder \ Examples 2) Open the reg.bat file in Notepad 3) Match the parameters in the following lines to your environment: "C:\Program Files\Microsoft Help 2.0 SDK\hxreg.exe" -n testDoc1 -c testDoc.HxS "C:\Program Files\

How do I install the MS HTML Help 2 SDK

2011-03-02T18:36:00.008-05:00

Applies to ApexSQL Doc Summary The article explains how to install the MS HTML Help 2 SDK Description Help 2 SDK called VSHIK (Visual Studio Help Integration Kit) is required for creating and viewing MS HTML Help 2 documentation on your machine. When you have VS .NET installed: - Download VSHIK 2002 (Version 2.1) for Visual Studio 2002 (version 7.0). - Download VSHIK 2003 (Version 2.2) for

Installing server-side components on the passive cluster node (IA64 system architecture)

2011-02-21T14:01:00.025-05:00

Applies to ApexSQL Log Summary How to install ApexSQL Log server-side components on a passive node in a clustered environment for IA64 system architecture Description If ApexSQL Log is installed in a clustered environment, the server-side components can be installed only on the active nodes, not on the passive ones. However, you can work around this issue Workaround Please do the following: 1

Installing Server-Side Components on the passive cluster node (x64 system architecture)

2011-02-21T13:59:00.015-05:00

Applies to ApexSQL Log Summary This article explains how to install ApexSQL Log Server-Side Components on a passive node in a clustered environment for x64 system architecture Description If ApexSQL Log is installed in a clustered environment, the Server Side Components can be installed only on the active nodes, not on the passive ones. However, you can work around this issue. Workaround

Installing Server-Side Components on the passive cluster node (x86 system architecture)

2011-02-18T12:56:00.018-05:00

Applies to ApexSQL Log Summary This article explains how to install ApexSQL Log Server-Side Components on a passive node in a clustered environment for x86 system architecture Description If ApexSQL Log is installed in a clustered environment, the Server-Side Components can be installed only on the active nodes, not on the passive ones. However, you can work around this issue Workaround Please

How to audit operations for dropped or re-created tables

2011-01-13T19:11:00.018-05:00

Applies to ApexSQL Log Summary This article describes how to retrieve schemas and objects for the records that are shown as UNKNOWN in the Main grid. This happens when the table with the specific ID doesn't exist in the database anymore, and the transactions for that object ID exist in the transaction logs used. This happens when: the table was dropped the table was re-created (new ID was

What kind of additional information I can send about a technical problem to help resolve it?

2010-12-28T21:50:00.012-05:00

Description If a bug is found, additional information to duplicate it may be helpful to resolve the problem Solution Helpful information: • What is the Product name (i.e. ApexSQL Diff) and version? • What is the operating system? • What are your processor and RAM? To get this information on Windows 7: 1. Click the Start button 2. Click Control Panel 3. Click System and

What files should be backed up before copying ApexSQL Edit settings to another location or updating to a new version

2010-12-22T20:40:00.021-05:00

Applies to ApexSQL Edit Summary This article lists the files that should be backed up if you want to copy ApexSQL Edit settings to another computer or update ApexSQL Edit to a new version Description Note: The following variable names are used: - %InstallFolder% C:\Program Files\ApexSQL\ApexSQL Edit - %MyDocuments% C:\Documents and Settings\%UserName%\My Documents\ for Windows XP C:\Users\%

How to choose between ApexSQL Audit and ApexSQL Log

2010-12-01T13:02:00.015-05:00

Applies to ApexSQL Log, ApexSQL Audit Summary ApexSQL has two auditing tools - ApexSQL Log and ApexSQL Audit. There is certainly a tradeoff when using one over the other. This article is an overview on how to choose between the two Description ApexSQL Audit is the trigger-based auditing tool. It helps users create audit triggers that are fired by DML operations (INSERT, UPDATE and DELETE) and

How to automate daily reporting with ApexSQL Log

2010-11-19T15:45:00.037-05:00

Applies to ApexSQL Log Summary This article explains how to create and maintain a daily audit trail for your databases using ApexSQL Log Description We will address two scenarios in this article: 1. Everyday documenting of all transactions that occurred (incremental approach) 2. Everyday documenting only transactions that occurred on the given day (differential approach) Incremental approach

How to install the server side components on remote Windows 7 / Windows Vista machine

2010-11-09T14:38:00.023-05:00

Applies to ApexSQL Log Summary This article explains how to install ApexSQL Log Server-side components to a remote SQL Server running on Windows 7 or Windows Vista Symptoms ApexSQL Log client application is running on Windows XP and you want to install ApexSQL Log Server-side components to a Windows 7 or Windows Vista remote machine. The remote machine has SQL Server 2008 installed, mixed

What’s the difference in the results for enabled and disabled Connection Monitor?

2010-11-03T12:44:00.048-04:00

Applies to ApexSQL Log Summary This article shows the difference in the results shown when Connection monitor is disabled and enabled Description SQL Server doesn’t store all relevant connection specific information (such as the name of the host or of the application used to initiate a transaction) in the transaction log. For instance, SQL Server 2000 may store only the SQL Server username,

ApexSQL Refactor uninstallation instructions

2010-11-03T12:05:00.024-04:00

Applies toApexSQL RefactorSummaryHow to uninstall ApexSQL RefactorDescription1. Download ApexSQL Refactor individual installation file2. Install ApexSQL Refactor using this file3. Go to Control Panel|Programs and Features, find ApexSQL Refactor in the list and uninstall itAbout ApexSQL RefactorApexSQL Refactor is a SQL formatter and database refactoring tool for SQL Server. Format SQL queries,

How to uninstall ApexSQL Log server-side components

2010-10-11T13:55:00.039-04:00

Applies toApexSQL LogSummaryThis article discusses how to uninstall ApexSQL Log Server-side componentsSolutionJust uninstalling ApexSQL Log client will not remove any of the Server-side components. There are two ways for removing the Server-side components, depending on whether you have the client application installed or notIf you haven't removed the ApexSQL Log client application, run this