Release Notes:  This document describes changes and enhancements made to ApexSQL Log

Best viewed with 'WORD WRAP' unchecked

--------------------------------------------------------------------------------------------------
 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 "<default>" 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 "<Select Database>" to "<default>"
- Application crashes when exiting using File | Exit
- Log analysis can't be cancelled with Cancel button on progress form
- Filtering by UNKNOWN tables works incorrectly
- Horizontal scroll bar is missing in Log Selection Wizard
- Filtering by dropped tables doesn't work when database does not contain tables
- Operation type (INSERT, UPDATE or DELETE) can be changed in operations grid
- Link for Support Forum program group in Help | ApexSQL Online | Online Support menu is incorrect

Changes: 

- Transaction log reading is now done in the natural order of operations and not based on the end-of-transaction time
- Grid toolbar is hidden by default
- Icons were removed from Transactions filter in Log Filter Wizard 

--------------------------------------------------------------------------------------------------
 RELEASE:       2008.01.0609
 DATE:          11 November 2008
 DESCRIPTION:   Major release
 NOTE:          On 2008, ApexSQL Log was split into two products: ApexSQL Log and ApexSQL Recover.
                The functionality of the Recovery Wizard of ApexSQL Log has been moved to this new product, ApexSQL Recover.
                ApexSQL Log will continue to exist and will primarily be used for auditing.
--------------------------------------------------------------------------------------------------

Enhancements:

- Added support for reading SQL Server 2008 transaction logs (MAJOR ENHANCEMENT)
- Added support for new SQL Server 2008 types (MAJOR ENHANCEMENT):
    DATE, DATETIME2, DATETIMEOFFSET, TIME, HIERARCHYID, GEOMETRY, GEOGRAPHY
- Added database backups as optional source of auditing data (MAJOR ENHANCEMENT)
- Added support for COLLATE and code pages in auditing and recovery (MAJOR ENHANCEMENT)
- Improved scalability when working with very large transaction log files by an order of magnitude (MAJOR ENHANCEMENT)
- Improved general auditing performance by approximately 25%
- Added support for filtering uncommitted transactions
- Added support for in-row values of XML data type
- Added integrity check for server-side components
- Added tabled IDs to CREATE/DROP TABLE statements
- Added new button to main toolbar to change log filter settings
- Added Summary dialog after log is processed
- Improved statistics logging for queries and global memory
- Improved Table ID mapping dialog for easier to use

Fixes:

- Performance problem when reconstructing updates on tables with clustered indexes.
- A problem with transaction log reading.
- A minor problem with application's finalization.
- A minor problem with logging.
- A problem with MONEY and SMALLMONEY formatting.
- Filtering Using Table Row Data.
- There is no hotkeys for 'Executable' and 'Arguments' edits in Options dialog.
- Quotation marks for path to other editor in Log option are added.
- Current Row Panel can be closed but can't be opened again.
- Row grid is cut off.
- Exception raises if try to open Diff window for Update records.
- “NullReference” Exception encountered when re-opening log result rows as a new view
- Existing Filter file path field loses its focus after entering any character
- Log Selection for <default> DB leads to the empty tree node in the Server explorer
- Cannot connect to local SQL Server 2008 server

Changes:

- Separated toolbar items into Grid, File, and Result
- Moved application log and other temporary application files from "Program Files" to user's own directories
- Removed file naming tags from Options dialog
- Moved all items from Exports context menu to Results menu
- Moved all items from Grid menu to Results menu
- Reorganized controls from Tables step of Log Filter Wizard
- Controls for picking time range in Log Filter Wizard moved to Transactions node
- The functionality of the Recovery Wizard of ApexSQL Log has been moved to a new product, ApexSQL Recover.
- SPID fields are edited with a new dialog
- Description filters in Log Filter Wizard are edited in grid
- Removed navigation buttons from main toolbar
- Removed "Save As", "Reset" and "Defaults" buttons from Log Filter Wizard
- "Operations" node in Log Filter Wizard is renamed to "Transactions"
- Controls on "Transactions" page of Log Filter Wizard are rearranged
- "Current operation" panel is moved to Log form and renamed to "Transaction Information".
- "Open Logs" node in Server Explorer is removed

----------------------------------------------------
 RELEASE:      2005.11.0534
 DATE:         03 June 2008
 DESCRIPTION:  Medium Fix release
----------------------------------------------------

Enhancements:

- Improved transaction log reading performance.
- Added reading of transaction logs for February CTP of SQL Server 2008.

Fixes:

- A problem with UPDATE reconstruction when row has versioning info data (MAJOR FIX)
- A problem with row reading when row has versioning info data (MAJOR FIX)
- A problem with UNDO statements not being output in reverse.
- A problem with clustered indexes with more than one variable length column.
- A problem with UPDATE reconstruction when analyzing databases created on SQL7/2000 but now hosted on SQL 2005/2008.
- A problem with passing through invalid rows when field filtering is used.
- Remove incorrectly logged messages during some recovery processes.
- A rare problem with transaction log reading on SQL Server 2005/2008.
- A rare problem with transaction log reading on SQL Server 2005/2008 with databases upgraded from SQL Server 7/2000.
- A rare problem with tempdb getting blocked on SQL Servers with very high load level.
- A rare problem with error message on databases with compatibility level 70.

Changes:

- Moved application log and other temporary application files from "Program Files" to user's own directories.

----------------------------------------------------
 RELEASE:      2005.10.0502
 DATE:         05 November 2007
 DESCRIPTION:  Medium Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added support for ApexSQL Log API (MAJOR ENHANCEMENT)
- Further improved quality of UPDATE reconstruction process (MAJOR ENHANCEMENT)
- Added support for online transaction log reading on Vista 64-bit and Windows 2008
  64-bit (MAJOR ENHANCEMENT)
- Added experimental support for Itanium (IA64) platform for both SQL Server 2005 IA64 and
  SQL Server 2000 64-bit.
- Added experimental support for SQL Server 2008 on all platforms.
- Added support for INSERT and DELETE operations affecting more than one row to auditing and exports.
  (added "ROW_ORDINAL" to LOGNAV_RECORD table, "row_ordinal" tag to XML export and "Row Ordinal" to CSV export.)
- Improved the performance of table, user name, application name and client host filtering.
- Improved scaling for large auditing sets in GUI.
- Improved overall scaling.
- Added REDO/UNDO mark to REDO/UNDO scripts.
- Added table existence check in DDL statemens in recovery scripts.
- Added recovery of user defined data types from detached MDF files.

Fixes:

- A problem when multiple transaction log backups are specified (MAJOR FIX)
- A crash during exporting (MAJOR FIX)
- A resource leak problem after auditing is finished affecting memory and other resources (MAJOR FIX)
- A problem with Connection Monitor stopping to capture logins without restarting (MAJOR FIX)
- A problem with BLOB recovery sometimes not working correctly when doing recovery from detached MDF files (MAJOR FIX)
- A problem with online transaction auditing on Vista.
- A problem with filtering of users retrieved uniquely by SID.
- A problem with Connection Monitor when TCP/IP connections are disabled.
- A problem with new user names, application names and client hosts filters not included
  by default in the filter even when all names were previously selected.
