Release:	2011.01.0056
Date:	May 08, 2012
Description:	Major feature, major fix release

Enhancements:

• SQL Server 2012 databases are supported for auditing now
• Progress dialogs have been redesigned across the application for improved accuracy and usability
• A new Office 2007 style interface with ribbon bar, quick access toolbar and ApexSQL Audit button has been introduced
• A 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
• A new Project Management dialog has been introduced
• The Project Management dialog now shows all projects as well as recently used ones
• Projects can be pinned/unpinned to the Recent Projects list in the Project Management dialog
• The project description can be edited directly from the Project Management dialog
• 'Show on Startup' option has been added to the Project Management dialog
• Startup Action options group has been added to the Options dialog to control the behavior of the Project Management dialog. The following options are available: 'Show Project Management dialog', 'Show last opened project' and 'None'
• The application now has 3 color schemes: Blue, Silver and Black
• The Options dialog has been redesigned with new the Office 2007 button bar
• Manage Data form has been redesigned for improved usability
• Tooltips have been implemented for all options in Options and Install Architecture forms
• Standard and Aggregate Report forms now detect if there is no available data to report
• The application doesn’t require administrative permissions to start on Windows Vista and later anymore
• The following connection options have been added to Project form: 'Execution timeout' and 'Encrypt connection'
• A grid toolbar has been implemented in Manage Audit Triggers, Standard and Aggregate Report forms
• Standard and Aggregate Reports can now be exported to PDF
• Standard Report CSV export performance has been improved
• Standard and Aggregate Report forms are now more responsive when working with large data sets (more than 10,000 operations)
• The following new arguments have been implemented for /architect_install CLI switch:
All [a] – install entire architecture

Fixes:

• Lookup data is captured on any audited column change not just the one the lookup was created for
• Trigger creation script is auto deleted on application close if its size exceeds 3 MB
• Application stops responding when connecting to a database without a project
• Number of audited fields instead of transactions occurred is shown in Aggregate Reporting form grid
• Auditing Triggers can be installed before Auditing Architecture
• Changes to float columns are audited with precision loss to 2 digits after dot
• ‘Delete Data by Log Size’ criteria is considered even if not selected when deleting data criteria-based in Manage Data form
• Watches cannot be removed after clicking empty area in Watches list
• Tables cannot be checked with Space button in main grid
• Main form is not maximized at application startup
• Template Editor Description and Legal fields are not updatable
• Standard and Aggregate Reporting forms don't show the resize indicator in the right bottom corner
• ‘Old value’ and ‘New value’ columns in Standard Reporting form grid expand to fit the entire value that may cause them to grow too large
• Varbinary(max) values longer than 8,000 characters are shown truncated in Standard Reporting form grid
• “Undefined data” error is encountered when selecting a database containing Fulltext Stoplists
• False schema changes get detected if Auditing Triggers generation was cancelled
• Auditing Triggers cannot be created for new Tables and columns in CLI
• Table isn’t auto selected for auditing when its columns are selected
• Last used folders aren’t remembered within a session
• Checking/unchecking Auditing Trigger in Manage Triggers form grid expands all groups in the grid
• Default button on Edit Key for Table form when clicked disables Primary Key edit
• Save changes prompt is shown regardless of project state when auditing triggers generation is initiated from main grid context menu
• Scrolling a grid and checking a row not shown originally moves selection back to the first row in a number of places including Fields for pane, Manage Triggers form, etc.
• Connect to SQL Server form is shown system modal
• NULL values in varbinary columns are shown as ‘0x’ instead of ‘NULL’ in Standard Reporting form grid
• Recent projects list in File menu is not working
• Query Timeout option default value cannot be changed
• Refreshing main grid clears all column filters but leaves the grid filtered
• Columns of a new Table aren’t auto selected for auditing when ‘Automatically Check All New Fields’ option is ON

Changes:

• Undo Transactions feature has been deprecated
• Auditing architecture functionality has been moved to a newly implemented toolbar in the Manage Architecture form
• Main menu and toolbar have been removed from Standard and Aggregate Report forms
• ‘Export to Excel’ export item has been renamed to ‘Output to CSV’ on Standard and Aggregate Report forms
• The /profile switch has been deprecated and removed from the CLI
• The short name of the /project CLI switch is /pr now
• Default extension for project files has been changed from .axad to .axap
• /addtrigger CLI switch now requires a list of tables and columns to create auditing triggers for
• /remtrigger CLI switch now requires a list of tables to remove auditing triggers from

Release:	2008.01.0053
Date:	January 22, 2009
Description:	Major feature, medium fix release

Enhancements:

• Added support for auditing MS SQL Server 2008 tables
• Added support for new MS SQL Server 2008 data types (date, time, datetime2, datetimeoffset, geometry, geography, hierarchyid, filestream)
• Improved Project Creation form

