Release Notes: This document describes changes and enhancements made to ApexSQL Log Best viewed with 'WORD WRAP' unchecked -------------------------------------------------------------------------------------------------- RELEASE: 2011.01.1039 DATE: 16 December 2011 DESCRIPTION: Major Feature / Medium Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Application now supports auditing of SQL Server Denali CTP3 databases - Application now fully supports auditing of the following SQL Server Denali CTP3 DDL operations: CREATE/ALTER/DROP SEQUENCE CREATE/ALTER/DROP TABLE … AS FILETABLE CREATE/DROP COLUMNSTORE INDEX - Application will now run as 64-bit process under 64-bit OS - Server Activation Center dialog has been redesigned for improved usability - Connection Monitor Manager dialog has been redesigned for improved usability - Application stability has been improved when auditing larger than 32 GB transaction logs - Memory consumption has been improved when auditing transaction logs larger than 2 GB by preventing memory overuse - Performance has been improved by 40% when auditing transaction logs with more than 1,000,000 operations - Auditing of page and row compressed tables is now supported - Auditing of SPARSE columns is now supported - Application can now reconstruct changes made with SELECT INTO statements - Application can now reconstruct changes to numeric data stored in the vardecimal storage format - Application can now be started without requiring administrative privileges - User feedback dialogs have been updated for improved usability Fixes: - Incorrect database version is shown in status bar tooltip for SQL Server 2000 databases - “Mapped table doesn't exist in database.” error is encountered on editing or refreshing currently opened project when previously mapped table is deleted - Application prompts to install already installed Server Side Components if the connected user has insufficient privileges - Old table ID mapping doesn't work when transaction log processing is performed on the server with Server Usage option set to either ON or AUTO - Application requires administrative privileges to start - Connection Monitor Manager dialog is closed after any warning/error message not allowing fixing issue right away - Application doesn’t offer to install Server Side Components when sending server logs from a server with no Server Side Components installed - Export type option is always set to Output transactions and operations info into | XML file when editing project - Offline databases are displayed in database picklist on Connect to database tab of Project settings form - /no_header switch doesn't suppress outputting header for SQL export type in CLI - DATETIMEOFFSET values are scripted incorrectly into UNDO/REDO scripts - Update operations on BLOBs may be scripted twice into UNDO/REDO scripts Changes: - Server Side Components of all older versions will now be uninstalled from the server when installing a newer version - Progress dialogs have been updated to be more standard with other applications - Old and New Value comparison results in Column Data Viewer for UPDATE operations have been replaced with individual values Known Limitations: - Sorting, grouping and filtering get automatically disabled in main grid with corresponding message shown when amount of outputted operations exceeds 100,000 to maintain acceptable performance - Changes from WRITETEXT and UPDATETEXT commands are not detected - UPDATE operations affecting only data in obsolete BLOB data types (TEXT, NTEXT, IMAGE) are not detected - Change to the table data compression option renders reconstruction of older changes to the table data impossible -------------------------------------------------------------------------------------------------- RELEASE: 2010.02.1004 DATE: 16 February 2011 DESCRIPTION: Minor Feature / Medium Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Application now fully supports auditing of the following DDL operations: CREATE/DROP SCHEMA - Progress dialogs have been redesigned across the application for improved accuracy and usability - Server Side Components can now be uninstalled through Server Activation Center dialog - Connection Monitor Manager dialog has been redesigned for improved usability - Performance of UPDATE reconstruction has been improved for rarely updated rows (up to 400% depending on internal state of the operation) - Performance of data export has been improved up to 100% for BLOBs larger than 64 Kb - The following new switches have been added to CLI: /ifl [/intermediary_files_location] – Specifies location of intermediary files created during auditing - Delay in opening Filter step of Connection Wizard with lots of hosts, applications or user data has been eliminated - Amount of memory required for UPDATE reconstruction has been reduced by 10% on average Fixes: - GUI gets unresponsive when auditing with Server Usage option ON - System.InvalidOperationException exception is encountered when opening a project if ‘System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing’ security setting is enabled either in the Local Security Policy or as part of Group Policy - Searching through main grid with more than 100,000 operations results in System.NullReferenceException exception - ALTER PROCEDURE operations are not detected - Send Logs ribbon command does nothing if default email client is already opened - Select All Operations in This Transaction main grid context menu command selects incorrect operations in main grid with more than 100,000 operations - Operation Details, Row History, Undo Script, Redo Script and Transaction Information tabs show nothing if there’s only 1 operation in main grid - Export type settings get restored from projects incorrectly in GUI - Credentials used for accessing Connection Monitor with Connection Monitor Manager dialog aren’t persisted between sessions - System.ArgumentOutOfRangeException exception is encountered when scrolling main grid with more than 100,000 operations extracted from SQL Server 2000 transaction log - Backups don’t get specified in sample CLI command when exporting auditing results with backups among data sources - Changes in Date/time range filter get incorrectly reflected in sample CLI command shown when exporting auditing results - Comparison with NULL in Field values filter results in incorrectly formatted /fields switch argument in sample CLI command shown when exporting auditing results - "Switch 'css' is not recognized" error is encountered when executing sample CLI command generated for exporting auditing results to HTML - "SSA exception:" error is encountered when auditing remote SQL Server 2008 R2 instances with Server Usage option ON - “Value does not fall within the expected range” exception is encountered in CLI if /fields switch argument contains LIKE operator - Searching in Operation Details grid works incorrectly with more than 100,000 operations in main grid - "Trusted connection will be used" message gets outputted twice in CLI if /trusted switch was specified - Filter Converter doesn’t warn if specified file is of bad format - Textual data cannot be copied from Column Data Viewer - Corrupted Connection Monitor tables can cause performance degradation (up to 2 times and more) - Default Intermediary Folder application option can’t be set in CLI - Copy Rows to Clipboard ribbon command does not work if main grid is not focused - Usage of deprecated CLI switches /ddl, /undo_ddl, /include_dropped_tables, /exclude_system_tables, /include_dropped_users, /include_unknown_applications, and /include_unknown_clients does not result in warning - Column Data Viewer does not show binary data - Show filter row main grid context menu command does not work - Create Undo Script and Create Redo Script main grid context menu commands get disabled with more than 100,000 operations in the grid if all are selected - Values of TEXT data type are shown in hexadecimal form in Row History grid - Application cannot detect whether Server Side Components are already installed if connected user has insufficient permissions on the extended stored procedures installed as part of Server Side Components Known limitations: - Sorting, grouping and filtering get automatically disabled in main grid with corresponding message shown when amount of outputted operations exceeds 100,000 to maintain acceptable performance - Changes from WRITETEXT and UPDATETEXT commands are not detected - UPDATE operations affecting only data in obsolete BLOB data types (TEXT, NTEXT, IMAGE) are not detected -------------------------------------------------------------------------------------------------- RELEASE: 2010.01.0979 DATE: 23 August 2010 DESCRIPTION: Major Feature / Major Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - All transaction log processing can now be done on the server with only results sent to the client - Depending on the case auditing performed on the server can significantly improve overall performance vs auditing performed locally on the client (from 10% to more than 400%) - Server Usage options group has been added to Options dialog to control whether to perform auditing on the server. Available choices are Off (default), On and Auto - Application now fully supports auditing of the following DDL operations: CREATE/ALTER/DROP TABLE, CREATE/ALTER/DROP FUNCTION, CREATE/ALTER/DROP PROCEDURE, CREATE/ALTER/DROP TRIGGER, CREATE/ALTER/DROP VIEW, CREATE/DROP CHECK CONSTRAINT, CREATE/DROP DEFAULT, CREATE/DROP DEFAULT CONSTRAINT, CREATE/DROP FOREIGN KEY, CREATE/DROP INDEX, CREATE/DROP PRIMARY KEY, CREATE/DROP RULE, CREATE/DROP STATISTICS, CREATE/DROP TYPE, GRANT PERMISSIONS, RENAME OBJECT, REVOKE PERMISSIONS - Encrypted SQL Server objects get fully decrypted in auditing of DDL operations - DML and DDL operations can now be shown in grid with different background colors - Main grid can now display any number of operations - Application now supports filtering by Unknown transaction state - The following predefined filters have been added to Time range filter of Project wizard: "Whole transaction log", "Last 30 days", "Last 7 days", "Last 24 hours", "Last 60 minutes" - Each column on Columns filter step of Project wizard has appropriate tooltip - ‘Parent Object’ and ‘Parent Schema’ columns have been added to Main grid - New Office 2007 style interface with ribbon bar, quick access toolbar, and ApexSQL Log button has been introduced - New Resources ribbon bar has been introduced for quick access to Help page, Support forum, Training page, FAQs, Knowledge base, Troubleshooting, About and Get Updates dialog boxes - Filter files have been replaced with full-fledged projects - New standard Project Management dialog has been introduced - Project Management dialog now shows recently used projects or projects stored in any folder of choice - Projects can be Pinned/Un-Pined to Recent Projects list on Project Management dialog - Project description can be edited directly from Project Management dialog - 'Show on Startup' option has been added to Project Management dialog box - Startup Action options group has been added to Options dialog to control Project Management dialog behavior. Available choices are 'Show Project Management dialog', 'Show last opened project' and 'None' - Advanced button implemented in Project wizard displays additional steps (Database Backups, Old Table ID Mapping) - Filter converter has been implemented for converting old (ApexSQL Log 2008) filter files to new projects - Filter Defaults for Transactions, Operations and Other filters have been added to Options dialog - Specific backup sets can now be used as a data source - Exporting to SQL BULK format is now available from the ribbon in the form of "Export to SQL BULK" command - Server Activation Center dialog has been redesigned for improved usability - Main window Status bar has been redesigned and now shows numbers of checked and excluded by filter rows in addition to server and database names - New Comparison Statistics dialog is shown in response to clicking on checked or excluded by filter bars of main windows Status bar - New tooltip balloon has been added to data source bar of main window Status bar - Options dialog has been redesigned with new Office 2007 button bar - Application can now be presented in 3 color schemes: Blue, Silver and Black - Field Filter Editor has been redesigned and now supports accurate numeric comparison and nested conditions - New Field Filter Editor allows to filter operations based on 'Exclude if' or 'Include if' conditions - New Field Filter Editor criteria can use the following comparison operators: 'Equal', 'Not Equal', 'Between', 'Not between', 'Contains', 'Not contains', 'Begins with', 'Ends with', 'Any of' and 'None of' and the following logical operators: 'And', 'And not', 'Or' and 'Or not' - Installing server-side components remotely now doesn’t require administrative shares on the remote server (requires membership in the sysadmin server role) - UPDATE reconstruction has been improved and now covers even more edge cases which results in improved accuracy of auditing trail - GO commands are inserted every few transactions in SQL scripts - The following connection options have been added to Connection step of Project wizard and Connection Monitor Manager login form: 'Connection timeout', 'Execution timeout' and 'Encrypt connection' - Old Table ID mappings information is now displayed in CLI - Online transaction logs and available database backups are now identified faster (proportionally to their count) - The following new switches have been added to CLI: /eut [/exclude_user_tables] - Excludes all user tables from auditing, /ist [/include_system_tables] - Includes system tables in auditing, /edt [/exclude_dropped_tables] - Excludes operations made on dropped tables, /edu [/exclude_dropped_users] - Excludes operations made by dropped users, /eua [/exclude_unknown_applications] - Excludes operations made by unknown applications, /euc [/exclude_unknown_clients] - Excludes operations made by unknown clients, /ssa [/server_side_auditing] – Specifies server usage mode /pr [/project] – Specifies path to project file Fixes: - Server-side components can’t be installed on Windows Vista/2008 Server/7 with User Account Control (UAC) on - “Exception occurred while flushing data: Timeout expired” error accompanied by Connection Monitor stoppage is logged into application log - "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM." error is shown on attempt to audit detached log files from different databases at the same time - User tables aren’t selected by default on Tables step of Filter wizard - SQL Server service shuts down if installation of server-side components fails - System.UnauthorizedAccessException exception is encountered in case default output folder is no longer accessible - "QueryDosDevice() failed - Access is denied" error is logged into application log in case SQL Server service is running under built-in ‘Network Service’ account - “ExecQuery failed: Unknown exception occurred” error is logged into application log on installation of server-side components in case the account SQL Server is running under has no EXECUTE permissions on xp_ApexSqlLog2008 or xp_ApexSqlLogApi2008 extended stored procedures - Server-side components cannot be uninstalled from local SQL Server 2008 instance under Windows Authentication - Available transaction log backups are not shown automatically on Data Sources step of Log Selection wizard - “Incorrect DBCC statement” error is encountered on install if selected SQL Server account has insufficient permissions - Application cannot upgrade server-side components when it fails to check SQL Server account permissions - Application is unable to read SQL Server 2005 transaction logs on SQL Server 2008 - Filters specified in Filter Field Editor don’t work for TEXT fields - Images stored in BLOB fields are not rendered as such on Row Details tab - /users CLI switch is case-sensitive - Processing progress isn’t updated for exports from Main grid - System.OutOfMemoryException exception is encountered when creating REDO/UNDO scripts for very large (>100M) BLOB fields - Inequality operators (>, <, => and <=) specified in Filter Field Editor work incorrectly for non-char data types - Backups selection done in Log Selection wizard is not remembered if auditing was canceled - Equality operator (=) specified in Filter Field Editor works incorrectly for MONEY data type - “Invalid pointer” error is encountered when purging login information in Connection Monitor Manager - “The requested operation requires elevation” error is encountered when starting application right from installer under Windows 7 Ultimate - System.Net.Sockets.SocketException exception is encountered on attempt to audit transaction log backups or detached transaction logs on remote SQL Server instance - System.OutOfMemoryException exception is encountered when auditing databases with >1M operations - “External component has thrown an exception” error is encountered when auditing SQL Server 2005 databases with >2G BLOB fields Changes: - The following CLI switches have been deprecated: /idt [/include_dropped_tables], /est [/exclude_system_tables], /idu [/include_dropped_users], /iua [/include_unknown_applications], /iuc [/include_unknown_clients], /ddl [/ddl], /ud [/undo_ddl], /mt [/mapped_tables] - Server-side components are no longer installed in SQL Server's Binn directory except for extended procedures dll which has to be installed there due to limitations of SQL Server - When activated for DDL operation Operation Details tab displays list of constituent operations performed on system tables - Old Table ID Mapping does not support mapping to IDs of system tables anymore - Server explorer panel has been deprecated - Connection wizard has been redesigned and merged into Project wizard - ‘Table’ column has been renamed to ‘Object’ in Main grid - Regular Help button has been replaced with question mark button in title bar on all dialogs and windows - Operations CLI switch (/ops [/operations]) now accepts DDL operations - ‘Number of operations to show’ Transactions filter option has been removed. Now everything that passes filter is outputted - The following options have been removed from Descriptions filter: Show 'SplitNext' Transactions, Show 'Allocate Root' Transactions, Show 'Split' Transactions, Show 'ShrinkFile' Transactions, Show 'MoveIndexPage' Transactions Known limitations: - Sorting, grouping and filtering get automatically disabled in Main grid with corresponding message shown when amount of outputted operations exceeds 100K to maintain acceptable performance Known issues: - State of server-side components is incorrectly identified if logged user is member of the db_datareader role in master database - System.OutOfMemoryException exception is likely to happen when exporting tables with large (> 10M) BLOB fields to HTML - ALTER VIEW DDL operation gets scripted as CREATE VIEW in REDO scripts - Named local SQL Server instances may be identified as remote which results in performance degradation - UPDATETEXT and WRITETEXT DML operations get reconstructed only when executed within the same transaction and consecutive to DML operation affecting the same row -------------------------------------------------------------------------------------------------- RELEASE: 2008.05.0834 DATE: 14 December 2009 DESCRIPTION: Major Feature, Major Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Application is now able to export auditing results to HTML format - Auditing intermediary files storage can now be configured via the new Default Intermediary Directory option. Intermediary files include transaction log metadata cache as well as application log files - The following new switches have been added to CLI: /intermediary_files_location - specifies location for intermediary files created during auditing /html - specifies the name of the HTML export file - New "Send client and server-side logs" menu item is added to Help menu. If no email client is installed, the client-side logs folder is opened - Connection Monitor can now be configured via the new Connection Monitor Manager form available from Tools menu - BLOBs containing images are now rendered as such in Row History grid for SQL Server 2005 and 2008 - BLOB reading now consumes less memory (up to 50% less) Fixes: - Connection Monitor is not started after installation - Create Undo/Redo Script main grid's popup menu items are disabled for selected row - Checking "Show system tables" option also checks user tables in Log Filter wizard - In-row filters aren't applied to main grid rows that were previously checked or unchecked - Special symbols (e.g. '-', '\', etc.) can be added into SPID filters in Log Filter wizard - Executing the “Auto Resize Columns” command from the tool button does not do the same thing as executing it from the main grid’s context menu - Toolbars contain unnecessary whitespace - Database backups have no associated icon on Select Backups step of Log Selection wizard - Not all available values are displayed on main grid’s in-row filter - No warning is shown if date input in /to switch is greater than the date in /from switch in CLI - Column Data Viewer is always empty for UPDATE operations if the client is operating under an operating system with Korean locale - Application doesn't support paths with Cyrillic characters - It's impossible to connect to SQL Server with Windows Authentication under Vista with active UAC - Log Filter wizard always shows transaction logs from last opened database vs the current database that the user is connected to - Hiding the in-row filter hides all rows from the main grid - The /fs switch is incorrectly described in the CLI help file - System.Exception exception is encountered if the account used for auditing doesn’t have SELECT permission on the mssqlsystemresource SQL Server 2005/2008 database - Transaction log backups are incorrectly shown on Select Database Backups step of Log Filter wizard - Server-side components installed during application are not uninstalled when client is uninstalled - "Export Checked As" command executed from its corresponding toolbar button or from the main grid’s context menu exports all columns from the main grid instead of exporting the selected/displayed columns only - Exporting to XML fails if initiated from the Log Filter wizard - When a machines' hardware ID changes, the server's activation status becomes invalid and re-activating is not possible - The application exports column values incorrectly - When generating REDO scripts, a System.OutOfMemoryException exception is sometimes encountered - "Unknown SQL Server version" error is received when reading SQL Server 2000 backups - Inaccessible transaction logs and database backups are still shown as data sources in Log Selection wizard - Chinese characters aren't shown on the main grid - NULL values are incorrectly exported as empty strings when the selected output is SQL BULK files - BULK import error is received when running an SQL BULK script with very large BLOBs - Very large BLOBs may cause application failures when being outputted to file - The larger result set is populated to the main grid the slower the populating is - Online transaction log files cannot be accessed sometimes on an x86 OS that has more than 4 GB of RAM - BLOB exporting consumes more memory than it should - Clustered indexes with variable-length columns are incorrectly outputted for SQL Server 2005 and 2008 - Variable-length column values are incorrectly outputted for SQL Server 2005 and 2008 - SPID values are incorrectly outputted for SQL Server 2008 - SMALLMONEY values are outputted incorrectly - The application doesn’t output all BLOBs found in data sources - UPDATE operations are sometimes not reconstructed correctly even when there is enough data to do so - BLOBs whose data type has been changed are outputted incorrectly - The application fails when it tries to output an invalid XML found in provided data source - Online transaction log and database files hosted on Windows 2000 cannot be read - REDO/UNDO scripts are incorrectly generated for tables with IDENTITY columns - The application fails when trying to read SQL Server 2000 database backups - Servers with expired evaluation can’t be activated - REDO/UNDO scripts are incorrectly generated for operations affecting new SQL Server 2005 BLOB types (e.g. varbinary(max), varchar(max), etc.) - Connection failure is received when application attempts to read a non-existing online file - Non-UNICODE multi-byte characters are exported incorrectly - Operations in UNDO scripts generated from the main grid are not scripted in reverse order - Operations in XML/CSV/HTML exports generated from the main grid aren't sorted the same as in the main grid - Unspecified exception is encountered when connection is lost during analysis - “The System cannot find the file specified” error is encountered when installing server-side components on SQL Server 2000 for the first time - System.AccessViolationException exception is encountered when selecting Row History tab for an operation on SQL Server 2000 table with BLOB columns - "Object reference not set to an instance of an object" error is encountered when exporting results from the main grid grouped by a column - Uninstalling application doesn't uninstall server-side components from the local server they have been installed on during installing - Date/Time filters sometimes return nothing instead of appropriate data - Margins are not saved in Preview Grid form - Maximize icon is missing in Preview Grid form - Unnecessary comma is outputted when exporting from the main grid in SQL Script format - CSV exports have no corresponding note in the header when the application is in evaluation mode - Operation times are outputted without quotation marks (‘) when exporting from the main grid in SQL Script format - Summary form shown on analysis completion sometimes reports total number of rows processed incorrectly - The /append CLI switch doesn't append analysis results to the specified file - The /verbose switch isn’t described in the CLI help output - “General network error” exception is encountered when selecting row in the main grid if connection with server is lost - "Uncheck All" command is disabled in the main grid's context menu when checking rows from Find form - Script path isn’t shown on Output Options step of Log Filter wizard on attempt when generating UNDO/REDO script right after SQL BULK files - Selected custom script editor doesn’t open if there’re spaces in the path to its executable - The application queries all database tables disregarding the specified table filter in CLI Changes: - Server-side components have been split to two independent sets: server-side components for ApexSQL Log and server-side components for ApexSQL Recover. On upgrade, un-used server-side components are deleted. * Split ApexSqlServerXprocs2008.dll into ApexSqlLog2008Xprocs.dll and ApexSqlRecover2008Xprocs.dll * Split ApexSqlServerHelper2008.exe into ApexSqlLog2008ServerHelper.exe and ApexSqlRecover2008ServerHelper.exe * Split ApexSqlServerHelper2008.sys into ApexSqlLog2008ServerHelper.sys and ApexSqlRecover2008ServerHelper.sys * Renamed ApexSqlConnectionMonitor2008.exe to ApexSqlLog2008ConnectionMonitor.exe - Renamed xp_ApexSqlConnectionMonitor2008* extended procedures to xp_ApexSqlLog2008ConnectionMonitor* - Renamed sp_ApexSqlConnectionMonitor2008* stored procedures to xp_ApexSqlLog2008ConnectionMonitor* - All server-side logs for the application's server-side components are consolidated into one log file: ApexSqlLog2008.log - The following error messages have been replaced with more informative equivalents: "Unknown error code: 128 during activation" "ApexSqlServerHelper2008 failed: OpenSCManager() failed: Access is denied. (error code = 5)" "Copy file for ApexSqlServerXprocs.dll failed: The system cannot find the path specified. (error code = 3)" "Cannot access transaction log file" "CreateService() failed: The specified service has been marked for deletion" "ApexSqlServerHelper2008 failed: log2::lnhf::GetFileDeviceName: Access is denied." "System.OutOfMemoryException" - All application logs, both client and server-side, are now in UNICODE - Evaluation period for each server has been changed from 30 to 14 days - New Activation Error form has been added to the application and will automatically be shown when an activation error occurs. This new form is more informative and simplifies the reporting of activation errors -------------------------------------------------------------------------------------------------- RELEASE: 2008.03.0716 DATE: 31 July 2009 DESCRIPTION: Medium Feature, Medium Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Column filtering is now available for file outputs in both GUI and CLI - Application now reports analysis progress in more details - The following new switches have been added to CLI: /transform_xsl - applies XSL transformation to XML export /export_columns - specifies columns to export /argfile - specifies argument file (used to reduce the number of switches specified) /console_width - sets output console width /force - overwrites existing file with same name /out_to - redirects console output to specified file - All CLI switches now have shorter versions/aliases (e.g. /transactions switch now has /tr alias) - Main grid performance was improved for large amounts of data (50+K operations) by approximately 70% Fixes: - Log Selection Wizard displays the same backup file multiple times if the backup file was used multiple times by the original database for backup - Errors in CLI calls, including typo errors, aren't reported - After main grid is refreshed, the first mouse click over the grid doesn't select anything - Backup selections are not remembered between sessions in the Log Selection Wizard - Progress indicator doesn’t move for any of text exports - Progress bar is not shown for UNDO script generating in the details pane - Backup files existence isn't checked prior to analysis - Not all operations are shown in the main grid for SQL Server 2008 transaction logs - Uninstaller doesn't remove server-side components from server - /D switch doesn't work if it's specified after /B switch and vice versa - Unicode symbols are shown incorrectly in the Data viewer dialog - Exception if user generates script to output folder via CLI without write permissions - Application does not process databases having names with special characters (e.g. "Master's") - Installation of server-side components after auto-updating from previous major version fails - On the initial use, application is opened with non-default options - /backup CLI switch can't find backups in current folder - Alt + "hot key" doesn't work in Log Filter Wizard Changes: - /login CLI switch renamed to /user - /include_unchanged_fields CLI switch renamed to /export_unchanged_fields - /detached CLI switch alias (/d) renamed to /dt -------------------------------------------------------------------------------------------------- RELEASE: 2008.02.0708 DATE: 02 June 2009 DESCRIPTION: Medium Feature, Medium Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Application can now read BLOBs from transaction logs - Transaction logs contents can now be outputted directly to file from GUI (UNDO and REDO scripts, XML, CSV, SQL and SQL BULK exports) - New Column filter step in Log Filter Wizard allows user to select which columns to output to grid - New Summary step added to Log Filter Wizard to show number of retrieved records - All grids in Log Filter Wizard now have standard context menus - Undo and Redo Script tabs now have standard context menus - HyperBac files can now be used as database backup sources - XML exports now include export start and finish times - /export_unchanged_fields switch was added to CLI - Table filtering performance was significantly improved (especially for rarely updated tables); performance improvement can vary Fixes: - Not all logged operations are shown when reading SQL Server 2008 transaction logs - Application incorrectly recognizes local SQL Server cluster, treating it as remote server, causing performance issues - Application can't connect to local instances of SQL Server 2008 using "(local)" in server field - Unknown field names appear in REDO DDL scripts under SQL Server 2005 - Patterns don't work on Tables step of Log Filter Wizard - SQL Server 2000 databases may contain "Schema" instead of "Owner" in application labels - Sorting and grouping by empty item are allowed in Sort and Group By forms - Database connection remains open after analysis is finished in GUI - Table ID may not be shown in operations grid - Log Filter may not be saved if it was opened for editing - Old Activation form may show up at application start-up - Activating application with Alt+Tab may result in exception - Search progress bar and status bar may show different number of operations - Column data viewer window is not modal - Database backups may not be shown in Server Explorer - Double-click on backup transaction log in Server Explorer may result in online transaction log being selected in Log Selection Wizard - "Local attribute name cannot be empty" error appears when trying to analyze "" db - Group By area is shown for all analysis windows by default - Tables cannot be filtered by checked state on Tables step of Log Filter Wizard - Row Details tab doesn't show user data types - REDO and UNDO DDL scripts are empty for any database under SQL Server 2008 - Activation form is shown on attempt to uninstall server-side components from non-existing server - "Check All" button in Find form does nothing - Operations' check state can't be changed with Space button in operations grid - Clear All Column Filters command works incorrectly when activated from context menu - Collapse/Expand items in context menu of Server Explorer are always enabled - Changing server in Log Selection Wizard changes selected database picklist item from "