- A problem with invalid XML characters in XML output.
- A problem with auditing read-only databases.
- A warning messages in generated BULK scripts.
- A problem with UPDATE operations logged due to change in table schema.
- A problem with some UPDATE operations not being used in UPDATE reconstruction.
- A problem with operations on forwarded stub rows passing through as data row operations.
- A problem with not showing types of values in SQL_VARIANT fields.
- A problem with resulting XML file when /no_header switch is specified.
- A problem with resulting XML file when /append switch is specified.
- A problem with status bar not updated when no operations are found.
- A problem with no refresh of progress bar before first operation is found.
- A problem with "Cancel" button being the default button in Recovery Wizard.
- A problem with long-running server operations giving time-out error.
- A problem with missing timestamp column value in WHERE clause of UNDO/REDO scripts even when it's part of PK/clustered index.
- A problem with running Recovery Wizard from Server Explorer when using SQL Server authentication.
- A problem with SQL Server authentication form demanding non-empty password.
- A problem with transaction log backups sometimes not automatically offered by Log Selection Wizard.
- A problem with showing user's SQL login name instead of NT user name when both have the same SID.
- A problem with recovery of deleted rows from transaction logs when under evaluation.
- A problem with connection "leak" in Recovery Wizard.
- A rare problem with mixup of db ID, file ID and transaction log file names.
- A rare problem with reconstruction of variable-length columns data.
- A rare problem with output of <operation> tag in XML export.
- A rare problem Connection Monitor not working on default SQL Server instances.
- A rare problem with default server name in setup.
- A rare problem with some transaction log operations not being loaded.
- An unclear error message when accessing online transaction log files in SIMPLE recovery mode.
- Various problems in error, warning and information messages.

Changes:

- Renamed xp_ApexSqlLogMonitor_* extended procedures to xp_ApexSqlConnectionMonitor_*
- Removed LOGNAV_RECORD2 primary key from LOGNAV_RECORD table and added LOGNAV_RECORD3 primary key.

----------------------------------------------------
 RELEASE:      2005.04.0453
 DATE:         15 May 2007
 DESCRIPTION:  Medium Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Greatly improved reconstruction of UPDATE operations (MAJOR ENHANCEMENT)
- Greatly improved memory footprint and performance scaling (MAJOR ENHANCEMENT)
- Added support for recovery of VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) data types from
  database files (MAJOR ENHANCEMENT)
- Improved support for transaction log backups converted from 3rd party backups (MAJOR ENHANCEMENT)
- Added partial reconstruction of changes made to fixed-length fields in UPDATE operations.
- Added partial support for recovery of XML data type from database files.
- Added support for reading SQL Server 7/2000 transaction logs under SQL Server 2005.
- Added support for reading SQL Server 2005 transaction logs under SQL Server 7/2000.
- Added more recovery reports details to recovery scripts.
- Added dummy data to BLOBs that are partially recovered due to lack of data.
- Added "row partially reconstructed" column to SQL, BULK, CSV and XML exports.
- Added "/run_small" switch to command line interface which forces the application not to save
  most of intermediate files on the hard drive. If there is less than 5% free space on the drive
  the application will switch automatically to "run small" mode.
- Added recovery script path selection to Recovery Wizard.
- Added table mapping to MDF data recovery.
- Improved generated recovery scripts for less-than-perfect data recovery scenarios.
- Improved progress bar during transaction log reading.
- Improved reliability of BLOB recovery algorithm.
- Improved auditing performance in general.
- Improved memory managment when under memory pressure.
- Improved formatting for REAL and DOUBLE SQL types.
- Improved diagnostic logging.
- Integrated client-side and server-side setups into one setup.

Fixes:

- A set of problems with server-side components running on SQL Server run by non-administrator account (MAJOR FIX)
- A problem with relying on @@SERVERNAME for server name on repeated connections which
  blocked re-connections for servers not accessible through their @@SERVERNAME (MAJOR FIX)
- A problem with UPDATETEXT and line breaks in BLOB recovery (MAJOR FIX)
- A problem with double reading of log files during open (MAJOR FIX)
- A problem with recovery of some system table structures (MAJOR FIX)
- A problem with primary key values in SQL export (MAJOR FIX)
- A problem with XML data type recovery (MAJOR FIX)
- A problem with some recovery options not working correctly on remote servers (MAJOR FIX)
- A problem with putting server logs to system32 (or SysWOW64) directories. Now server logs are all in LOG
  directory of SQL Server instance.
- A problem with recovery of dropped tables in SQL Server 2000.
- A problem with bad IDENTITY status for some reconstructed tables on SQL 2005.
- A problem with grid refresh if the last transaction was rolled back.
- A problem with clustered index keys not shown for un-reconstructed UPDATE operations.
- A problem with in-row values in NTEXT fields not correctly shown.
- A problem with recovery of BLOB data of NTEXT columns.
- A problem with NVARCHAR(MAX) columns in recovered table structures.
- A problem with some field values not being exported on UPDATE operations.
- A problem with application crashing when trying to write to a read-only file.
- A problem with "File not found" exception when doing recovery from online database files.
- A problem with extended procedure connecting back to SQL Server and being rejected due to lack of permissions.
- A problem with SQL authentication not working correctly when accessing logs from server tree.
- A problem with SQL authentication if invalid user/password entered.
- A problem with a label on SQL authentication user/password window.
- A problem with relying on @@SERVERNAME to start Connection Monitor.
- A problem with temporary UNDO/REDO scripts not having SQL extension.
- A problem with table structure lines not ending with consistent UNICODE line endings.
- A problem with reaching EOF of online database files.
- A problem with declaration of FLOAT data type in generated scripts.
- A problem with duplicate column names in some recovered table structures.
- A problem with duplicate table names in some recovery scenarios.
- A problem with lingering IDENTITY_INSERT state after a generated INSERT with identity fails.
- A problem with inserting NULL field values into NON-NULL columns in some recovery scenarios.
- A problem with application always demanding valid file paths in sysfiles.
- A problem with recovery of tables with timestamp columns in some recovery scenarios.
- A problem with duplicate servers in "Server Activation Center" dialog.
- A rare problem with BLOB data updates being out of range for the current BLOB values.
- A rare problem with not loading all operations in some circumstances.
- A rare problem with command line interface not creating log files correctly.
- A rare connectivity problem on SQL Server 2005.
- A rare problem with activation not working correctly.
- A rare problem with activations on multiple instances of SQL Server 2005.
- A rare problem with NULL values crashing the application.
- A very rare problem with calls to some empty extended stored procedures hanging on SQL 2005.
- A very rare problem with Connection Monitor not resetting on consecutive errors.
- A very rare problem with ApexSQL Server Helper driver sometimes crashing on SMP machines.

Changes:

- Increased drive usage for intermediate and temporary files during auditing/recovery, to approximately
  10-20% of transaction log file sizes. If there is less than 5% free space on the drive the application
  will switch automatically to "run small" mode thereby saving on drive space.
- Limited export options to exporting every 10th REDO/UNDO script during the evaluation period.
- Limited copy to clipboard for all REDO/UNDO scripts during the evaluation period.

----------------------------------------------------
 RELEASE:      2005.03.0417
 DATE:         29 December 2006
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added support for Windows 64-bit and SQL Server 2005 64-bit for x64 CPUs (MAJOR ENHANCEMENT)
- Added BLOB support in recovery of deleted rows and rows in truncated and dropped tables when using database
  sources for recovery (online database files and MDF files) (MAJOR ENHANCEMENT)