Fixes:

• Error appeared during syntax check after triggers generating for a specific db
• Switching between default script editor options doesn’t trigger Apply button
• Jobs show up without names
• Save Project button doesn't get enabled whatever you do inside the project
• Open Existing Project opens "Open file" dialog instead Manage projects form
• Edit Project button in the toolbar opens the Manage Projects dialog
• Project Name which displayed in the Project grid is incorrect
• Text fields are audited incorrectly
• Insert and Update triggers are not installed on table with text field only
• Application crashes when executed on Win2008 x86 server
• CLI: /test switch does not show the list of parsed switches
• Exception at app startup if a project from the project history is corrupted
• Exception wheh using an empty project file
• Values format of Float and Real type do not correspond to initial ones from DB
• Standard report shows smalldatetime type similar to datetime
• Can't rename project in Wizard's grid
• Grouping item in context menu of recent projects in Project wizard has wrong state after reopen
• Master sys db appears in the database field by default
• Values of Time, DateTime and related data types have different format in reports

Changes:

• Using Web help file instead of local CHM

Release:	2005.07.0051
Date:	August 27, 2007
Description:	Minor fix release

Enhancements:

• Added ServerVersion property in Database object
• Added CompatibilityLevel property in Database object
• Added help button in the Sort by dialog
• Added help button in the Group by dialog
• Added help button in the Select Columns dialog

Changes:

• Audit.Print method can be used in include files
• Includes changes in Architecture File version 20.42
• Made always save password in connection file not depend of the Store Encryption Password option
• Moved to an arhitecture view AUDIT_UNDO to get audit log data for undo

Fixes:

• Job's run duration in history was shown incorrect
• Selections were loaded from ApexSQL Audit 2005.03 and older and were saved in incorrect format
• Incorrect work with 120dpi fonts
• Incorect work with databases from SQL Server 7.0
• Update project file on open only if needed
• Schema changes detection did not work if connection information is changed in the Project Wizard

Release:	2005.06.0048
Date:	March 6, 2007
Description:	Minor fix, major feature release

Enhancements:

• Database filter in Standard Reporting window
• Database filter in Aggregate Reporting window
• Customization of report filters
• Option show default owner/schema Qualification in common interface labels
• Options that prevent checking of unwanted fields
• Login form replaced with project wizard
• Database schema changes tracking
• Watches (ability to log unchanged field data on audited field change)
• Free grouping in main grid
• Group by dialog for main grid
• Sort by dialog for main grid
• Filtering for main grid
• Sorting for main grid
• Expand/collapse groups for main grid
• Free grouping in triggers grid (Manage Triggers Window)
• Group by dialog for triggers grid (Manage Triggers Window)
• Sort by dialog for triggers grid (Manage Triggers Window)
• Filtering for triggers grid (Manage Triggers Window)
• Sorting for triggers grid (Manage Triggers Window)
• Expand/collapse groups for triggers grid (Manage Triggers Window)
• Dockable panels for Fields, Triggers, Row Keys, Watches and Lookups
• Custom Row Keys
• Lookups (ability to log another table’s related field data on audited field change)
• Multiple value filters in Standard Reporting window
• Multiple value filters in Aggregate Reporting window
• Multiple value filters in Undo Transactions window
• Custom Filters in Standard Reporting window
• Custom Filters in Aggregate Reporting window
• Bookmarks in template editor
• Template change tracking in template editor
• ApexSQL Audit project support
• Project switch in CLI (/pf)
• Multiple value filters in CLI
• Faster triggers creation
• Faster metadata (re)loading
• Jobs processed as Unicode
• Faster Aggregate Report creation

Changes:

• Includes changes in Architecture File version 20.38
• Added DATABASE column in AUDIT_LOG_TRANSACTIONS table
• Template support storage in another db
• Split table name in AUDIT_LOG_TRANSACTIONS table
• Table AUDIT_LOG_DATA extends with fields KEY1-KEY4 to differently store row key data for Standard report
• MS Report Viewer is using instead Crystal Reports in reports output
• Does not show tables schema (owner) in messages, captions... and splits in reports
• Cut off work with system databases
• Automatically save project changes after triggers installed
• Removed include tab in Template editor
• Reworked IntelliSense in Template editor
• Changed Property Page UI in template editor
• Export reports only to Excel (in application), Excel (xls), Text (csv) and PDF formats

Fixes:

• Write multiple transactions in the audit storage when the triggers process actions with multiple row
• Exception when creating triggers in two application instances at the same time
• Unable create triggers in CLI if architecture is not in current folder
• Does not delete all triggers on remove architecture
• Binary and sql_variant datatypes are recorded properly
• Undo do not disable audit triggers at work
• Exception on save to read-only file
• Reading unused server information that needs extended rights when work with data management and jobs
• Exception throws when application analyzing database without installed architecture
• Row loses selections and focus after check/uncheck operations

