Release:	2013.01.0063
Date:	April 22, 2013
Description:	Hot-fix release

Fixes:

• When installing, the application checks for .NET framework 2.0 instead of .NET framework 3.5
• Changes made using the "Template editor" to a custom audit architecture which has been set as the default, are not saved unless the custom architecture is explicitly loaded

Release:	2013.01.0061
Date:	April 11, 2013
Description:	Major feature, major fix release

Enhancements:

• The application now supports auditing SQL Azure databases
• Enabling or disabling triggers is now up to 50% faster
• Include (.inc) files can now be edited via the Template editor

Fixes:

• Updating the 2008 version of the application to the 2011 version and then reinstalling the 2011 version results in the application attempting to load the architecture file from the in the wrong location and showing the message "Arhitecture file: C:\Program Files (x86)\ApexSQL\ApexSQLAudit2011\ApexSQL2049.audx doesn't exists"
• Selecting one of the "Check insert trigger(s)", "Check delete trigger(s)" or "Check update trigger(s)" options in both the "All items" and "Checked items" submenus of the "Main" grid’s context menu doesn’t result in automatically selecting the appropriate check boxes in the "Main" grid
• Changes made using the "Template editor" to a custom audit architecture which has been set as the default, are not saved unless the custom architecture is explicitly loaded
• The application starts the auditing process even if a non-existing project has been specified via the CLI without properly notifying the user about the missing project
• Using the spacebar to select or deselect the checkboxes in the "Custom row key" panel doesn’t result in the intended selection
• Schema changes for non-audited tables are reported even if the "Report schema changes for non-audited tables" option is set to false
• 10.0 is displayed in the "Status" bar for SQL Server 2012 instead of 11.0
• An asterisk is displayed in the title bare as the name of a new, unnamed project
• The auditing SQL tables are locked while generating a standard report
• Unicode characters in audited data are shown as "?" in the generated reports
• Changes made to the position and size of the "Edit key for table" dialog are lost upon its closing
• An incorrect application version is displayed in the Add/Remove programs applet of the Windows Control Panel
• Renaming any SQL table results in the "Check for schema changes" feature reporting that a SQL table, named with the original name of the renamed SQL table, has been dropped, and that a new SQL table, named with the new name of the renamed SQL table, has been created
• The "Template editor" lacks a horizontal scroll bar
• The icon used for the "Training" button located in the "Resources" tab of the ribbon differs from the icon used for the same button in other ApexSQL applications
• Updating the application to the latest version results in failure to create the auditing SQL triggers due to missing columns in the auditing SQL tables
• The "System.ComponentModel.Win32Exception" error is encountered when attempting to open a report in PDF format if no third party application is associated with PDF files
• The "Modified date" column in the application’s standard report doesn’t display the time of the change
• Attempting to generate any of the auditing reports puts the application in an unresponsive state when auditing more than 200 SQL tables with more than 1000 row each
• Using the "Remove this column" option in any report doesn’t remove the column from the report
• The title of the "Delete data wizard dialog" is spelled incorrectly

Release:	2011.01.0059
Date:	October 24, 2012
Description:	Hot-fix release

Fixes:

• Schema changes are not reported automatically when opening a saved project
• 'Select All'/Deselect All' in Standard report's filter criteria 'Table name' results in selecting/deselecting only the visible part of the drop-down list
• ArgumentOutOfRangeException exception is encountered when using the '/purge' switch for purging data via the CLI
• 'Invalid switch definition' error message is encountered when using the '/older' switch for purging data via the CLI
• ArgumentOutOfRangeException exception is encountered when using the '/maxrows' switch for purging data via the CLI
• Changes made to row keys, watches and lookups aren't saved with the project
• 'Checked', 'Audited', 'Changed' and 'Prepared' main grid columns cannot be filtered due to the empty drop-down filter row

Release:	2011.01.0057
Date:	September 25, 2012
Description:	Hot-fix release

Enhancements:

• The application is now FIPS compliant

Fixes:

• Save changes dialog is displayed when closing the application if project changes were already saved manually
• Save command doesn't save changes for previously saved and reopened project

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 when 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 architecture 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
• Incorrect 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 avoid 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 program, change db
• Delete triggers owned by dbo user only
• Esc not close some windows or close more than one
• Columns width in grids to show full names
• Load prev architecture filename if new has bad format
• Work check/uncheck by space key in grids if other column active
• Multiple 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 property instead Field, Table... in accordance with Fields, Tables... collections. Language, Include(s), Template objects are not supported
• Work with quote 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 standard 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 alignment in Manage Architecture window
• Some memory leaks
• Work with timestamp 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