- Significantly improved performance of data recovery from MDF files, online or detached (MAJOR ENHANCEMENT)
- Added support for online transaction log and database files on drives mounted as NTFS folders.
- Added support for in-row values for BLOB types.
- Added SERVER_NAME column to Connection Monitor table allowing for filtering by the name of the server
  where transaction log was created.
- Added xp_ApexSqlConnectionMonitor_Enable and xp_ApexSqlConnectionMonitor_Disable extended procedures.
- In generation of UNDO/REDO statements:
    - Added SET IDENTITY_INSERT ON/OFF for INSERT operations.
    - Added transaction wrapping for DELETE operations.
    - Changed preference for construction of WHERE statments to primary key over clustered index.
    - For heap tables, added generation of WHERE clause from values of all non-BLOB fields.
    - Added skipping of BLOB and TIMESTAMP fields.
- In recovery from detached MDF files, added loading of meta-data from a live database when such is unaivalable in MDF files.
- For recovery on SQL Server 2005, modified algorhitms to improve chances of success in suboptimal recovery scenarios.
- Added SET NOCOUNT ON to recovery scripts.

Fixes:

- A problem with conversion of _variant_t to __int64 (MAJOR FIX)
- A problem with memory over-consumption (MAJOR FIX)
- A problem with activation not taking immediate effect on the server side (MAJOR FIX)
- A problem with old ID mapping feature (MAJOR FIX)
- A problem with multiple value switches in CLI (MAJOR FIX)
- Parsing of table names in command line interface (table names can now be specified with within angular brackets)
- A problem with NULL values in WHERE statements.
- A problem with UNICODE table names and table names with quotes in CLI and Recovery Wizard.
- A problem with Connection Monitor with automatic restart.
- A problem with Connection Monitor sometimes failing to flush rows from temporary login table.
- A rare problem with table names on case-sensitive databases.
- A problem with user ID showing as N/A even when it's known.
- A problem with refreshing of transaction log operations grid.
- A problem with NULL/NOT NULL flag in table DDL scripts.
- A rare problem with transaction log reading.
- A rare unhandled NULL exception.
- A rare problem of mistaken table ID for dropped tables on SQL Server 2005.
- An exception in About box when not connected to any server.
- Several errors in captions and messages.
- Several icons in the Log Filter dialog.

Changes:

- Last used filter now is stored per server and database.
- Added server name to login information captured by Connection Monitor.

----------------------------------------------------
 RELEASE:      2005.02
 DATE:         23 June 2006
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added "User Id" and "Login Time" columns to grid.
  "User Id" column shows either UID or SID depending on SQL Server version.
  "Login Time" column shows the time of the login of the connection on which the transaction was made.
- Added selection of available transaction log backups.
- Added selection of heterogenous log sources to GUI.
- Added in Row Details icons indicating columns that are part of table's clustered index or primary key.
- Added difference viewer for UPDATE operations.
- Added internal viewer of column values for INSERT and DELETE operations.
- Added column level regular expressions filter for tables in log operations grid.
- Added support for user defined types (non-CLR).
- Added milliseconds to to/from filters in CLI.

Fixes:

- A problem with user filtering (MAJOR FIX)
- A major performance issue (MAJOR FIX)
- A problem with CLR user defined types (MAJOR FIX)
- A problem with IS NULL row filter when used from GUI.
- A problem with reading of aborted transactions.
- A problem with showing application tab in task bar.
- A problem with opening new filtered log.
- A rare problem with remote installation failing on local server.
- A rare problem with UPDATE reconstruction.
- A problem with remote online transaction log auditing with files over 2Gb in size.
- A rare problem with server side logs not being found in system32 folder.
- An unhandled exception thrown by Field Values Filter with no continuation operator.
- A problem with BLOB fields appearing in UNDO/REDO statements.
- A problem with REDO/UNDO not taking into account the primary key on tables with no clustered index.
- A rare problem with row reconstruction.
- A rare problem with dropped table recovery when recovering from online database data.
- A problem with adding servers with expired trial version to the server tree.
- A problem with copying from REDO/UNDO tabs to clipboard.
- A problem with closing log window.
- Several minor GUI issues.

Changes:

- Limited the number of rows recovered by Recovery Wizard during product evaluation.

----------------------------------------------------
 RELEASE:      2005.01
 DATE:         01 March 2006
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added three command line options for server components installation (/install, /uninstall and /info)
  This allows for easy massive deployment/maintenance of server components in environments that need it
  (MAJOR ENHANCEMENT)
- Added additional logging information to Connection Monitor.
- Changed "Schema" grid column name to "Owner" for databases on SQL Server 7 and 2000 servers.

Fixes:

- Fixed a problem with Recovery Wizard toolbar button leading to exception (MAJOR FIX)
- Fixed a problem with persisted computed columns lacking name in the grid under SQL Server 2005 (MAJOR FIX)
- Fixed a problem with remote uninstall when repairing previous installation (MAJOR FIX)
- Fixed a rare problem with _variant_t conversion exception under some instances of SQL Server 2005.
- Fixed a problem with remote install.
- Fixed a problem with exception "Invalid object name 'msdb.dbo.APEXSQL_LOG_LOGIN'" on User ID filter page.
- Fixed a rare problem with ApexSqlLogXprocs.dll unload.
- Fixed some command line interface error messages.
- Fixed a problem with grid refresh resetting checked rows.
- Fixed a problem with SPID filtering in GUI.
- Fixed a problem with row history grid showing wrong row in the main grid.
- Fixed a problem with Find dialog with no now rows in main grid leading to exception.
- Fixed several minor visual issues.

----------------------------------------------------
 RELEASE:      1.90
 DATE:         22 February 2006
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

SPECIAL NOTE: ApexSQL Log 1.90 is the first per-instance licensed version of the software.
              For more information please see FAQ section in our help file.

Enhancements:

- Added support for SQL Server 2005 (MAJOR ENHANCEMENT)
- Added Recovery Wizard integrating all recovery options (MAJOR ENHANCEMENT)
- Added recovery of structure and data for dropped tables without relevant
  transaction log information (MAJOR ENHANCEMENT)
- Added recovery of deleted data even without relevant transaction log information (MAJOR ENHANCEMENT)
- Added recovery of structure and data from detached MDF files (MAJOR ENHANCEMENT)
- Added full support for UNICODE in all export options and CLI (MAJOR ENHANCEMENT)
- Added server and database name to BULK, SQL, XML and CSV exports.
- Added transaction state to BULK, SQL, XML and CSV exports.
- Added table owner information to grid and export.
- Automatic server components installation and updates, remotely or locally.

Fixes:

- Fixed a problem with bad exception handling during recovery.
- Fixed a problem with NULL reconstructions in REDO/UNDO scripts.
- Fixed a problem with badly created table for Connection Monitor.

Changes:

- Changed license structure from per-client to per-instance.
- Completely redesigned Connection Monitor to be an external process to SQL Server.
- Changed LogNavXp.dll file name to ApexSqlLogXprocs.dll.
- Removed LiveLogSetup.exe. Its functionality has been improved and integrated into ApexSQL Log client itself.
- Changed Filter management. Filters are now saved in separates files.
- Removed NULL value filtering for application names, login names and client hosts.
  These NULL value are now treated the same as unknown values during filtering.

----------------------------------------------------
 RELEASE:      1.86
 DATE:         21 November 2005
 DESCRIPTION:  Major Fix release