Release:	2005.03.0030
Date:	May 6, 2006
Description:	Major fix, minor feature release

Enhancements:

• Set ToolTips for status bar
• Set Toolbars in report windows
• New Editor selector in options form
• Undo transactions grid allow check/un-check full transactions in undo transaction window
• Undo report window show describe text instead numbers

Fixes:

• Architecture save in not structured format, in single line
• Delete unused commands in main window
• Template not parsed before execute
• Template Editor show bad error position on parsing error
• Exception on try to enable/disable deleted trigger after last refresh/load database
• Don't show save message on change and close architecture in Architecture management window
• Exception on add column to grouping twice
• Delete architecture if "no" pressed in confirmation window
• Exception on export to excel
• Exception on deleted row when try undo transaction
• Date from/to in reports and schedule window may cause to exception
• Shortcuts for buttons in reporting windows changed
• Reset button not reset row count in standard report
• Not re-open architecture if need
• Job delete all rows when used row count criteria
• Use static table name definition in triggers. This is need to audit another user work
• Now set current date by default in filter in Standard Reporting window
• Allow load/save selections without selected database
• Exception on export to excel
• Update trigger write two rows on equal new and old values
• Test switch work not work with verbose switch in CLI mode
• Exception on loading bad selections file
• Used hourglass cursor on long time operations
• Set IsFirstAuditedTable property in object model
• Help on F1 in undo and undo report windows

Changes:

• Includes changes in Architecture File version 20.27

Known limitations:

• Report output not work with not installed Crystall Reports 9.0 in reports windows
• Undo not work with rows with changes in row key
• Can not undo transaction with long string data
• Not show warning message when try add existing column in grouping in Triggers Management window. Column not added

Release:	2005.02.0027
Date:	April 12, 2006
Description:	Minor fix release

Fixes:

• Use another .Net Framework runtime version from 1.1.4322
• Allow get multiple data reports in reports windows
• Throw exception when old architecture used in standard report window
• Throw exception on reading database structure
• Improved work with extended properties to aviod exceptions (exceptions can't be duped)

Release:	2005.01.0026
Date:	March 30, 2006
Description:	Major fix and minor feature release

Enhancements:

• SQL Server 2005 support
• Command line interface
• Support tables without primary key
• Index and Unique access support in template script
• Progress dialog for loading metadata from db
• Option exclude system databases

Fixes:

• Undo disable/enable triggers that not exists or disable in undo scripts
• Change set trigger last for getting error
• Automatic save selections without prompt on refresh database, close programm, change db
• Delete triggers owned by dbo user only
• Esc not close some windows or close more then one
• Columns width in grids to show full names
• Load prev arhitecture filename if new has bad format
• Work check/uncheck by space key in grids if other column active
• Multilple using one shortcut in one window
• Exclude temporary tables from auditing tables
• Undo SPs for work with long length columns and row key strings
• Undo SPs for work with computed columns in row key
• Row key generation with numeric (non strings) types
• Filter 'date to' in reports not include date
• Show script running info in result dialog
• Undo for sql_variant type
• Exception on load bad selection file
• Blurred icons
• Defined minimum size of property page in template editor
• Wrong caption and status information in main window on change db when lost server connection
• Object model putting in order as in documentation, but some collection object's methods/properties still not identical, it use Item propery instead Field, Table... in accordance with Fields, Tables... collections. Language, Include(s), Template objects are not supported
• Work with qoute in row key fields
• Undo transaction work for full row in update, now only for selected columns
• New template in manage architecture window
• Coloring vb script includes in comments in template editor
• Bad lines number shown in status bar when select different tabs in template editor
• Bad colors in property page in template
• Show menu and toolbars after load metadata from db in main window
• Not current date in filter in standart report dialog
• Show message login failed when change server in login dialog
• Bad default architecture file/path load exception
• Exception when press cancel button in open architecture file in options dialog
• Load/save functions in template editor and menu labels
• Work with new template in template editor
• Exception when connecting to db with error on server side
• Property page resize with window in template editor
• Not save grid size in main window
• Reversed icons in Manage Architecture window
• Not save selected options in tempate editor
• Not work CHG state in template editor
• Not show CAPS and NUM flags in disabled state in template editor
• No links in help menu
• Office 2003 theme not applied to grids
• Theme not applied to context menu in some windows
• Button alingment in Manage Architecture window
• Some memory leaks
• Work with timstamp in primary key

Changes:

• Includes changes in Architecture File version 20.25

Known issues:

• Undo not work with rows with changes in row key
• Can not undo transaction with long string data