tag:blogger.com,1999:blog-160707082233884630Sun, 27 May 2012 10:25:03 +0000ApexSQL Log APIApexSQL CleanApexSQL Diff APIApex SQL ScriptGeneralApex SQL AuditApexSQL ProfileApexSQL VersionApex SQL RefactorApexSQL LogApexSQL DocApex SQL DiffApex SQL Data DiffApexSQL RecoverApex SQL EditTips, reviews, videos, and articles on how to get the most out of ApexSQL Tools and Microsoft SQL Serverhttp://knowledgebase.apexsql.com/noreply@blogger.com (Brian Lockwood)Blogger56125tag:blogger.com,1999:blog-160707082233884630.post-562490139072668877Fri, 20 Apr 2012 18:24:00 +00002012-04-25T13:23:37.488-04:00ApexSQL VersionApplies 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 Serverhttp://knowledgebase.apexsql.com/2012/04/applies-to-apexsql-version-summary-this.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-4359331860709508572Fri, 13 Apr 2012 19:20:00 +00002012-05-04T18:39:26.974-04:00ApexSQL VersionApplies toApexSQL Version</ br> 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 livehttp://knowledgebase.apexsql.com/2012/04/whats-difference-between-check-in-and.htmlnoreply@blogger.com (Milena Petrovic)0tag:blogger.com,1999:blog-160707082233884630.post-8019461580360008220Fri, 13 Apr 2012 19:08:00 +00002012-04-25T13:24:18.727-04:00ApexSQL Version Applies to ApexSQL Version</ br> 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 http://knowledgebase.apexsql.com/2012/04/how-can-i-see-differences-between.htmlnoreply@blogger.com (Milena Petrovic)0tag:blogger.com,1999:blog-160707082233884630.post-1983611314404168111Mon, 26 Mar 2012 13:43:00 +00002012-04-06T14:54:43.050-04:00ApexSQL ProfileApplies toApexSQL Profile </ br> 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 oneshttp://knowledgebase.apexsql.com/2012/03/how-to-can-i-see-which-variables-had.htmlnoreply@blogger.com (Milena Cakovic)0tag:blogger.com,1999:blog-160707082233884630.post-6531927981614383807Mon, 26 Mar 2012 13:42:00 +00002012-04-06T14:55:01.605-04:00ApexSQL Profile 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 http://knowledgebase.apexsql.com/2012/03/how-can-i-save-performance-profiling.htmlnoreply@blogger.com (Milena Cakovic)0tag:blogger.com,1999:blog-160707082233884630.post-2497499418413236513Mon, 26 Mar 2012 13:41:00 +00002012-04-06T14:56:11.555-04:00ApexSQL Profile 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 http://knowledgebase.apexsql.com/2012/03/what-is-difference-between-profiling.htmlnoreply@blogger.com (Milena Cakovic)0tag:blogger.com,1999:blog-160707082233884630.post-6939701378090135935Fri, 16 Mar 2012 16:22:00 +00002012-03-19T17:59:26.626-04:00ApexSQL Diff APIApplies 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 http://knowledgebase.apexsql.com/2012/03/applies-to-apexsql-data-diff-summary.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-6501834409298016813Fri, 11 Nov 2011 12:12:00 +00002012-04-03T11:55:38.868-04:00General 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. http://knowledgebase.apexsql.com/2011/11/download-links-to-individual-installers.htmlnoreply@blogger.com (Milena Petrovic)0tag:blogger.com,1999:blog-160707082233884630.post-7806238081417934845Mon, 24 Oct 2011 16:09:00 +00002012-04-03T08:19:45.924-04:00ApexSQL RecoverApplies 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. http://knowledgebase.apexsql.com/2011/10/most-important-steps-for-data-recovery.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-8234674428245255182Mon, 24 Oct 2011 14:37:00 +00002012-03-20T13:48:21.979-04:00Apex SQL ScriptApplies 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 http://knowledgebase.apexsql.com/2011/10/full-text-indexes-are-created-after.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-6852525928028415069Thu, 24 Mar 2011 16:47:00 +00002012-03-19T18:05:20.852-04:00Apex SQL EditApplies 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:http://knowledgebase.apexsql.com/2011/03/how-to-migrate-application-settings.htmlnoreply@blogger.com (Sasha Pesic)0tag:blogger.com,1999:blog-160707082233884630.post-8640407185457559435Wed, 02 Mar 2011 23:41:00 +00002012-03-19T18:02:01.768-04:00ApexSQL DocApplies 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\http://knowledgebase.apexsql.com/2011/03/how-do-i-register-and-view-hxs.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-1107002899463778719Wed, 02 Mar 2011 23:36:00 +00002012-03-19T18:02:35.691-04:00ApexSQL DocApplies 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 http://knowledgebase.apexsql.com/2011/03/how-do-i-install-ms-html-help-2-sdk.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-4152769650450670770Mon, 21 Feb 2011 19:01:00 +00002012-04-25T10:34:16.701-04:00ApexSQL LogApplies 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: 1http://knowledgebase.apexsql.com/2011/02/installing-server-side-components-on_2066.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-7034606546558403926Mon, 21 Feb 2011 18:59:00 +00002012-04-03T12:16:09.771-04:00ApexSQL LogApplies 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 http://knowledgebase.apexsql.com/2011/02/installing-server-side-components-on_21.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-9194556100004056721Fri, 18 Feb 2011 17:56:00 +00002012-03-20T13:30:27.939-04:00ApexSQL LogApplies 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 Pleasehttp://knowledgebase.apexsql.com/2011/02/installing-server-side-components-on.htmlnoreply@blogger.com (Dorotej)0tag:blogger.com,1999:blog-160707082233884630.post-2165210579635705878Fri, 14 Jan 2011 00:11:00 +00002012-04-24T11:35:35.675-04:00ApexSQL LogApplies 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 http://knowledgebase.apexsql.com/2009/03/how-to-audit-operations-for-dropped-or.htmnoreply@blogger.com (Dmitriy Dyubchenko)0tag:blogger.com,1999:blog-160707082233884630.post-8123936194180152230Wed, 29 Dec 2010 02:50:00 +00002012-03-20T13:51:57.618-04:00GeneralDescription 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 http://knowledgebase.apexsql.com/2009/05/what-kind-of-additional-information-i.htmnoreply@blogger.com (Anna Lesniak)0tag:blogger.com,1999:blog-160707082233884630.post-2363046045373520706Thu, 23 Dec 2010 01:40:00 +00002012-03-19T18:06:07.463-04:00Apex SQL EditApplies 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\%http://knowledgebase.apexsql.com/2009/08/what-files-should-be-backed-up-to-copy.htmnoreply@blogger.com (Anna Lesniak)0tag:blogger.com,1999:blog-160707082233884630.post-4930732296105274026Wed, 01 Dec 2010 18:02:00 +00002012-04-24T11:34:19.633-04:00ApexSQL LogApex SQL AuditApplies 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 http://knowledgebase.apexsql.com/2007/07/how-to-choose-between-apexsql-audit-and.htmnoreply@blogger.com (Janice Lee)0tag:blogger.com,1999:blog-160707082233884630.post-289673718282953309Fri, 19 Nov 2010 20:45:00 +00002012-04-27T19:10:45.923-04:00ApexSQL LogApplies 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 http://knowledgebase.apexsql.com/2010/11/how-to-automate-daily-reporting-with.htmlnoreply@blogger.com (Milena Petrovic)1tag:blogger.com,1999:blog-160707082233884630.post-3205522747402535943Tue, 09 Nov 2010 19:38:00 +00002012-03-20T13:33:58.075-04:00ApexSQL LogApplies 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 http://knowledgebase.apexsql.com/2010/11/server-side-components-cant-be.htmlnoreply@blogger.com (Milena Petrovic)0tag:blogger.com,1999:blog-160707082233884630.post-9066593518251859466Wed, 03 Nov 2010 16:44:00 +00002012-03-20T13:34:42.835-04:00ApexSQL LogApplies 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, http://knowledgebase.apexsql.com/2010/11/whats-difference-in-results-for-enabled.htmlnoreply@blogger.com (Milena Petrovic)0tag:blogger.com,1999:blog-160707082233884630.post-8899294955907686657Wed, 03 Nov 2010 16:05:00 +00002012-04-09T07:40:17.179-04:00Apex SQL RefactorApplies 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, http://knowledgebase.apexsql.com/2010/11/apexsql-debug-and-apexsql-refactor.htmlnoreply@blogger.com (Milena Petrovic)0tag:blogger.com,1999:blog-160707082233884630.post-6786482078668177374Mon, 11 Oct 2010 17:55:00 +00002012-03-29T17:16:12.493-04:00ApexSQL LogApplies 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 http://knowledgebase.apexsql.com/2010/10/how-to-uninstall-apexsql-log-server.htmlnoreply@blogger.com (Sasha Pesic)0