----------------------------------------------------

Fixes:

- Fixed excessive memory consumption problem (MAJOR FIX)
- Fixed Connection Monitor memory deallocation/fragmentation problem (MAJOR FIX)
- Fixed a problem with auditing of transaction log backups (MAJOR FIX)
- Fixed a problem with auditing of multiple logs (MAJOR FIX)
- Fixed two access violation problems (MAJOR FIX)
- Fixed a problem with refresh not working in some situations (MAJOR FIX)
- Fixed a problem with unknown users filtering in GUI (MAJOR FIX)
- Fixed a GUI filtering problem when application and client host values are NULL (MAJOR FIX)
- Fixed SQL Server login slowdown problem when APEXSQL_LOG_LOGIN table gets very large.
- Fixed database opening slowdown problem when APEXSQL_LOG_LOGIN table gets very large.
- Fixed filtering problems with mapped tables.
- Fixed a performance problem with auditing of transaction log backups.
- Fixed "Reached the end of the file" problem when doing recovery on remote servers.
- Fixed a missing rows problem that always occurred once a log source has been stopped during auditing.
- Fixed a CLI problem with source paths with spaces.
- Fixed a problem with variant_t conversion failing in server-side components.
- Fixed "OpenProcess(): Access is Denied" problem.
- Fixed DDL export so that it excludes uncommitted transactions.
- Fixed a problem with export of SQL Server sysusers login names in all exports.
- Fixed access violation when accessing same online log from two different connections.
- Fixed "Unknown LSN" exception when trying to locate a nonexistent row in the grid.
- Fixed a problem with DDL reconstruction of encrypted objects.
- Fixed a rare problem with column values shifting.
- Added missing "undo_ddl" to CLI help output.
- Removed spurious and duplicate application log traces.

----------------------------------------------------
 RELEASE:      1.85
 DATE:         20 July 2005
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancement:

- Added data recovery for dropped/truncated tables (MAJOR ENHANCEMENT)
- Significantly improved filtering by time making it independent of the size of the transaction log
  (MAJOR ENHANCEMENT)
- Significantly improved performance for previously opened logs by caching repeatable information
  (MAJOR ENHANCEMENT)
  NOTE: Opening logs for the first time is now slower because more work is done upfront.
- Significantly reduced memory needs especially for large log files (MAJOR ENHANCEMENT)
- Added committed/aborted operation filter (MAJOR ENHANCEMENT)
- Added application name filter to GUI.
- Added client name filter to GUI.
- Added minimum transaction duration filter to GUI.
- Added SPID filter to GUI.
- Enhanced transaction description filter in GUI.
- Maximum number of rows to be shown moved to operation filter.
- Added to GUI mapping of dropped sysobject IDs to tables now existing in database. Added automatic
  mapping through DDL analysis.
- Added persistence of mappings of dropped tables.
- Added export of DDL UNDO scripts.
- Enhanced Server Explorer, showing open logs as part of the server tree.
- Added "stdout" as tag for outputting export to standard output.
  For example, specifying "/xml:stdout" parameter will output audited data to standard output as XML.
- Enhanced user interface, history panel can be shown at the same time as the log data.
- Added new panels, on the same level with the history panel, for T-SQL undo/redo scripts.
- Enhanced row details panel.
- Added editing of T-SQL/DDL scripts with Microsoft Query Analyzer (tm)
- Added "State" column to the grid. Value in this column shows committed/aborted state of the operation.
- Many other user interface enhancements, boosting ease of use.
- Added compatibility level check. Log now refuses to work with databases below level 70 or above 80.
- Added warning/error logging to ApexSqlLog.log file.
- Added SPID to DDL output.

Fixes:

- Fixed a problem with not processing ALTER PROCEDURE/VIEW/TRIGGER/FUNCTION in DDL auditing (MAJOR FIX)
  These DDL operations are now shown as a combination of CREATE and DROP operations since they are logged so.
- Fixed a problem with memory not being freed correctly in some circumstances (MAJOR FIX)
- Fixed additional transaction information loading performance problem.
- Fixed a problem with reading of online and detached log files.
- Fixed reading of bit values.
- Fixed a problem in using Live Log for databases with invalid identifier for name.
- Fixed XML export end tag.
- Fixed BULK export script problem when using absolute paths for bulk files.
- Fixed "This key is already associated with an element of this collection" problem.
- Fixed login information being lost when open log fails.

----------------------------------------------------
 RELEASE:      1.84
 DATE:         06 April 2005
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancement:

- Added additional string output of raw binary data for unreconstructed UPDATEs.

Fixes:

- Fixed a problem with no historic reconstruction when using CLI (MAJOR FIX)
- Fixed a problem of too frequent querying of msdb.dbo.APEXSQL_LOG_LOGIN table.
- Fixed a problem with UPDATE reconstruction.
- Fixed a rare problem with auditing of online logs.
- Fixed a problem with "This key is already associated with an element of this collection" message
  in History view.

----------------------------------------------------
 RELEASE:      1.83
 DATE:         31 March 2005
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Major UI enhancement, application ported to office 2003 style with improved, user customizable menus, toolbars and docking panels.
- Added advanced field filtering supporting comparison and logical operators to command line interface.
  Supported comparison operators: =, !=, <, >, <=, >=, LIKE, IS NULL
  Supported logical operators: AND, OR
  NOTE: All comparison operations are performed with values as strings, not as fields' types.
- Added "/undo_ddl" export option to command line interface. UNDO DDL export outputs DDL statements that reverse made DDL changes.
- Automatically showing open log dialog when starting ApexSQL Log for the first time.
- Added multi-column sorting of the log information.
- Added group by multiple columns, without drag and drop.
- Added CREATE/DROP INDEX to DDL auditing.
- Much improved auditing performance when filtering by date/time, SPIDs and min. transaction duration.
- Much improved general auditing performance when auditing on a server with Connection Monitor installed.
- Improved auditing performance for online and detached files.

Fixes:

- Fixed a performance problem when auditing on a server without Connection Monitor installed. (MAJOR FIX)
- Fixed a performance problem when filtering by date/time. (MAJOR FIX)
- Fixed a problem with detection of SQL Server 7 in Connection Monitor (MAJOR FIX)
- Fixed a problem with Live Log not working on SQL Server 7 (MAJOR FIX)
- Fixed a rare incorrect UPDATE reconstruction problem. (MAJOR FIX)
- Fixed a GPF problem in XML export. (MAJOR FIX)
- Fixed "Invalid slot variable column count" exception problem. (MAJOR FIX)
- Fixed a problem with status bar not resizing panes.
- Fixed a problem with filter dialog not saving "Show operations on dropped tables" and "Show operations made by dropped tables".
- Fixed a problem with filter dialog erroneously restoring previously saved table filter.
- Fixed a problem with DDL auditing of primary keys and clustered indexes.

----------------------------------------------------
 RELEASE:      1.82
 DATE:         10 February 2005
 DESCRIPTION:  Major Fix release
----------------------------------------------------

Fixes:

- Fixed a problem of dropped logins in Connection Monitor. (MAJOR FIX)
- Fixed a rare problem with Live Log auditing. (MAJOR FIX)
- Fixed a problem with 100% CPU consumption while filter windows is open.

----------------------------------------------------
 RELEASE:      1.81
 DATE:         07 February 2005
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added Windows version checking for Live Log components.

Fixes:

- Fixed two problems with Log running on Windows NT 4 and below.
- Fixed a problem with SQL Script export.
- Fixed a rare GPF problem.
  
----------------------------------------------------
 RELEASE:      1.80
 DATE:         25 January 2005
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Major GUI overhaul:
    - Added server/database/source tree.
    - Added a list of currently open sources for easy switching between them.
    - Modified several UI features for the sake of clarity
    - Added new toolbar with many new options
- Changed command line interface syntax by adding "/" as a valid prefix and ":" as a valid suffix.
- Added minimum duration transaction filter to command line interface ("/min_duration:")
- Added usage examples to command line help.

Fixes:

- Fixed a UNICODE to ASCII conversion problem in DDL auditing.

----------------------------------------------------
 RELEASE:      1.74
 DATE:         18 January 2005
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Filtering dialog is shown immediately after log selection dialog cutting initial time to start filtering.

Fixes:

- Fixed another problem with "Operation is not allowed when the object is closed" exception.
- Fixed a problem with UPDATE reconstruction.

Changes:

- Log selection dialog is not automatically shown when entering Log client application. To open a log go to "File->Open Log".

----------------------------------------------------
 RELEASE:      1.73
 DATE:         13 January 2005
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added SPID to BULK, SQL, XML and CSV export.
- Added SPID to LOGNAV_RECORD table.
- Added DDL script for LOGNAV_RECORD and LOGNAV_RECORD_DETAIL tables to BULK script.
- Added "UNKNOWN (id)" for tables in CSV and XML export.
- Added PRINTs of LSNs of unreconstructed UPDATEs to BULK and SQL exports.

Fixes:

- Fixed a problem with GUI showing none or a small number of rows when Setting's
  "Maximum number of rows" is set to zero. Now, if this value is set to zero Log
  continues to search for rows until it reaches the end of the source or is stopped. (MAJOR FIX)
- Fixed a problem with corrupted column type in exports.
- Fixed a GPF problem when exporting CSV.
- Fixed a problem in DDL script with PK_LOGNAV_RECORD_DETAIL primary key object.

Changes:

- Removed "Source file is corrupted on LSN" message. Log now tries to recover to the best
  of its abilities.

----------------------------------------------------
 RELEASE:      1.72
 DATE:         11 January 2005
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Greatly improved auditing speed of both remote and local online logs.
- Greatly improved speed of advanced UPDATE reconstruction both for local and remote servers.
- UPDATE reconstruction now uses the new Live Log Boost! mode which further speeds up auditing when
  accessing SQL Server on local machine.
- Improved speed of SQL, BULK and XML export operations.
- Added "--ignore_case" (short "-i") switch to command line interface. When this switch is specified Log
  ignores case for table and user names.

Fixes:

- Fixed a problem with "Operation is not allowed when the object is closed" exception.
- Fixed a problem with TAB, CR and LF characters in BULK export.
- Fixed a problem with CR, LF and other lower ASCII characters in CSV, SQL, UNDO and REDO export.
- Fixed a problem with missing table ids from XML export.
- Fixed a problem with "include_dropped_users" CLI switch being turned on by default.

----------------------------------------------------
 RELEASE:      1.71
 DATE:         05 January 2005
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancements:

- xp_ApexSqlConnectionMonitor_Info now returns Connection Monitor's state as extended procedure's return value.

Fixes:

- Fixed an installation problem with previous version of LogNavXp.DLL not getting deleted during update.

----------------------------------------------------
 RELEASE:      1.70
 DATE:         03 January 2005
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- New Live Log Boost! mode speeds up significantly (up to 75%) access to online logs on local machine. (MAJOR ENHANCEMENT)
- Added BULK export option to command line. It is used by specifying "--bulk" on command line. (MAJOR ENHANCEMENT)
- Reboot-less server-side components installations/updates. Boot (or SQL Server shutdown) and manual
  Live Log reinstallation will be needed one last time. (MAJOR ENHANCEMENT)
- Improved UPDATE reconstruction if Live Log is installed on target server. UPDATE reconstruction is
  now first done against current state of the row and only if that fails historic reconstruction is done.
  (MAJOR ENHANCEMENT)
- Added Live Log client/server-side components version checking.
- Improved filtering performance for filters involving transaction properties (e.g. begin time, users, etc.)
- Improved Connection Monitor's start time.
- Improved performance for Live Log when accessing online logs on remote machines.
- Added finish times to XML and SQL export files.
- Improved performance for CSV and SQL export.
- Removed limitation of max. 10,000 operations in operations grid.
- Added wildcards for input files (like backups) to command line interface.
- Added new filter switches to command line interface:
    "applications" - filters operations per user applications
    "hosts" - filters operations per client hosts
    "spids" - filters operations per SPIDs
- Added dropped tables mapping switch "mapped_tables" to command line interface.
- Added export header suppression switch "no_header" to command line interface.
- Added "UNKNOWN(id)" text for unknown tables to SQL export.
- Improved command line interface error reporting.
- Expanded and improved help file.

Fixes:

- Fixed a problem with disappearing rows in operations grid.
- Fixed a problem with filters sometimes being too permissive.
- Fixed a problem with REDO/UNDO scripts when string fields contained apostrophe.
- Fixed a problem with command line interface and parsing of quoted file names.
- Fixed a GPF problem when opening two or more transaction log backups or detached logs at the same time.
- Fixed a missing quote in CSV export.
- Fixed a problem with missing logins in connection monitor.
- Fixed a problem with Connection Monitor not shutting down correctly.
- Fixed a problem with Connection Monitor not freeing LogNavXp DLL.
- Fixed a problem with quotes in UNDO/REDO scripts.
- Fixed a NULL in quotes value in SQL export.
- Removed database roles from the list of users.

Changes:

- Removed the syntax coloring in the export preview window due to the problems with amount of exported data.

----------------------------------------------------
 RELEASE:      1.62
 DATE:         19 November 2004
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added keyboard shortcuts for bookmark operations.
- Added tile horizontal and tile vertical window options.
- Modified user interface in order to improve usability.
- Added encryption for the saved SQL Server login password.
- Added "ignore_errors" switch to command line interface. When specified, non-parse errors like
  unknown user or table are outputted as warnings (to STDERR) but otherwise ignored.

Fixes:

- Fixed a problem with Live Log when SQL Server's service user was lacking proper permissions. (MAJOR FIX)
- Fixed a problem in exception handling.
- Fixed a problem with command line interpretation.
- Fixed a GPF problem.
- Fixed a problem with Live Log running on more than one instance on the same server.

----------------------------------------------------
 RELEASE:      1.61
 DATE:         11 November 2004
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added "append" switch to command line interface. When this switch is specified output is appended if
  output file already exists.
- Better arranged popup menu
- Added horizontal scroll bar to log view grid
- Added clear filter option to the filter dialog

Fixes:

- Fixed a command line problem when application was invoked with quotes around ApexSQLLog.com.
- Fixed a CMemoryException* unhandled exception problem.
- Fixed a problem with the progress bar in the status line.
- Fixed a problem with the maximum number of rows to be shown setting.

----------------------------------------------------
 RELEASE:      1.60
 DATE:         01 November 2004
 DESCRIPTION:  Major Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added User Rights auditing to DDL auditing. User Rights auditing includes sp_adduser, sp_dropuser
  and GRANT, DENY and REVOKE commands.
- Added NT user name, application and host to XML and CSV export.
- Improved CSV export formatting.

Fixes:

- Fixed the problem with grid refreshing and bookmarks.
- Fixed the crash that occurred sometimes while trying to export data through the preview dialog.

----------------------------------------------------
 RELEASE:      1.56
 DATE:         25 October 2004
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added collapse all, expand all groups in the log view grid.
- Added smaller default font for the export preview dialog.
- Added user and database to status bar.
- Added direct link with help to the filter dialog.
- Added printing of the log view.
- Restructured several help topics.
 
Fixes:

- Fixed an unhandled exception due to bad conversion from VARCHAR to DATETIME.
- Fixed a problem with trial reset when installing new versions.

----------------------------------------------------
 RELEASE:      1.55
 DATE:         20 October 2004
 DESCRIPTION:  Minor Fix release
----------------------------------------------------

Fixes:

- Fixed error that was occurring when opening log files without having Live Log server-side installed.
- Fixed a GPF bug with auditing of transaction log backup files.

----------------------------------------------------
 RELEASE:      1.54
 DATE:         17 October 2004
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added filtering for NT users.
- Added printing of log and history views.

Fixes:

- Fixed WHERE clause for NULLs in UNDO/REDO scripts.
- Fixed double-backslash filename problem in Live Log access.
- Fixed DDL script for LOGNAV_RECORD table.

----------------------------------------------------
 RELEASE:      1.53
 DATE:         12 October 2004
 DESCRIPTION:  Major Enhancement/Fix/Change release
----------------------------------------------------

Enhancements:

- Added "include_dropped_tables" and "include_dropped_users" options to command line interface
  in order to force inclusion of operations made on dropped tables or by dropped users.
- Added columns HOST_NAME and APP_NAME to LOGNAV_RECORD table.
- Added ApexSQLLog.dtd and ApexSQLLog.xsd files describing schema of XML export file.

Fixes:

- Fixed "Current transaction set is null(2)" bug when opening transaction log backups. (MAJOR FIX)
- In SQL Script export, user names for dropped users are now shown as "UNKNOWN (id)", not as blanks.
- Fixed the clear filter bug.

Changes:

- Changed default behaviour of command line interface to exclude operations made on
  dropped tables if at least one specific table is specified in filtering options.
- Changed default behaviour of command line interface to exclude operations made by
  dropped user if at least one specific user is specified in filtering options.

----------------------------------------------------
 RELEASE:      1.52
 DATE:         11 October 2004
 DESCRIPTION:  Major Feature/Enhancement/Fix release
----------------------------------------------------

Enhancements:

- SQL and XML syntax coloring.
- Added case-insensitive and whole-value fields filtering.
- Added filtering of "ShrinkFile" and "MoveIndexPage" transactions.
- Improved connection monitoring response times.
- Faster online logs analysis.

Fixes:

- Fixed a GPF problem when auditing backup files.

Changes:

- Changed to immediate response when refreshing.

----------------------------------------------------
 RELEASE:      1.51 (BETA)
 DATE:         03 October 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Enhancements:

- Added user and client transaction information into DDL script.

Fixes:

- Fixed a rare GPF when auditing backup files.
- Fixed a problem with initialization of Log connection monitor.

----------------------------------------------------
 RELEASE:      1.50 (BETA)
 DATE:         27 September 2004
 DESCRIPTION:  Major Enhancement release
----------------------------------------------------

Enhancements:

- Database Definition Language (DDL) auditing. Changes to system tables can now be
  exported as DDL statements from client and from command line (MAJOR ENHANCEMENT)
- NT user name, application name and client host auditing for SQL Server 2000. (MAJOR ENHANCEMENT)
- Multi-threaded UI showing operations as they are found. (MAJOR ENHANCEMENT)
- Added field value filtering to client and command line interface. (MAJOR ENHANCEMENT)
- Filters reuse. Filters can now be saved and later loaded for reuse. (MAJOR ENHANCEMENT)
- Added PRIMARY/CLUSTERED KEY exporting to SQL script and XML export. Added column ID_KEY to LOGNAV_RECORD table.
- Added "database", "previous_lsn" and "id_key" attributes to XML export. Changed "pk" element's name to
  "clustered_key". Added output of raw changes for unreconstructed UPDATE rows.
- Greatly sped up average UPDATE reconstruction. During UPDATE reconstruction Log now searches just
  for row's most recent INSERT operation, not for all previous operations.
- Added "exclude_system_tables" switch to command line.
- Empty log/backup error is now ignored when auditing through command line.
- Lowered average memory usage.

----------------------------------------------------
 RELEASE:      1.43
 DATE:         27 September 2004
 DESCRIPTION:  Major Fix/Change release
----------------------------------------------------

Fixes:

- Several GPF fixes.

Changes:

- Completely redesigned Live Log removing the any need for enabling/disabling Live Log
  during log shrinking as well as having "autoshrink" option turned to off. (MAJOR CHANGE)

----------------------------------------------------
 RELEASE:      1.42
 DATE:         10 August 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed corruption of "Spid", "Page Id" and "Slot Id" values in operations view.

Changes:

- Added creation of minidump files for unhandled exceptions. Minidump files store
  information stack information of all threads in the process but leave out any
  private audited information.
- Added attaching of created minidump files to unhandled exception dialog.

----------------------------------------------------
 RELEASE:      1.41
 DATE:         22 July 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed display of UPDATE details for non-clustered rows.
- Fixed display of raw UPDATE information.
- Fixed display of "Committed Time" and "Date" columns to operations view.
- Fixed a GPF problem.
- Preliminary fix for Live Log installation issue.

Changes:

- Added "Spid", "Page Id" and "Slot Id" columns to operations view.
- Added selection of columns in operations view to "Tools->Options" dialog.

----------------------------------------------------
 RELEASE:      1.40
 DATE:         18 July 2004
 DESCRIPTION:  Major Enhancement/Fix/Change release
----------------------------------------------------

Enhancements:

- Excluded logged operations that were made to IAM and PFS db structures and
  which do not affect user data. This eliminates most of unreconstructable UPDATEs.
  For information on IAMs and PFSs please see respective articles in SQL Server's Books-On-Line.
- Added display of raw UPDATE information for those UPDATEs that couldn't be reconstructed.

Fixes:

- Fixed "Invalid source position detected" problem.
- Fixed a GPF problem.

Changes:

- Implemented several important optimizations resulting in increased auditing speed.
- Optimized auditing of databases with large number of tables of columns resulting
  in major gains in speed.
- Time filtering is now done on commit time of a transaction. This presents more accurate
  picture of database state than the one when filtering by begin time.
- Added filtering by transaction description to UI and command line.
- Added details to "Live Log is not correctly installed..." message.
- Updated FAQ in the help file.

----------------------------------------------------
 RELEASE:      1.31
 DATE:         01 July 2004
 DESCRIPTION:  Major Fix/Change release
----------------------------------------------------

Fixes:

- Fixed a "Live log server-side components are not correctly installed." issue (MAJOR FIX)
- In SQL Script export, limited the size of exported values to 3800 characters.

Changes:

- Removed possibility for Live Log to work on "autoshrink" databases.
- Changed command line to use database's online logs if no source is specified.
- Added "timing" option to command line interface.

----------------------------------------------------
 RELEASE:      1.30
 DATE:         28 June 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed an auditing problem with transaction log backup files.
- Fixed a badly formed error message in Live Log.

Changes:

- Changed command line to use trusted security by default when neither "login"
  nor "password" options are specified.
- Added "verbose" option to command line.
- Added "include_log_tables" option to command line. ApexSQL Log's own tables
  are now ignored by default when working through command line.
- Improved command line messages.
- Added reinstall live log functionality to live log setup.
- Added additional checks for source corruption.
- Extended and fixed information in help file.

----------------------------------------------------
 RELEASE:      1.29
 DATE:         24 June 2004
 DESCRIPTION:  Minor Enhancement/Fix/Change release
----------------------------------------------------

Enhancements:

- Added CSV export to user interface.
- Added enabling/disabling of Live Log through Live Log Setup application and
  through command line interface. To enable this functionality Live Log Setup
  must be rerun on previous installations.

Fixes:

- Fixed unhandled exception problem due to user cancellation.
- Fixed minor help file errors.

Changes:

- Optimized Live Log usage of system resources.
- Extended information in help file.

----------------------------------------------------
 RELEASE:      1.28
 DATE:         15 June 2004
 DESCRIPTION:  Minor Enhancement/Fix release
----------------------------------------------------

Enhancements:

- Added CSV export to command line.

Fixes:

- Fixed a GPF problem.

----------------------------------------------------
 RELEASE:      1.27
 DATE:         09 June 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Second preliminary fix for an unhandled exception.

Changes:

- Updated help file.
- Changed activation dialog.
- Switched to sending error mails to bugs_log@apexsql.com.

----------------------------------------------------
 RELEASE:      1.26
 DATE:         08 June 2004
 DESCRIPTION:  Minor Fix release
----------------------------------------------------

Fixes:

- First preliminary fix for an unhandled exception.

----------------------------------------------------
 RELEASE:      1.25
 DATE:         07 June 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed a rare GPF problem.

Changes:

- Improved reporting on live log errors.
- Improved command line error reporting.
- Improved help file.
- Updated installation graphics.

----------------------------------------------------
 RELEASE:      1.24
 DATE:         30 May 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed a GPF problem with row reconstruction.
- Fixed a problem with trial period reset.
- Fixed a problem with ADO 2.6 version check.
- Fixed a problem with field details dialog and some field types.

Changes:

- Further optimizations to auditing speed.
- Changed default command line behaviour. Now if no parameters are passed on the command line
  ApexSQLLog.com shows the list of all possible command-line options.
- Changed activation dialog.
- Added HELP button to the login screen with more detailed information on SQL log files.
- Improved command line parsing error reporting.
- Improved Live Log setup explanation.

----------------------------------------------------
 RELEASE:      1.23
 DATE:         19 May 2004
 DESCRIPTION:  Minor Fix release
----------------------------------------------------

Fixes:

- Fixed an unhandled exception with UPDATE reconstruction.
- Fixed an unhandled exception with filtering.
- Fixed a refresh problem on small backup files.
- Fixed a rare problem with missing NULL values.

Changes:

- Added administrator privileges as installation condition.

----------------------------------------------------
 RELEASE:      1.22
 DATE:         16 May 2004
 DESCRIPTION:  Major Fix/Change release
----------------------------------------------------

Fixes:

- Fixed a problem with reading of transaction log backups.
- Fixed a problem with reading of live and detached logs.
- Fixed a problem with historic reconstruction and automatic UPDATE reconstruction.
- Fixed a live log refresh problem.
- Fixed a command line parsing problem.
- Fixed a command line and trial expiration problem.

Changes:

- Added LSN column for operations. LSN (Log Sequence Number) uniquely identifies
  operations on the level of database and it can be used to order operations in
  the sequence in which they happened.
- Added "Request support" option for error messages.
- Reorganized help file to ease navigation.
- Sorted user list in the filter option.
- Rearranged table and user filter pages.

----------------------------------------------------
 RELEASE:      1.21
 DATE:         04 May 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed Live Log's "cannot find the file specified" error.

Changes:

- Greatly sped up historic reconstruction. Speed of reconstruction doesn't
  depend on the log's size any more.
- Removed automatic filtering of operations made by nonexistent users.
  This can now be configured in Filtering dialog.

----------------------------------------------------
 RELEASE:      1.20
 DATE:         02 May 2004
 DESCRIPTION:  Major Enhancement/Fix/Change release
----------------------------------------------------

Enhancements:

- Added command line interface. Use it through "ApexSQLLog.com" executable.
- Added automatic UPDATE reconstruction.
- Added preview of exported files.
- Added copy to clipboard for exported files.

Fixes:

- Fixed couple of rare unhandled exception.
- Fixed a REDO problem with UPDATE operations.

Changes:

- Improved history reconstruction. It now works even when historic operations
  are filtered out.
- Improved error reporting.
- Updated About box with additional information.

----------------------------------------------------
 RELEASE:      1.15
 DATE:         18 March 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed a rare application failure that sometimes occurred while opening logs.

Changes:

- Added "Transaction duration" column.

----------------------------------------------------
 RELEASE:      1.14
 DATE:         17 March 2004
 DESCRIPTION:  Major Fix/Change release
----------------------------------------------------

Fixes:

- Fixed "log not found" problem that occurred on dynamic disks. (MAJOR FIX)
- Fixed a rare application failure that sometimes occurred while opening logs.
- Fixed a rare application failure that sometimes occurred while exporting to SQL or XML.
- Minor UI inconsistencies fixed.

Changes:

- Minor optimizations when reading transaction log backups.

----------------------------------------------------
 RELEASE:      1.13
 DATE:         03 March 2004
 DESCRIPTION:  Major Fix/Change release
----------------------------------------------------

Fixes:

- Fixed a serious performance issue when browsing large number of rows.

Changes:

- Added stack dump for unhandled system exceptions.

----------------------------------------------------
 RELEASE:      1.12
 DATE:         01 March 2004
 DESCRIPTION:  Minor Enhancement/Fix/Change release
----------------------------------------------------

Enhancements:

- Added detached SQL log support.
- Select all rows of the selected transaction.

Fixes:

- Fixed time filtering problem in UI.
- Updated contact information in help file.

Changes:

- Enhanced live log installation process with better and more complete messages.

----------------------------------------------------
 RELEASE:      1.11
 DATE:         20 February 2004
 DESCRIPTION:  Major Enhancement/Fix/Change release
----------------------------------------------------

Enhancements:

- Added generation of UNDO/REDO scripts.
- Added "Options" dialog [Tools->Options] with following options:
    - Number of rows for "show more rows" action
    - Turn on/off alternative transaction coloring
- Removed automatic filtering of operations on nonexistent tables.
  This can now be configured in Filtering dialog.
- Added option to select multiple rows.
- Added [Export as...] options that work on selected rows only.

Fixes:

- Fixed a rare problem with auditing of live logs.
- Fixed server name in open log dialog.
- Fixed default filenames for export options.
- Fixed a problem with computed columns.
- Fixed a problem with the time range filter.
- Fixed formatting of SMALLDATETIME values.

Changes:

- Now when refreshing log, database structure is also refreshed.
- Added FAQ to help file.
- Added "Clear filter" option [Edit->Clear filter]
- Added better description for "log file not found" error.
- Added timestamp to exported files.
- Added milliseconds output to DATETIME values.
- Various minor enhancements to UI.

----------------------------------------------------
 RELEASE:      1.10
 DATE:         21 January 2004
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Stopped Live Log from filling system's Event Viewer

Changes:

- Changed from LockwoodTech Log Navigator to ApexSQL Log
- Added stack dump to error reporting

----------------------------------------------------
 RELEASE:      1.06
 DATE:         14 November 2003
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed GPF that occurred if user tried to stop long running operations.
- Fixed non-Windows NT login and database combo interaction on log in dialog.

Changes:

- Changed ADO version check from error to warning.
- Enhanced Live Log error reporting.

----------------------------------------------------
 RELEASE:      1.05
 DATE:         05 November 2003
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed Live Log error handling.
- Fixed a GPF that sometimes occurred while browsing history.
 
Changes:

- Enabled Live Log to work with clustered SQL Servers.
- Expanded help file.
- Enhanced Live Log error reporting.
- Increased evaluation period to 60 days.

----------------------------------------------------
 RELEASE:      1.04
 DATE:         27 October 2003
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed main application window sending itself to background.
- Fixed a problem with accessing more than one live log at the same time.
- Removed record details dialog since it was showing was confusing and unusable information.

Changes:

- Added "Refresh" button to browse view
  [F5 is its keyboard shortcut, "Show More Rows" is now F6]
- History View is now always synchronized with Log view.
- Added database combo box to open log dialog.

----------------------------------------------------
 RELEASE:      1.03
 DATE:         24 October 2003
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Changed field size label to "Field length".
- Fixed "Unknown Class ID" issue.
- Fixed unhandled exception in "Check for updates..." option.
- Fixed problem with storing options for servers with explicit instance name.

Changes:

- Improved reporting of system errors.
- Added "busy" dialog for row history analysis.

----------------------------------------------------
 RELEASE:      1.02
 DATE:         08 October 2003
 DESCRIPTION:  Minor Fix/Change release
----------------------------------------------------

Fixes:

- Fixed "The handle is invalid" problem.

Changes:

- Optimized speed of access to live log files.
- Added "busy" dialog for XML and SQL export.
- Added ADO version check.

----------------------------------------------------
 RELEASE:      1.01
 DATE:         30 September 2003
 DESCRIPTION:  Minor Enhancement/Fix/Change release
----------------------------------------------------

Enhancements:

- Added "Type" column to row details.
- Added live log server-side components' version checking.

Fixes:

- Fixed "freeze" problem occurring after unsuccessful connections to logs.
- Switched to 14 days from day of installation trial period.

Changes:

- Added full support for sql_variant type.

----------------------------------------------------
 RELEASE:      1.00
 DATE:         25 September 2003
 DESCRIPTION:  Release 1.00
----------------------------------------------------

Enhancements:

- Added "busy" dialog for long running operations.

----------------------------------------------------
 RELEASE:      0.97 (BETA)
 DATE:         18 September 2003
 DESCRIPTION:  Minor Fix/Change release (BETA)
----------------------------------------------------

Fixes:

- Removed MSVCRT.DLL from installation.

Changes:

- Changed installation to support Client, Server and Client and Server types.

----------------------------------------------------
 RELEASE:      0.96 (BETA)
 DATE:         17 September 2003
 DESCRIPTION:  Minor Change release (BETA)
----------------------------------------------------

Changes:

- Switched live log opening to full UNICODE.
- Reports error in the case user tries to open a file with no log backups.

----------------------------------------------------
 RELEASE:      0.95 (BETA)
 DATE:         11 September 2003
 DESCRIPTION:  Minor Fix/Change release (BETA)
----------------------------------------------------

Fixes:

- Fixed "beta expired" issue.

Changes:

- Better live log error reporting.

----------------------------------------------------
 RELEASE:      0.94 (BETA)
 DATE:         07 September 2003
 DESCRIPTION:  Minor Fix/Change release (BETA)
----------------------------------------------------

Fixes:

- Fixed error reporting in case live log is not installed.

Changes:

- Added 60 days from day of installation beta period.
- Added registration procedure.

----------------------------------------------------
 RELEASE:      0.93 (BETA)
 DATE:         31 August 2003
 DESCRIPTION:  Minor Fix/Change release (BETA)
----------------------------------------------------

Fixes:

- Fixed ADO exception handling.
- Fixed several other errors.

Changes:

- Added OS and ADO versions to unhandled exception info.
- Better error reporting.

----------------------------------------------------
 RELEASE:      0.92 (BETA)
 DATE:         04 August 2003
 DESCRIPTION:  Major Enhancement/Change release (BETA)
----------------------------------------------------

Enhancements:

- Added support for live log and backup log files larger than 2Gb.
- Added version number to unhandled exception report.

Changes:

- Set encoding of exported XML file to ISO-8859-1.
- Optimized memory usage and speed of navigating.

----------------------------------------------------
 RELEASE:      0.91 (BETA)
 DATE:         31 July 2003
 DESCRIPTION:  Minor Enhancement/Fix release (BETA)
----------------------------------------------------

Enhancements:

- Added live log sources for Microsoft SQL Server 7 running on Microsoft Windows 2000/XP/2003.
- Added *.trn file type of backups.

Fixes:

- Fixed unhandled exception reporting.
- Fixed connecting to master database on case sensitive servers.
----------------------------------------------------
 RELEASE:      0.90 (BETA)
 DATE:         28 July 2003
 DESCRIPTION:  Major Enhancement/Fix/Change release (BETA)
----------------------------------------------------

Enhancements:

- Added live log sources for Microsoft SQL Server 2000 running on Microsoft Windows 2000/XP/2003.
- Added live log server configuration.
- Added XML export.
- Added SQL script export.
- Added basic support for sql_variant and text/ntext/image data types.
- Added "SplitNext" transactions filter.
- Added "Split" transactions filter.

Fixes:

- Fixed problems on servers with case sensitive setting turned on.
- Fixed exporting so it exports only loaded rows of the source.

Changes:

- Better history header.
- Better handling of the unreconstructed history.
- Better open log dialog.

----------------------------------------------------
 RELEASE:      0.82 (BETA)
 DATE:         18 June 2003
 DESCRIPTION:  Major Enhancement/Fix release (BETA)
----------------------------------------------------

Enhancements:

- Added check for running app during installation/uninstallation.
- Improved setup.

Fixes:

- Fixed a major problem with installation of an OCX component.
- Login was using windows authentication even when not selected.
- Several toolbar button images changed.

---------------------------------------------------
 RELEASE:      0.81 (BETA)
 DATE:         06 June 2003
 DESCRIPTION:  Minor Enhancement/Fix release (BETA)
----------------------------------------------------

Enhancements:

- "Send report" option added to "Unhandled exception" dialog.
- "Unhandled exception" dialog now shows more exception data.
- Added descriptions for Windows system exceptions.

Fixes:

- Fixed a GPF that occurred under some special circumstances when accessing log backups.
- Fixed a GPF that when accessing record history in a source with no records.
- File paths containing spaces are now properly handled.
- All types of exceptions are now properly caught and handled.
- Removed a caption that was left over from development phase.

----------------------------------------------------
 RELEASE:      0.80 (BETA)
 DATE:         03 June 2003
 DESCRIPTION:  First release (BETA)
----------------------------------------------------