ApexSQL Edit release notes

Release:	2011.02.0184
Date:	January 11, 2013
Description:	Hot-fix release

Fixes:

The "System.Xml.XPath.XPathException" error is encountered when creating a SQL stored procedure using the "New Stored Procedure" command
An incorrect help topic link is invoked when pressing the F1 shortcut key while the "New Stored Procedure" dialog is active

Release:	2011.02.0183
Date:	October 17, 2012
Description:	Hot-fix release

Fixes:

Options | Table options | Table scripting options 'Include triggers', 'Include foreign keys', 'Include primary keys', 'Include unique constraints', 'Include check constraints', 'Include bound rules and defaults', 'Include default constraints' and 'Include statistics' values are lost after application restart

Release:	2011.02.0182
Date:	July 11, 2012
Description:	Hot-fix release

Enhancements:

Auto-complete hints list is now shown for more SQL constructs and contains more relevant hints:

Table variables' columns are now displayed in the hints list when triggered in a SELECT statement
Logins are now displayed in the hints list when triggered after DROP LOGIN or ALTER LOGIN statements
Users are now displayed in the hints list when triggered after ALTER USER statement
CLR variables' methods are now displayed in the hints list when triggered in a SELECT statement
SEARCH PROPERTY LIST keywords are now displayed in the hints list when triggered in a CREATE statement
Geometry, geography and hierarchyid data types' static methods are now displayed following the '::' trigger

Auto-complete hints list server metadata loading speed has been improved by up to 2700%
Auto-complete hints list appearing time has been improved by up to 30% when first used in a session

Fixes:

"Object reference not set to an instance of an object" error is encountered in Manage Auto-Replacements dialog after adding a new auto-replacement and saving it if the application auto-replacements were inherited from previous application version
"An error occurred while retrieving database <database< metadata from server <server>" error is encountered in Object Search when initiating an object search in a database that is not mapped to the current logged in user
About one half of the default Snippets are no longer available after updating application
Query editor status bar server\database text is cut if it is longer than 30 characters and status bar default encoding text is also longer than 30 characters
"Invalid column name '<column>'" error is encountered on hovering mouse pointer over a Certificate in Schema Explorer to display a tooltip
Auto-complete hints list doesn't show on space trigger in a WHILE statement followed by a SET statement concatenating a string
Auto-complete hints list doesn't put at the top of the list columns of a table-valued Function in a FROM clause of a nested SELECT statement
Schema Management, Connection Management, Alias Management and Source Control Default Mapping Options sections of Options dialog have a blue user interface theme different from other application dialogs
Procedure and Function profiling Summary tab '5 Slowest Statements' and 'Parameter and Variable Minimums and Maximums' grids context menu commands have no functionality
Profile Procedure dialog options checkboxes overlap when using 120 DPI system font resolution
Query editor context menu 'Outlining' commands have no functionality
Object DDL script tooltip isn't displayed after selecting the first hint in auto-complete hints list
Encrypted object DDL script is not displayed in auto-complete tooltip when working with SQL Server 2012 database
Editor Options | Auto-complete Options | Format Keywords formatting setting value isn't applied to TABLE keyword when selected from auto-complete hints list following DECLARE @variable statement
Auto-complete hints list is missing Table name suggestion as the first one in the list in a WHERE clause nested SELECT statement
Editor Options | Auto-complete Options | Format Keywords formatting setting value isn't applied to keywords when selected from auto-complete hints list following a SELECT statement but preceding a CREATE statement
Excess brackets are added to the script when using parenthesis key to select a Function in auto-complete hints list
Check Syntax refactor reports "The ORDER BY items must appear in the select list if the SQL statement contains a UNION, INTERSECT or EXCEPT operators" error for valid statements without UNION, INTERSECT and EXCEPT operators
Check Syntax refactor doesn't report an error for ORDER BY clause of SELECT statement when Geography or Geometry type columns are specified
Check Syntax refactor reports an error for DROP SEARCH PROPERTY LIST statement that specified Search Property List doesn't exist
Check Syntax refactor reports an error for column specified in a SELECT statement when Table Synonym is used as data source
Check Syntax refactor reports an error for CREATE PROCEDURE statement CURSOR VARYING OUTPUT parameter
Check Syntax refactor reports an invalid object name error for a valid SELECT statement joined with multiple previously defined Common Table Expressions
Check Syntax refactor reports a missing object error for conditional DROP <object type> <object name> statement
Check Syntax refactor reports a mismatching insert value count error for INSERT statement within a CREATE PROCEDURE statement
Check Syntax refactor reports an error for column named as '.' used within DDL statements
Check Syntax refactor reports an error for CURRENT_TIMESTAMP system function
Check Syntax refactor doesn't report an invalid column name error for SELECT TOP(<column>) statement
Qualify Object Names Refactor doesn't fully qualify Sequence in a SELECT NEXT VALUE FOR statement
Qualify Object Names Refactor fully qualifies temporary Table columns
Qualify Object Names Refactor fully qualifies a non-declared Table variable in a SELECT statement if the Table variable was declared in a previous execution block in the same script

Changes:

Smart Rename Column Refactor will now display an informative message instead of generating an empty script when renaming FileTable column

Known issues:

Debugging, Profiling and 'Lazy Profiling' of SQL Server 2012 Stored Procedures and Functions doesn't initialize and doesn't provide any results

Release:	2011.02.0181
Date:	May 18, 2012
Description:	Minor feature, major fix release

Enhancements:

Auto-complete hints list appearing time has been improved by up to 50%
Auto-complete now displays hints list following a GOTO statement containing all labels in the script
Auto-complete hints list now contains INFORMATION_SCHEMA suggestions when triggered after SELECT FROM statement and related contexts
Connecting to a database is now faster between 0% and several hundred percent depending on the amount of Jobs, Job Histories, Alerts, Backup Devices, Search Property Lists and Sequences on the server
Connecting to and working with SQL Server 2012 is now supported
Check Syntax refactor speed has been improved by 8%
Source control mapped object editing using Schema Explorer context menu Source Control | Edit command is now supported providing automated object synchronization to database and source control repository
Object Search | Include System Objects setting is now available to allow filtering of system objects in the Object Search results

Fixes:

Auto-complete hints list doesn't contain INDEX keyword when opened using space trigger after CREATE COLUMNSTORE statement
Auto-complete hints list doesn't contain COLUMNSTORE keyword when opened using space trigger after CREATE NONCLUSTERED statement
Qualify Object Name refactor doesn't fully qualify Table name after ON keyword in CREATE COLUMNSTORE INDEX statement
Qualify Object Name refactor doesn't fully qualify Table name after AS OBJECT clause in EXECUTE WITH RESULT SETS statement
Check Syntax refactor doesn't report inexistent object errors when incorrect object names are specified after AS OBJECT or AS TYPE clause in EXECUTE WITH RESULT SETS statement
Smart Rename Table refactor generated script doesn't modify Stored Procedure script containing the Table name after AS OBJECT clause in EXECUTE WITH RESULT SETS statement
Window | Tile Horizontally and Window | Tile Vertically commands do not resize child windows after rearranging them
Check Syntax refactor reports an error in SELECT DISTINCT statement for ORDER BY clause if columns are specified by their ordinal positions
Check Syntax refactor reports invalid object and column names in SELECT statement when INNER JOIN clause specifies Tables from a different database than the current one in context
Check Syntax refactor doesn't report an error when directly using an aggregate function in a WHERE clause of a SELECT statement
Check Syntax refactor doesn't report all preceding errors in a SELECT statement when a question mark character is inserted after the FROM clause
Options | General Options | Auto-complete Options | Show Join Candidates setting doesn't suppress displaying of JOIN ON clause auto-complete hints list when turned OFF
Auto-complete hints list doesn't contain COUNT system function when opened after a HAVING clause in a SELECT statement
Replace One-to-Many-Relationship refactor doesn't display warnings when specified Table's columns or indexes will be deleted by generated refactor script
Auto-complete hints list doesn't contain local variables when displayed within function brackets in a nested SELECT statement
'Data at the root level is invalid.' error message is encountered when saving newly created snippet through Manage Snippets dialog
Formatting Options | General | Add spaces inside/outside parenthesis settings don't add spaces to an empty system function call inside a SELECT statement
Formatting Options | Comments | Add border above/below block comments settings add block comments to previously commented blocks with the same border
Formatting Options | Schema Statements | Place parameters on new line | Align with keyword setting aligns parameters with Schema name instead of keyword
Auto-complete hints list doesn't appear automatically following space trigger in MERGE and USING statements
Auto-complete hints list doesn't contain 'date' data type when offering data type suggestions for columns in a CREATE TABLE statement
Check Syntax refactor doesn't report an error in ORDER BY clause of SELECT statement if the same column is specified both by its name and its ordinal position
Options | Display Options | Fonts and Colors settings are not applied to code in Query Editor
Application icon is inconsistently present in Save and Open file dialogs
'Item has already been added' error is encountered when hovering mouse pointer over any Query Editor code element that has previously already displayed tooltip several times
'The application's folder is read-only. Please, rerun the application from a writeable folder' error is displayed on application startup if the user has no write access rights for the installation folder
Edit Data discards edited Table row data after clicking Apply Changes if the data violates table integrity
Smart Rename Table Column Refactor resulting script alters Views that don't directly reference renamed column
Check Syntax refactor doesn't report errors for non-existent @@ variables
Check Syntax refactor reports an error for CREATE VIEW statement if it is preceded by a corresponding DROP VIEW statement
Check Syntax refactor reports errors for all statements following CREATE CERTIFICATE statement
Check Syntax refactor reports an error for a blank RETURN statement within a Procedure body
Auto-complete hints list with previously declared local variables is not displayed following the '@' sign trigger if it is preceded by SELECT statement which was copied into the script and not typed manually
Auto-complete inserts duplicate Table name with an auto-generated object alias following FROM in a SELECT statement after selecting a column from opened hints list if the Table name without an alias already exists in the statement
Auto-complete places cursor inside the parenthesis when inserting getdate() function which doesn't need any parameters
Check out link in Query Editor top bound information strip appearing after the Source Control object editing is finished doesn't work
Check Syntax refactor reports valid triggers and tables as non-existent if used as part of DISABLE TRIGGER statement
Check Syntax refactor doesn't report a WITH statement error when it is preceded by a non-terminated SET statement
Check Syntax refactor reports excess errors for INSERT INTO table variable statement when it sources data from an EXEC Procedure statement and the Procedure doesn't exist
Auto-complete hints list is not updated with database object hints after it was first opened to list '@@' variables and the '@@' are removed using backspace
Show Database/Source Control Script Differences dialog size and position is not saved after closing it
Query execution results Drill Down Query Other Tables/Views dialog is not resizable
Inline comments are formatted and put on a new line even when the Formatting Options | Comments | Format Comments setting is OFF
Schema Explorer server tabs show SQL Server IP address instead of the server instance name when connected to the server using IP address
Schema Explorer | Script Objects items selection dialog doesn't open help contents after pressing F1 or '?' button
Schema Explorer context menu commands are disabled for Table Triggers if the Table contains at least one Trigger
'Format of initialization string doesn't conform to specification...' error message is encountered when trying to connect to a SQL Server if the connection user credentials were previously saved and the password contains a semicolon character
'ObjectDisposedException' error is encountered after using any auto-complete functionality following a cancelled Query Editor closing attempt
All square brackets are removed from the output script if Square Brackets in Script option is OFF
Template parameters dialog is not opened on double-click on SQL Server 2000 templates in Template Explorer
Options | Connection Management interface controls are overlapping when using 120 DPI system font resolution
Object Search controls are overlapping when using 120 DPI system font resolution
Quick Info management Cancel button disappears after resizing the dialog
Replacements dialog displayed after using Schema Explorer | Assign Auto Replacement command has overlapping input controls when using 120 DPI system font resolution
Edit Data keyboard shortcut top right description is not visible when using 120 DPI system font resolution
Object Explorer DDL tab shows 'Loading DDL...' message indefinitely when Object Explorer describes a Function Parameter
Object Search | Navigate to Schema Tree Node context menu command doesn't work for found Message Type objects
Object Search context menu doesn't exist for found User objects
Symmetric Key objects don't have an object icon in Custom Menu management dialog
'Object reference not set to an instance of an object' error message is encountered when using any of the Source Control related commands from a customized toolbar
'The object <name> is no longer available in the database' error message is encountered after cancelling application close attempt and opening Schema Explorer context menu for an object
Opening Print Preview dialog from What Is dialog Permissions tab using context menu automatically closes both dialogs
Schema Explorer | Manage Filters dialog Specific to Database and Specific to Server checkboxes do not have any effect on the filter and aren't saved
Custom Menu management dialog object names are displayed all in uppercase and multiple words concatenated
Visual Query Builder opens wrong Help file topic after pressing F1
Visual Dependencies context menu item doesn't have an icon for all object types under Programmability folder node
Recreated objects using DROP/CREATE will still script the old DDL script anywhere in the application
'Object reference not set to an instance of an object' error message is encountered after using any Schema Explorer object level context menu command and answering Yes to the 'Object has been modified' question if the object has been removed from the database
'Object has been modified' message is shown twice for recreated objects after opening Schema Explorer object level context menu if connected Query Window is open for the same database
Object Search | Add to Favorites can add system objects to Schema Explorer Favorites
CTRL + SHIFT + keyboard shortcuts for scripting objects from Schema Explorer are working selectively for several object types only
'Object reference not set to an instance of an object' error is encountered after scripting a Role for CREATE from Schema Explorer
Show User Databases Only setting doesn't hide system databases from Schema Explorer when enabled
Application Roles aren't shown under Schema Explorer Roles folder
'Object reference not set to an instance of an object' error is encountered after attempting to script a Trigger or a Contract using Object Search results grid context menu
System Tables are not displayed in auto-complete hints list following a SELECT statement when Show System Tables auto-complete option is enabled
Auto-complete hints list opened after FROM clause of INSERT INTO statement contains destination INSERT Table name
Auto-complete hints list contains JOIN completion hints instead of system Function parameters when opened inside system Function brackets following INNER JOIN in a SELECT statement
Auto-complete hints list doesn't contain Table or Table alias hints when opened following a SELECT statement if the statement is located inside IF clause
Auto-complete hints list contains only keywords when opened inside brackets following IF NOT of a nested IF statement
Auto-complete hints list contains only keywords when opened following second THEN clause of a CASE WHEN construct inside SELECT statement
'Object reference not set to an instance of an object' error message is encountered when using Smart Rename refactor from context menu on an object node located under Favorites Schema Explorer folder
Error List remains empty even though there are syntax errors highlighted in the script after activating Check Syntax refactor from Query Window context menu for the first Query Window opened after application startup
Check Syntax refactor reports Table and Table Columns as errors inside a CREATE TABLE statement for a Table that doesn't exist in the database
Check Syntax refactor reports errors for valid statements and object names after script changes database context following USE statement
Opening previously saved Projects after changing File Encoding setting will fail with an encoding related file corruption message displayed
'Could not connect to ...' error is encountered after opening Object Search results grid context menu if the database in context is connected to Subversion Source Control using Native drivers without previously saving repository access credentials and the Source Control Logon dialog is canceled
Query Window status bar SPID text is not visible when using 120 DPI system font resolution
Incorrect current user credentials are used and displayed in Query Editor status bar after reconnecting to the same server using different credentials
Copy Cell to Clipboard Query Window Results grid context menu command copies only partial value of varbinary(max) column results
Query Other Tables/Views dialog is not resizable
Schema Explorer View object context menu View Data command opens a window with 'Table' in the window tab caption
Non existing databases appear as loaded in Options | Schema Management tab after being used in a script in a USE statement
User Defined Type is not scripted for CREATE in a new Query Window after using F2 keyboard shortcut to script the UDT under cursor of the currently open script
'Object reference not set to an instance of an object' error is encountered if Query Window is closed while Check Syntax refactor is still processing the script in background
Error List panel is emptied after only one of the reported errors is corrected
SELECT statement related error remains in the Error List panel even after the whole statement is removed from the script
varbinary typed column content is not shown in the Data tab grid in Object Explorer or What Is dialog
'There was an error while trying to create DDL script' error message is displayed in Object Explorer DDL tab when 'dbo' user is selected in Schema Explorer
Object Search results don't show objects containing sought text in databases with case sensitive collation even if the Exact Match checkbox wasn't checked
Edit Table dialog is not opened if a user with insufficient access privileges attempts to edit Table structure using Schema Explorer Edit Table object level context menu command
Edit Data window shows '-1' in the Rows text field after clicking Load All Rows button

Changes:

Debug, Profile and "Lazy Profile" dialogs have been updated for improved usability
Options | Display Options | Fonts and Colors | Variable Style Fore Color setting has been reinstated
Visual Dependencies graph no longer shows referenced objects from other databases on the connected server as it slowed down the application drastically depending on the size and the count of databases on the server
Application extensibility sample project 'EditSamples' located under add-ins installation subfolder has been updated to target .NET Framework 3.5
Refactor dialogs and Source Control Wizard dialog no longer have application icon in the top left corner
Only non-default values in Options dialog property grids are now bolded
Source control operations related dialogs have been updated for improved usability
Object Search | Script <object> to New Window context menu command now scripts the selected object's parent object if it was used on a non-scriptable sub-object

Known issues:

Debugging, Profiling and 'Lazy Profiling' of SQL Server 2012 Stored Procedures and Functions doesn't initialize and doesn't provide any results

Release:	2011.01.0179
Date:	December 21, 2011
Description:	Major feature, major fix release

Enhancements:

Insert Keys auto-complete option is now available for configuring which keys will trigger auto-complete hints list insertion
Auto-complete, formerly known as IntelliPrompt, has been overhauled to improve auto-completion lists visually, for usability and to assist with multiple additional SQL code constructs
Format SQL Code functionality and Formatting Options have been improved to double the number of formatting configuration settings groups and more than double the number of configurable individual formatting settings
Replace One-to-Many Relationship with Associative Table Refactor is now available for Tables through the Schema Explorer context menu 'Refactors'
Add Surrogate Key Refactor is now available for Tables through the Schema Explorer context menu 'Refactors'
Change Parameters Refactor is now available for Stored Procedures and Functions through the Schema Explorer context menu 'Refactors'
Find Unused Variables and Parameters Refactor is now available from the Query Editor context menu 'Refactors'
Encapsulate As Refactor now supports View as the target object type
All Schema Explorer object type folders now have a standard context menu to support filtering, multiple object scripting and addition to Favorites folder
General Options 'Format date/time values according to regional settings' setting has been introduced to allow all grids date/time column formatting according to localized regional settings
Hint Order auto-complete option is now available allowing for customizing the order of the database objects and script based suggestions
Auto-generate Aliases auto-complete option is now available to control automatic object alias insertion
All SQL Server 2005 and SQL Server 2008 object types are now accessible and categorized in Schema Explorer and Object Explorer and all can be integrated with Source Control
Connecting to and working with SQL Server Code Name 'Denali' CTP3 is now supported
Error List panel is now available on the main application window allowing for dynamic Check Syntax errors to be displayed and interacted with
Object Explorer panel and What Is dialog now have a new Columns tab showing the list of all Table and View columns in the database
Query parsing time is improved by up to 500% for large scripts containing multiple GO statements
SQL Server metadata loading is reduced by 50% when connecting to a database for the first time or when refreshing a database using Schema Explorer Refresh context menu command
Editor Options 'Display Object Script' and 'Display Object Script After' settings have been introduced to control displaying of auto-complete hints list object DDL
Save changes dialog has been redesigned for improved usability

Fixes:

Tabulating script multiple times invokes auto-complete hints list and inserts the first selected hint list suggestion
Encrypted Schema Explorer object nodes aren't colored differently than non-encrypted objects
Object scripts are missing comment containing date and time of script creation even if 'Include Headers' scripting option is enabled
Auto-complete hints list is not showing previously defined local variables when triggered after a RETURN statement
"Object is no longer available in the database" error message is encountered upon opening Schema Explorer context menu on a Table or a View object under Favorites
Object Explorer and What Is don't display Columns tab for User-Defined Table Data Type objects
Object Explorer Columns tab filter row cannot be modified when displaying all columns in a database
Object Explorer content is not updated when docked after selecting a different object in Schema Explorer
Resultset cannot be displayed in XML View using corresponding context menu command if it contains at least one XML column
'Square brackets in scripts' option is ignored when an object is scripted using drag and drop from Schema Explorer
View Triggers are not scripted even if 'Include Triggers' scripting option is enabled
Auto-complete hints lists are no longer displayed after using Clear Metadata from Cache Schema Explorer Database context menu command
SQL Server 2000 database User Defined Functions cannot be scripted for SELECT
Database Text Search doesn't initiate the search when connected to SQL Server using SQL Server Authentication with a user containing ';' character in the password
"Object reference not set to an instance of an object" error is encountered on application startup after transferring user Queries file 'Queries.xml' from previous application major version
"Safe handle has been closed" error is encountered before auto-complete hints list appears if there was previously a cancelled attempt to close the application
Query Editor tooltips for Functions aren't shown if the function is located inside another function's parameter list
"System.UnauthorizedAccessException" error is encountered on application startup if the default path to snippets or templates folders was changed to a non-existing path
Script Select Statement Snippet cannot be inserted
Filter text disappears from Edit Data filter row after the filter is applied
Default Schema Action options are not working and cannot be saved
Auto-complete doesn't track changes in variables definition in the script and displays obsolete parameters definition in the hints list
Auto-complete doesn't enclose column names into brackets in a WHERE clause if column names contain non-Latin characters
Edit Data cannot update TEXT and NTEXT fields for existing rows
Auto-complete hints cannot be selected in the list with a mouse double-click
Function name is encapsulated in brackets if it's selected from the auto-complete hints list using '(' key
Auto-complete inserts auto-generated alias prior to function's open bracket if a table valued function is selected from the hints list following a FROM clause of SELECT statement
Source Control Explorer displays files and folders in reverse alphabetical order
Using TAB key to navigate snippet fields inserted by auto-complete for the EXECUTE procedure or function statement shows unneeded new hints lists
Two application folders for storing user data are created in the My Documents system folder following application installation and the first startup
Newly declared variables are not shown in the auto-complete hints list
Results grid always uses regular expression filtering and ignores Use Regex Filtering setting value
Application interprets Edit Data column's filter value as text instead of numbers for numerical data resulting in incorrect column filtering
Auto-complete list isn't shown automatically following a FROM clause in UPDATE ... SET statement
Object Search results grid column filters remain present but hidden after closing and reopening the Object Search
Query is executed on the previously selected database even after changing the database using toolbar database dropdown but without changing the dropdown focus
Edit Data grid isn't refreshed if a row wasn't successfully deleted
"The query cannot be executed..." error message is encountered when attempting to execute Source Control mapped but not checked out stored procedure or only a selected part of the procedure
Results Messages panel doesn't show an error after executing a SELECT statement containing invalid object name in the FROM clause
"System.ObjectDisposedException" error is encountered when closing Database Text Search if the search process is still in progress
"Column 'OrganizationNode' has null values in it" error message is encountered when updating data via Edit Data if NULL value is entered for HIERARCHYID column
"Incorrect syntax near the keyword..." error message is encountered when attempting to Edit Data of a table with name equal to a SQL keyword
Columns in the results grid are named '1', '12', '123' progressively when unnamed columns are used in the SELECT statement
"System.OutOfMemory" error is encountered when using Advanced Cell Copy as HTML for a large result set
Results grid doesn't display HTML code stored in NVARCHAR(max) columns
After an unsuccessful shutdown application offers to load the last workspace backup on startup with Backup Enabled option set to False
Changes in Query Editor aren't saved in the current project if the same Query Editor window was also used in the previously opened project
Application experiences a few seconds slowdown when opening an XML file using File | Open command in a SQL language preset Query Editor window
Find and Replace doesn't locate all sought text instances in complex SQL scripts when Find Whole Word option is enabled
Server and database toolbar dropdown lists remain disabled after Schema Explorer database node was dragged and dropped onto a disconnected Query Editor to establish a database connection
SQL Server Books Online isn't opened with Shift+F1 if it was already opened before
Application generates template based database creation script with syntax errors if non-Latin characters were used when specifying template parameter values
Query Editor tab caption isn't updated after executing any code in case the Query Editor window was initially created after scripting a table for SELECT
Only one result tab is created when executing a DDL script against multiple data sources
Database Text Search cannot find sought text if it contains square brackets
Default constraints are not shown in Schema Explorer under Table | Constraints node
'Restrict access to restored database' restore database option doesn't put database in RESTRICTED_USER access state
Edit Data grid Load All Rows doesn't prompt to save uncommitted changes
Custom colors can be selected but cannot be applied in the Fonts and Colors Options dialog
Backup or Restore database folder browser navigation tree is not sorted and contains system folders
Edit Data grid displays UNIQUEIDENTIFIER column value in different letters casing when editing the value
"System.IO.IOException" error is encountered when multiple instances of the application are run at approximately the same time
Auto-complete displays schemas instead of columns following a '.' if the preceding table alias is named the same as the database
Aggregate functions cannot be scripted for ALTER
Check-In and Check-Out comments are truncated to 63 characters when the database is connected to Visual SourceSafe 2005 using Native Visual SourceSafe driver
Newly recorded macro cannot be used without first showing the Macro dialog and saving it
"System.OutOfMemoryException" error is encountered when executing stored procedure which inserts 1,000,000 or more records in a table if Include Actual Execution Plan is enabled
Application always starts fully maximized before connecting to a server
"Cannot remove specified item" error message is encountered when trying to delete a Project folder containing non-Latin characters
Auto-complete hints list doesn't display columns for SELECT sub-statement used inside a WHERE clause of an UPDATE statement
Auto-complete doesn't display hints list following a TOP keyword
Auto-complete doesn't display hints list for SELECT statement in sub-queries following an '=', IN/NOT IN and EXISTS/NOT EXISTS operators
Auto-complete hints list isn't displayed following a space between SELECT and FROM if a table name is already specified
Auto-complete hints list isn't displayed following a dot for a table alias if the alias has the same name as a reserved SQL keyword
Auto-complete hints list is displayed for a SELECT FROM statement with already specified fully qualified table name and a following dot
"Specified cast is not valid" error is encountered when attempting to Edit Data for a table with non-Latin characters in its name
Auto-complete hints list isn't displayed after SELECT following a space in a nested SELECT statement
Auto-complete hints list doesn't display all columns in a nested SELECT statement part of a UNION clause
Table Designer doesn't recreate foreign key when changing table column order by only one position
Selecting a table from auto-complete hints list deletes preceding manually typed schema in a SELECT statement of a CREATE VIEW statement
Auto-complete hints list suggests parameters for function execution alongside variables specified in a DECLARE statement
"The statement you are executing contains DML statements" warning message is encountered when trying to execute only a selected part of the script without any DML statements if DML statements exist in the non-selected part of the script
Objects mapped to Source Control using Native Subversion driver are not refreshed automatically in background on the predefined interval in Schema Explorer
Application freezes when mouse pointer is hovered over a parameter highlighted by Find Unused Parameters and Variables Refactor
Schema folder filters are removed after reconnecting to the same database
Results panel query execution error hyperlinks don't navigate to corresponding lines in the Query Editor script if the script contains comments combined with multiple GO statements
Schema folder filters are not automatically refreshed after updating a filter from Manage Filters dialog
Tooltips aren't displayed when mouse pointer is hovered over query comment based tasks
Find/Replace dialog loses focus after locating the sought text using Find Next
"SQL Server service has been paused. No new connections will be allowed..." error is encountered when executing a query saved in a project if SQL Server instance associated with the query connection is unavailable
"UdtTypeName property must be set for UDT parameters" error message is encountered when trying to update data of a table containing GEOMETRY, GEOGRAPHY, or HIERARCHYID columns with Table Edit Data
"Set LocalPath property to check out..." error message is encountered after using Source Control Check-Out command on database or folder level when the database is connected to Subversion repository using Native Source Control driver without saving the user password during database mapping process
"Object reference not set to an instance of an object" error is encountered when trying to restore the last automatically backed up Workspace in case the Workspace backup is corrupted
Foreground and background color of a tooltip for collapsed code regions cannot be changed
Auto-complete hints list overlaps with tooltip for system built-in functions
"Data is Null. This method or property cannot be called on Null values." error is encountered when clicking on an XML link in the returned result set for a table with multiple XML columns
"An error occurred while trying to copy cell values. Object reference not set to an instance of an object." error message is encountered when copying cell using Advanced Cell Copy command if the command was invoked from a context menu opened over the grid's column header row
"There were some errors that prevented copying data" error message is encountered when using Advanced Cell Copy feature if no columns are selected
Pre_exec and post_exec regions are treated as regular code regions during partial query execution
Auto-complete hints list doesn't appear in a SELECT statement on a trigger key following temporary table name which was previously created in the script using the SELECT ... INTO #table statement
Auto-complete hints list doesn't appear for temporary tables created manually in tempdb database using CREATE statement
Scripting objects to Source Control using Source Control Wizard generates different object scripts than scripting objects using Add Object to Source Control command
Binary data is not displayed and is not editable when using Table Edit Data
Data Type list is empty in Parameter Entry dialog when executing a query using Execute with @Parameters Query Window option enabled
Application modal dialogs are displayed outside of visible desktop area if they were previously closed on a secondary and currently not connected monitor
CLR functions cannot be scripted for ALTER
Custom Menu generated queries don't enclose object names with square brackets
Inline comments are formatted even when the Comments | Format Comments option is not enabled in Formatting Options
Auto-complete hints list columns width is not remembered between application restarts
Auto-complete hints list doesn't appear following a DECLARE @variable statement
Format SQL progress information is displayed on the main monitor screen when the application main window is located on a secondary monitor
"Object reference not set to an instance of an object" error is encountered when attempting to add an extended property using Table Designer
UNIQUEIDENTIFIER and DATETIME columns cannot be filtered in Results grid
Auto-complete deletes text typed after an automatically inserted alias if space and comma are typed afterwards
"Specified cast is not valid" error is encountered when attempting to Edit Table on a SQL Server 2000 database if the table owner has the same name as a database role
"The data types xml and varchar(max) are incompatible in the equal to operator" error is encountered when attempting to display XML column value from Database Text Search results

Changes:

SQL Server object icons have been replaced with improved versions throughout the application
Source Control context menu command group has been removed from Query Editor context menu as duplicate to Schema Explorer and Source Control Explorer context menu commands
Record Macro keyboard shortcut is now changed from Ctrl+Shift+Y to Ctrl+Shift+M
Main menu Help | ApexSQL Online SQL Server Newsgroup links are now replaced with SQL Server Forum links
Find Unused Variables and Parameters Refactor will now stop highlighting all previously marked unused variables and parameters when any of the highlighted text is modified
Remove Parameters Refactor has been removed as it was made obsolete by the new Change Parameters Refactor
Interface themes have been replaced with a singular new theme
Application dialogs now have question mark button next to the close button on the dialog title bar instead of a standard Help button
All Settings dialog has been removed with all application settings made accessible through the Options dialog, categorized and with detailed descriptions
INSERT INTO column and value matching keyboard shortcut is now changed from [Shift]+Ctrl+I to [Shift]+Ctrl+[ to avoid old shortcut conflict with index search
Project Explorer SQL files are now always opened within the application instead of being opened by an application associated with *.sql extension in the system
Help main menu now has a single application help command unifying the old Help Contents and Help Index commands
Columns and Indexes folder nodes are no longer available in Schema Explorer under database nodes
Schema Explorer folder Filters have been redesigned for improved usability
The following Source Control settings and commands have been deprecated as obsolete: Apply changes to database after Check-In
Check-Out object on Edit
Check-In and Apply
Check-Out and Apply
Version to use on Edit and View Source Control setting default value has been changed to Prompt instead of Use database version
Source Control Explorer commands are now grouped under 'Source Control Explorer' group in Source Control General Options
DDL Triggers have been moved from Schema Explorer Triggers folder node into a separate DDL Triggers folder node under Programmability group
Show Temporary Table auto-complete option is now enabled by default

Known issues:

Debugging, Lazy-Debugging and Profiling of SQL Server Code Name 'Denali' CTP Stored Procedures and Functions doesn't initialize and doesn't provide any results
Check Syntax Refactor reports "Invalid object name errors in the script even when the objects exist in the database previously activated with a USE statement

Release:	2008.12.0174
Date:	February 21, 2011
Description:	Medium feature, major fix release

Enhancements:

Formatting Options Preview panel now supports previewing code formatting changes on both built-in examples and current query with changes highlighting
Extensibility API (ApexSql.Edit.Interfaces.dll) help documentation file is now available in the application installation folder
Opening script files larger than 2.5 MB will now present a dialog with a possibility to disable Syntax Editor coloring and IntelliPrompt to allow for faster script editing
Recompile Objects and Script Objects progress will now be represented by a cancellable progress indicator
Edit Table Data invalid cell value text color can now be customized using Fonts and Colors | Results | Invalid Values Color setting
Automatic creating of procedure parameter snippets in IntelliPrompt can now be disabled using the Editor Options | IntelliPrompt Options | Insert Procedure Parameters Automatically setting
Options dialog now contains a new Search | All Options section allowing for detailed grid based filtering and editing of all application options effectively making the All Settings (Ctrl+Shift+S) dialog obsolete
Script files can now be dragged and dropped directly onto the main application window even if there are no windows already open
Restore Database is now available from Schema Explorer database level context menu
Source Control Explorer can now be configured to automatically connect to previously used Source Control system on startup using Source Control General Options | Connect Source Control Explorer on Application Startup setting
Number of network connections used to script database objects to Source Control repository from Source Control Wizard using Native Subversion driver is reduced on average by 90%
Query Parameters can now be removed directly from Query Parameter Entry dialog by delete button next to the parameter value entry field
Script As | CREATE To and DROP To is now available for User Defined Data Types in Schema Explorer

Fixes:

Connecting to a SQL Server using Connect to Server toolbar command after the application is started without SQL Server connection will not associate the connection with the newly opened Query Window
Options and Layouts configuration files become corrupted on closing the application if the Source Control status of a mapped database is being updated in the background
Checking-Out a Visual Source Safe 6.0 mapped object from Schema Explorer can result in a "System.UI.FileLoadException" error message if the corresponding file isn't present in the working folder
"Object reference not set to an instance of an object" error is encountered when F5 is pressed on the keyboard if the active Query Editor doesn't have a connection associated
"Object reference not set to an instance to an object" error is encountered when trying to open Query Editor context menu if it has no connections associated
Warning message when pasting a large script into a Query Editor is incorrect
Last displayed explorer tab is active on application startup instead of the Schema Explorer tab
Warning dialog displayed during script execution after the first 25,000 result rows are loaded can be visually deformed by resizing
No results will be displayed after successful script execution if the executed SELECT script has multiple INNER JOINS statements
Deleting a User Defined Data Type using Schema Explorer Delete context menu command will delete the object but will not remove the object from the Schema Explorer until manually refreshed
"Object reference not set to an instance of an object" error is encountered when using New Query Window command after loading a Workspace with saved connections into the application started without SQL Server connections
Starting the application following a forced shutdown and having a corrupted or deleted Options.xml file will result in application not showing the prompt to restore the last automatically backed up Workspace even if the Workspace has been correctly saved
Manually opening a Workspace file immediately overwrites the automated backup Workspace with the newly opened file
Custom Snippet Replacement dialog doesn't open the correct help page after pressing F1 or clicking on the Help button
Table User Defined Types aren't shown in Schema Explorer under User Defined Types schema folder
Objects from a database different than the currently connected one are shown in IntelliPrompt auto-completion list for OUTPUT INTO clause
"Filed in dataset has the name ''" error is encountered when deploying a Reporting Services report from query results containing a column named only with "#" sign
Negative numbers are accepted as valid values for column Width while creating a new Reporting Services report
Application can remain active indefinitely in the background if the background Source Control object status refresh was active at the time the main window was closed and the connected Source Control system was unavailable
Closing the application after an out-of-memory or a system critical error can result in corrupted Layouts.xml file and no visible menu or toolbar commands after restart
"System.UnauthorizedAccessException" error is encountered when opening Manage Snippets dialog by a user without administrative privileges
After an OPEN keyword and typed '@' sign IntelliPrompt displays auto-completion list containing all declared variables and not only CURSOR variables
IntelliPrompt auto-completion list is shown after entering two dots following an INSERT INTO <schema name>.<table name> statement in case the schema and the table have the same name
Opening a New Query Window connected to a database different that the currently open Query Window changes the connection of the existing Query Window to match the newly opened one
"Could not connect to server..." error is encountered when refreshing Schema Explorer Source Control mapped objects status connected using Native Team Foundation Server 2010 driver over an unstable connection
Ctrl+C, Ctrl+V and Ctrl+X keyboard shortcuts for Copy, Paste and Cut will stop working in Query Editor after switching back to it from a non-Query Editor window such as Object Search
"Object reference not set to an instance of an object" error is encountered when closing application while background Source Control object status is being retrieved from the connected Source Control system
"A severe error occurred on the current command" which "Occurred on Line: 0" message is shown in the Results panel after cancelling loading of the SELECT query results on the 25,000 row load question
"System.Data.NoNullAllowedException" error is encountered when changing conditional breakpoint condition on the Conditional Breakpoints dialog during stored procedure or function debugging
Application cannot connect to a remote Reporting Services Server if the default user credentials are insufficient and additional authentication is required
Deploying new Reporting Services reports using 'Create SQL Reporting Service Report' Query Window context menu command into Reporting Services Server root folder is not possible
"Specified argument was out of the range of valid values. Parameter name: index" error is encountered when attempting to Check-Out an object from Source Control Explorer if the application was started without connecting to a SQL Server
Schema Explorer Source Control objects status background refreshing stops working if two databases are mapped to two different Source Control systems and one of the systems is unavailable on application startup
Object Explorer tabs will not show any Schema Explorer object or folder information after loading a Workspace containing SQL Server connections if the application was started without connecting to a SQL Server
"System.Data.ConstraintException" error is encountered when changing conditional breakpoint condition to match the condition of another already defined conditional breakpoint on the Conditional Breakpoints dialog during stored procedure or function debugging
Deploying a new Reporting Services report using 'Create SQL Reporting Service Report' Query Window context menu command will not succeed and no overwrite prompt will be shown if there is already report with the same name
Multiple "High: Error Incorrect syntax near 'NULL' from location [position ...] to [position ...]" warnings are generated while trying to encapsulate an ALTER TABLE statement as a stored procedure
Checking In a file from Source Control Explorer connected using Native Visual SourceSafe 6.0 driver fails and no warning messages are shown if the entire parent Source Control project of the selected file was previously renamed
Source Control project which was just created from Source Control Explorer connected using Native Visual SourceSafe 6.0 driver cannot be deleted
Creating and saving a new Project in the default application folder location will fail if the previously loaded Project was deleted or renamed just before creating the new project
"Object reference not set to an instance of an object" error is encountered when expanding Views node in Schema Explorer for SQL Server 2000 databases containing views with non-Latin characters in their name
"A General Network Error occurred..." error is encountered when trying to open a table object context menu in Schema Explorer if the table name contains characters from a non-Latin
"An error occurred while retrieving the table data..." error is encountered when trying to Edit Data from Schema Explorer if the selected table contains non-Latin characters in its name
Generate XSD invoked from Schema Explorer table context menu will fail if the table contains non-Latin characters in its name
"Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.SQLCC.v10' is invalid" message is displayed when opening Transact-SQL Help from the Help menu or using the Shift+F1 keyboard shortcut if the currently connected SQL Server is version 2008 R2 64 bit and Books Online were correctly installed
Ctrl+Shift+E keyboard shortcut doesn't insert a zero length string in Edit Data grid if the cell was previously focused by using the TAB key
Remove Parameter refactor generates a script even with no parameters selected for removal
Create Project command doesn't work in Source Control Explorer connected using MSSCCI Visual SourceSafe 2005 if the project is being created in the root of the system
Edit Data cannot apply changes to tables containing calculated columns
Two new unneeded files are created in the Project file folder after loading of the Project file fails
IntelliPrompt auto-completion list containing tables from default schema is shown after entering two dots following an INSERT INTO <schema name> statement
Just created User Defined Functions are not shown in the IntelliPrompt auto-completion list even after refreshing Schema Explorer list of objects
Grid filter values disappear from the filter row after applying changes in Edit Data grid
"Incorrect syntax near the keyword 'Table'" error is encountered after discarding changes made in Edit Data following a Refresh
IntelliPrompt auto-completion list doesn't contain table columns from the main SELECT statement if the list is triggered in the SELECT sub-query following a WHERE clause
Checking Out multiple Source Control mapped database objects from Schema Explorer folder or database level context menu fails if the supplied Check Out comment is longer than 63 characters when using Native Visual SourceSafe 6.0 driver
IntelliPrompt auto-completion list contains all tables, procedures and functions when triggered following an ALTER TABLE statement
IntelliPrompt auto-completion list triggered following a SELECT #<table_name>. statement contains columns of a real table if the database contains a table named identically as the specified temporary table <table_name>
Double-clicking a Trigger object found in Object Search will not navigate to that object in the Schema Explorer
"An error occurred while trying to get report definition. The request failed with HTTP status 401: Access denied" error is encountered when attempting to Get Report Definition from Reporting Services explorer if the report was created with different credentials than the ones currently used to access the Reporting Services Server
Remove Parameter refactor Generate button remains enabled after toggling a parameter checkbox state to select and deselect it for removal
Filtering grid using filter row on multiple objects Check Out, Check In or Undo Check Out dialog changes objects' selection state even though the checkbox state next to the object name remains unchanged
"Object reference not set to an instance of an object" error is encountered when opening Schema Explorer object level context menu for objects mapped using Native Team Foundation Server 2010 driver after the Team Foundation Server becomes unavailable for some time
Schema Explorer tooltip for a database with a long name overlaps with the database image and its description in the tooltip
Delete Project doesn't work for Source Control Explorer connected using Native Team Foundation Server driver
Schema Explorer database level Source Control report Database vs. Source Control Differences will be created progressively slower after each consecutive execution
Schema Explorer Script As | EXECUTE To doesn't work for CLR procedures
Schema Explorer Script As | DROP To results in a CREATE script for aggregate functions
Unsuccessful multiple Check Out, Check In or Undo Check Out operations will display individual error messages for each failed operation instead of showing all failed operations as a summary at the end of the batch processing
Executing an infinite SELECT query loop will cause the application to crash when the available memory is exhausted
Workspaces are not backed up automatically for all application instances if two or more are started at the same time
Opening Schema Explorer object level Source Control context menu will not display the object as un-mapped from Source Control if the corresponding Source Control file parent project was deleted or renamed
Edit Data Refresh will not update the grid if any of the columns have been modified externally
Debugging of stored procedures containing uniqueidentifier parameters cannot be started
Schema Explorer shows no tooltips when hovering mouse pointer over constraints and indexes
General Options | Use Single Application Instance option is ignored and application always creates a new instance on startup after installing more than one application versions in parallel on the same system
IntelliPrompt displays auto-completion list triggered by a dot following INSERT INTO <schema_name>.<table_name> statement when schema and the table have the same name
DateTime column values may be outputted to the results grid without time part
IntelliPrompt auto-completion list is not displayed when triggered by a dot following <table_name> inside IsNull function
Computed Column property is not visible in Table Designer property grid immediately after adding a new column
Script As | ALTER To scripting command for stored procedures will create excessive empty lines of code in the generated ALTER script
Conditional Breakpoints dialog available while debugging doesn't open the correct help page after pressing F1 or clicking on the Help button
Hovering mouse cursor over @@IDENTITY in a script while debugging a stored procedure on a remote SQL Server will permanently freeze the application
Object's DDL is not displayed in Object Explorer DDL tab when a table object with non-default schema is selected in Schema Explorer under Columns folder parent Tables list
Project Explorer database folder objects' context menu is missing command icons that are otherwise present for corresponding objects in Schema Explorer
Attempting to delete a locked file from Source Control Explorer connected using Native Team Foundation Server 2010 driver fails without any informative message
Undo and Redo toolbar commands are not disabled when no more Undo/Redo actions remain available in the history queue
Edit Data discards a whole newly entered row with all of its data if a single null constraint violation exists in the row when applying changes
IntelliPrompt auto-completion list doesn't contain all aliased table columns when triggered after SELECT <table_alias>. statement in a SELECT query where tables were aliased in INNER JOIN or OUTER JOIN parts of the query
Backup Database dialog cannot browse folders on the remote SQL Server in order to select backup file location
IntelliPrompt auto-completion list will not trigger on dot following an aliased table name if the alias has the same name as an existing view in the database
IntelliPrompt auto-completion list doesn't wrap table alias with square brackets if the alias is named identically as a SQL Server data type
Find/Replace in Query Editor will incorrectly locate parts of the script by ignoring Match case and Match whole word options if both are enabled
Region Pre_Exec isn't executed if there are multiple comments in the script preceding it or comments inside the region itself
Project Explorer is missing an indicator in case the Project was modified since the last save
Successfully saving the default Project shows no information about the Project file location
Debugging of a stored procedure cannot be initiated without specifying a value for output parameters
Object Explorer DDL tab remains empty with no informative message after selecting a stored procedure in Schema Explorer if the connected SQL Server is unavailable
"Object is no longer available in the database" message is displayed when opening Schema Explorer object level context menu if the connected SQL Server is unavailable
"Access to the path is denied" error is encountered on application startup if the default Project output folder doesn't have sufficient read-write privileges
"Object reference not set to an instance of an object" error is encountered after clicking Manage Permissions Schema Explorer database level context menu command if the SQL Server is unavailable
Script Objects and Recompile Objects Schema Explorer folder level context menu batch processing commands don't retrieve the latest encrypted state of the objects before showing the question for decrypting selected objects
Schema Explorer Source Control object status background refreshing doesn't resume after the correct Source Control credentials have been entered during a user invoked foreground Schema Explorer Source Control operation
"Object reference not set to an instance of an object" error is encountered on Show Execution Plan command if the current Query Window has no associated SQL Server connections
Object Search doesn't find objects if their schema name matches or contains the sought text
IntelliPrompt auto-completion list is not displayed following the SELECT .. WHERE NOT statement
IntelliPrompt auto-completion list will not contain table columns when triggered with a dot following the table alias if the table alias has the same name as a database schema
Edit Data Refresh doesn't warn about pending unapplied changes and immediately overwrites them with the newly retrieved data
Deleting an object from Schema Explorer doesn't work if the object contains non-Latin characters in its name
Edit Data doesn't update the table correctly if it contains computed columns
Schema Explorer database objects appear unmapped from Source Control if the database is connected using Native Team Foundation Server driver and the server is temporarily unavailable
Switching between SQL and XML language syntax highlighting in Query Window can freeze the application if the loaded text is larger than 5 MB
Formatting Options dialog doesn't have the standard application icon
Format SQL command corresponding keyboard shortcut Ctrl+Shift+F is not visible in the Query main menu
Schema Explorer objects Source Control status refresh doesn't show the objects as no longer mapped if the corresponding Source Control parent project was deleted or renamed using Source Control Explorer
Executing Custom Menu containing a '{TableName}' in its definition doesn't encapsulate the {TableName} in square brackets in the resulting script if the table contains non-alphanumeric characters in its name
IntelliPrompt auto-completion list containing a list of table columns is displayed when triggered with a Ctrl+Space keyboard shortcut following a <schema_name>.<partial_object_name> if there is identically named table in the database as the specified schema
Two successive '@' characters cannot be entered in an empty Query Editor
Disabling Editor Options | IntelliPrompt Options | Show Table Member List option still allows IntelliPrompt auto-completion list containing tables to be triggered after a dot following a SELECT .. FROM <database>.<schema_name> statement
IntelliPrompt auto-completion list doesn't wrap table alias with square brackets if the alias contains non-alphanumeric characters in its name
Newly created User Defined Data Type is always placed at the bottom of the User Defined Data Types Schema Explorer folder
"Object reference not set to an instance of an object" error is encountered when rapidly switching Query Window state from maximized to tile using Window Tile Horizontally or Tile Vertically main menu commands
Schema Explorer is visually flickering during background Source Control object status refresh operation
Backup Database doesn't work for databases located on a remote SQL Server if the specified backup file path doesn't exist on the remote system
Smart Rename Table refactor does not rename the table if the table is used inside a trigger definition
Application doesn't correctly detect file encoding when opening script files
Automatic column renaming for identically named columns doesn't work correctly and hides some columns from the results if the query specifically stated multiple column names that differ only by a single number at the end of their names
"Object reference not set to an instance of an object" error is encountered on application startup if the Options.xml file is irreversibly corrupted
Add Object to Source Control object level Schema Explorer command doesn't refresh the object Source Control mapping status after successfully scripting it to Source Control
Query Editor object tooltips are not displayed for objects referenced from a database different than the current context database
Workspaces don't save the order of opened Query Editor Windows
Opening a Workspace containing saved Query Window connections to no longer available SQL Servers doesn't properly disconnect and identify disconnected Query Windows
IntelliPrompt displays auto-completion list with existing tables triggered by a dot following CREATE TABLE <schema_name> statement
Source Control Wizard cannot create a new project if the working folder for the selected parent project was never set locally when connected using Native Team Foundation Server 2010 driver
User Defined Data Types cannot be deleted using the Schema Explorer Delete command
User Defined Data Types don't display a context menu in Schema Explorer when the Schema Explorer is connected to SQL Server 2000
Pivot snippet values aren't sorted in the order of selection
Query Execution Plan doesn't display all the statements if the script consists of multiple statement batches
Check Out failed operation error is not displayed when performing a Check Out on a Schema Explorer object connected to Source Control using Native Team Foundation Server 2010 driver
IntelliPrompt auto-completion list containing table columns is displayed triggered by a dot following a <table_alias>.<column_name> if the <table_alias> has the same name as one of the table's columns
IntelliPrompt auto-completion list contains '*' and <Pick Columns> when triggered with a space following a SELECT .. FROM statement only if the SELECT statement is the topmost in a large script with multiple SELECT statements
'Search up' setting of the Find/Replace dialog in Query Window is ignored for the first Replace action by replacing the currently selected match
Schema Explorer displays incorrect length of a User Defined Data Type if it is based on NVARCHAR type
IntelliPrompt auto-completion list contains table-valued functions following DELETE TOP .. [PERCENT] FROM statement
"Object reference not set to an instance of an object" error is encountered when saving an Advanced Grid Cell Copy template for Results after removing the existing template name and clicking the Copy to Clipboard button
IntelliPrompt auto-completion list for the SELECT .. FROM statement contains global alias of a table even after the table has been dropped from the database and Schema Explorer database node refreshed
IntelliPrompt auto-completion list doesn't appear following ORDER BY clause if there are preceding ORDER BY clause complex parameters defined using functions
Expand Wildcard refactor removes one empty line following the selected code for refactoring
Edit Data cannot apply changes to a table containing UNIQUE CLUSTERED key

Changes:

Encapsulate As refactor target type is now only selectable from the Query Editor context menu Refactors | Encapsulate As command before invoking the refactor dialog
Encapsulate As and Smart Rename refactor dialogs 'Refresh' buttons are now named 'Generate preview'
Smart Rename refactor dialog 'Generated script' text box has been moved to a new tab with the same name
Copy SQL Code As refactor Customize Language Templates dialog has been updated for usability by introducing graphics and rearranging existing input controls
Connect to Server dialog has been updated for usability by rearranging existing input controls, improving SQL Server List Management dialog and Database dropdown
Extensibility API (ApexSql.Edit.Interfaces.dll) has the following functions and methods renamed with their functionality unchanged: IEditMainWindow.createQueryWindow to IEditMainWindow.CreateQueryWindow IEditQueryWindow.saveFileAs to IEditQueryWindow.SaveFile IEditQueryWindow.executeQuery to IEditQueryWindow.ExecuteQuery
Extensibility API no longer exposes the following: Interfaces: IEditFormat, ITestDataGenerator, ISchemaExplorerAddIn, IEditApp, ISchemaMenuContext, IMenu, IEditUserControl Types: DeploymentRecord, Utilities, SourceControlNotSupportedException, SourceControlNoLabelException, SourceControlSystemProperty, MenuClickedEventArgs, MenuDisplayingEventArgs Enums: SourceControlItemType, SourceControlCheckOutStatus, SchemaNodeTypes, MenuDisplayStatus, DeploymentExecutionStatus, DeploymentPrereqStatus, DeploymentFileOption
INSERT INTO IntelliPrompt column/value matching keyboard shortcuts have been changed from Ctrl+I and Ctrl+Shift+I to Ctrl+[ and Ctrl+Shift+[
Report Properties dialog for creating a new SQL Server Reporting Services reports has been modified visually and updated for usability to better match the rest of the application
Script execution error messages are now placed in the batch execution order in the Messages tab of the Query Window Results panel instead of always being bottommost
Editor Options | Misc | File Encoding setting will now be applied to all scripts saved in Projects and Workspaces instead of always forcing ASCII encoding

Release:	2008.11.0171
Date:	August 27, 2010
Description:	Medium feature, major fix release

Enhancements:

Smart Rename Refactor is now available for Tables, Views, Stored Procedures and Functions through the Refactor context menu of an object in Schema Explorer
Smart Rename Column Refactor is now available through the Refactor context menu of a Table | Columns or View | Columns object in Schema Explorer
Smart Rename Parameter Refactor is now available through the Refactor context menu of a Stored Procedures | Parameters or Functions | Parameters object in Schema Explorer
Encapsulate Now button is added to the Encapsulate As refactor dialog to allow for immediate execution of the generated Encapsulate code script
Schema Explorer, Query Editor, Object Explorer and other context menus have icon images assigned to all commands
Team Foundation Server 2010 Source Control integration is now supported through proprietary Native Team Foundation Server driver
Encrypted SQL Server 2000/2005/2008 objects can now be seamlessly decrypted in the application (requires membership in the sysadmin server role)
Encrypted object decryption behavior can be controlled using Options | General Scripting Options | Script encrypted object and Options | Source Control General Options | Script encrypted object settings
Encrypted object coloring in the application can be modified using Options | Fonts and Colors | Encrypted Objects Fore Color setting
Object Explorer and What Is automatic background information loading can now be turned off using Options | General Options | Object Explorer and What Is Loading on Demand
Schema Explorer Source Control object status refreshing speed has been increased at least 100% when working with larger databases
Source Control Check-In and Check-Out comment dialogs can be permanently turned off using the "Don't show this dialog again" checkbox or Options | Source Control General Options | Display Check-In/Check-Out comment dialog settings
IntelliPrompt auto-completion lists will now appear after OUTPUT DELETED and INSERTED statements
IntelliPrompt auto-completion lists are now available after WITH, OPTION and OUTPUT INTO clauses in a DELETE or UPDATE statements
IntelliPrompt now supports auto-completion list for an ALTER FUNCTION and ALTER PROCEDURE statements
'MaximumTokensPerGroup' All Settings option is now available to limit the maximum number of object names per object type group loaded for highlighting in Query Editor, defaulted to 2000

Fixes:

Schema Explorer Source Control connected database objects are displayed as not mapped to the Visual Source Safe 2005 project when multiple users are accessing them at the same time
Application doesn't display objects as mapped to Source Control after connecting a database from Schema Explorer using Subversion 1.5.6 via SVN protocol without remembering Source Control user password
Change Working Folder command from Source Control Explorer is not able to set an arbitrary folder as Source Control subproject's working folder
"Could not find file" error message displays when Checking-Out a database object from Schema Explorer if corresponding working folder was previously changed using Source Control Explorer
"Can't connect to host" error is encountered while scripting multiple new objects to Subversion 1.6.1 repository via SVN protocol
IntelliPrompt auto-completion list after an INSERT INTO statement doesn't contain temporary tables
Application doesn't insert NewID() column values automatically when editing table data
IntelliPrompt auto-completion list offers PRIMARY KEY as a valid entry for an INSERT statement
'Save on Close' feature doesn't work for new and previously unsaved Projects in Project Explorer
Encapsulate As refactor uses the whole Query Editor script when only a part of the script is selected
IntelliPrompt communicates more frequently with the connected SQL Server when using table aliases instead of tables
IntelliPrompt doesn't display all columns from specified table following SUM function in a SELECT sub-query
"Object reference not set to an instance of an object" error is encountered if two Schema Explorer tabs are opened with one of them connected to a SQL Server instance which is no longer available
"Selected code cannot be refactored" error message is displayed even after successfully executed refresh action of Encapsulate As refactor
Application cannot select and open multiple files via the Open File dialog
Newly created synonyms aren't available in the IntelliPrompt auto-completion lists
Source Control Item History dialog doesn't contain information about actions performed
Query Editor Source Control context menu remains enabled after using Schema Explorer database context menu command Remove database from source control
Adding a new Source Control label at the database level in Schema Explorer doesn't work when the database is connected to Source Control using Native SourceGear Vault driver
Source Control commands at the object type folder level do not work when the database is connected to SourceGear Vault 4.1.4 using Native SourceGear Vault driver
Source Control Wizard does not remember last used project path when Edit Source Control command is executed when working with Visual Source Safe version 6.0d via MSSCCI
"Selected code isn't applicable for refactoring" Encapsulate As error message is encountered when processing valid SELECT statement with JOIN constructions
Query Editor does not display mouse hovering tooltips for APP_NAME, Cert_ID, CertProperty and COUNT_BIG system functions
Objects added to Source Control from Schema Explorer via Add Object to Source Control command are not shown as mapped when the database is connected Visual Source Safe 6.0d using Native Visual Source Safe driver
Close Schema Tab Schema Explorer context command doesn't close the connection to SQL Server
Add/Remove Application operating system command doesn't allow uninstalling specific ApexSQL Edit installation if the same ApexSQL Edit versions are installed in different folders
"The multi-part identifier could not be bound" error is encountered when executing a SELECT statement if table or view alias is used in a multiline comment sections
The Escape key doesn't close What Is dialog when the Dependencies tab is active
IntelliPrompt auto-completion list doesn't display cursors after a WHERE CURRENT OF clause in a DELETE statement
IntelliPrompt auto-completion list displays duplicated items after a WHERE clause of a DELETE statement if the condition column has been changed
IntelliPrompt items '-Join...' and <Pick columns> cannot be chosen from the auto-completion list by typing on the keyboard
Adding a new file to Source Control repository using Query Editor | Add File to Source Control with 'Check-Out file After Adding' option enabled will not enable the Query Editor Source Control Check-In command
'Database vs Source Control Differences' Schema Explorer Source Control report displays database objects and corresponding repository scripts as different even if they are the same when the database is connected to SourceGear Vault 4.1.4 using Native SourceGear Vault driver
Database objects lose Source Control mapping status in Schema Explorer after restarting the application for databases connected to SourceGear Vault 4.1.4 using Native SourceGear Vault driver
Refresh Source Control command executed at a database Schema Explorer context menu level does not refresh object status after application restart when the database is connected to SourceGear Vault 4.1.4 using Native SourceGear Vault driver
IntelliPrompt doesn't display user defined scalar functions in auto-completion list following an EXEC statement
IntelliPrompt doesn't display functions in auto-completion list after an EXEC statement if 'Show Procedure Member List' option is set to False
IntelliPrompt doesn't display unnamed variables in a variables auto-completion list
Non-descriptive error message is displayed when using Source Control Wizard to connect to SourceGear Vault 4.x server using wrong user name, password or server URL
IntelliPrompt doesn't display auto-completion list after a 'WHERE (' construct following a SELECT statement
Encapsulate As refactor removes GO statements after sp_addextendedproperty calls
IntelliPrompt doesn't display auto-completion list with columns for Common Table Expression alias following a FROM in an UPDATE statement
IntelliPrompt doesn't display auto-completion list with table columns following variable assignment statement
IntelliPrompt doesn't display auto-completion list with Common Table Expressions following a JOIN in a SELECT statement
IntelliPrompt doesn't display auto-completion list with object aliases following an ORDER BY in a SELECT statement
"Specified cast is not valid" error is encountered when opening the execution plan on a script using an implicit cast of returned value
Encapsulate As refactor displays the same error message multiple times when processing code which cannot be encapsulated
Select Distinct Value custom action invoked from Query Editor over a table name in a FROM clause results in SQL code containing '[<unknown>]' string instead of the table name
Copy SQL Code As refactor doesn't select the whole script in Query Editor automatically if nothing is selected
Check Syntax refactor tooltip error messages point to wrong script line numbers
"Incorrect syntax near..." message is encountered when trying to backup from Schema Explorer a database containing non-letter characters or spaces in the name
Show Changes in Script dialog cannot be closed using the Escape key
IntelliPrompt doesn't display auto-completion list with columns for aliases in an UPDATE ... SET construct
IntelliPrompt doesn't display auto-completion list with variables and functions following a TOP clause in a DELETE statement
Schema Explorer Favorites filter cannot filter User Defined Types and Synonyms
Query Editor active connection is changed after opening and closing server pick-list in the main toolbar
Query Editor Find/Replace will only locate the first occurrence of a text starting with '@' character if the 'Match whole word' option is enabled
Query Editor tab colors aren't set when changing the active connection database context by executing a USE statement
Using the F3 key in Query Editor to find a text does not use the 'Match case' and 'Match whole word' search settings
Floating results grid is automatically docked after executing a script
Query Editor script cannot be executed if 'Execute with @Parameters' setting is enabled
Default order of toolbar buttons Next Bookmark and Previous Bookmark is reversed
Clicking in Query Editor doesn't close the Full Text View dialog
Script execution error messages point to wrong line numbers
Connect to Server dialog Server pick-list is not sorted by server displayed name
Remove Parameters refactor generates a script with a syntax error when removing the only parameter from a procedure or a function
INSERT To table script has syntax errors if any table column contains spaces in its name
Next/Previous bookmark main toolbar commands don't wrap the bookmark search from the last to the first bookmark and vice versa
Show execution plan command displays a blank page if there is a syntax error in the script
IntelliPrompt displays tables in auto-completion lists even if 'Show Table Member List' option is set to False
IntelliPrompt displays '*' and '<Pick columns>' entries in auto-completion lists for SUM and AVG system functions
Schema Explorer Source Control View command always gets the first file version when connected to SourceGear Vault 4.1.4 using Native SourceGear Vault driver
Delay in opening a new Query Editor is proportional with the SQL Server connection speed due to unnecessary communication with the Server resulting in slowdown of several seconds for narrowband connections
"Object reference not set to an instance of an object" error is encountered when an EXEC statement IntelliPrompt auto-completion list is invoked if the connected SQL Server becomes unavailable
IntelliPrompt doesn't display auto-completion lists for table valued functions if referenced via alias in a WHERE condition of a SELECT statement
IntelliPrompt doesn't display auto-completion list of columns for a GROUP BY if CASE WHEN operator is used
Schema Explorer Source Control Check-In batch executed for several objects doesn't check-in the changes when working with SourceGear Vault 5.0.2
IntelliPrompt displays auto-completion list with several GO entries following SET ANSI_NULLS ON if preceding code contains sections separated by GO keywords
IntelliPrompt doesn't add an empty space after an auto-populated code following a JOIN keyword when a predefined relationship is selected from the auto-completion list
Check-In command executed from Source Control Explorer does not work if previous check in was performed from Schema Explorer
IntelliPrompt doesn't display auto-completion list of reserved keywords in Query Editor when CTRL + SHIFT + R key combination is pressed
IntelliPrompt removes parts of the surrounding code when appending snippet parameters for procedure execution following an EXEC or EXECUTE statement
"ArgumentException" error is encountered when typing a '@' after an UPDATE
Adding objects using Schema Explorer Add Object to Source Control command doesn't work if password is not remembered in Source Control Wizard when mapping the database to a Team Foundation Server 2008 project using Native Team Foundation Server driver
None of the refactors will work when connected to a SQL Server 2000 database with empty password
Application freezes on startup if SQL Server specified via the Connection Manager dialog is unavailable
"Login failed for user ..." error is encountered when opening a saved query with a connection if the saved connection user password has been changed in the meantime
IntelliPrompt displays auto-completion list with table columns following a Common Table Expression definition when Space and Tab keys are pressed
The connection timeout setting for SQL Server is not considered when connected SQL Server becomes unavailable
Multiple "Failed to connect" error messages are displayed if the connection to the SQL Server has been lost and Object Explorer didn't complete background object information loading
Object Explorer refreshes HTML tab two times on each database object selection change in Schema Explorer
Application consumes large amount of system memory when working with databases having more than 3000 objects as soon as any text is entered in the Query Editor
It is not possible to map two databases using Native Subversion Source Control driver without restarting the application
Source Control error messages are displayed per each object when performing any Schema Explorer Source Control batch operation if the mapped Source Control system becomes unavailable
Schema Explorer Source Control context menu object level items are all disabled after the application is restarted if the database was mapped to Source Control without remembering user password
"Object reference not set to an instance of an object" error is encountered when renaming a project in Source Control Explorer connected using Native SourceGear Vault 4.1.4 driver without remembering Source Control user password
IntelliPrompt auto-completion lists show stored procedures and functions when the "Show Procedure and Function Member Lists" option is disabled
IntelliPrompt does not display auto-completion list of temporary table columns for the second parameter in the COALESCE statement
Source Control menu items are still available in the Query Editor context menu if the object has been deleted from the Source Control project
Query Editor doesn't display system function tooltip hint if any character is typed following a '('
Background Schema Explorer Source Control object status refresh fails if the database was mapped without remembering Source Control user password
Encapsulate As Stored Procedure refactor doesn't show a warning message when trying to encapsulate a script with syntax errors

Changes:

Application log file is now saved in a new location when the application is started with the '/log' switch: '%LOCALAPPDATA%\ApexSQL\ApexSQLEdit\ApexSQLEdit2008.log' or '%USERPROFILE%\Local Settings\Application Data\ApexSQL\ApexSQLEdit\ApexSQLEdit2008.log' for operating systems prior to Windows Vista
Object Explorer all tabs information loading is now delayed one second to optimize performance when quickly changing current object context
Query Editor default encoding is now set to UTF-8 instead of using the system default encoding
"PromptOnQueryClose" All Setting option is now accessible through Options | General Options | Prompt when Closing Query Editor
Encapsulate As and Customize Languages refactor dialogs now have updated control positions, default dialog sizes and new icons in dropdown controls
Encapsulate As refactor no longer has 'Open in Existing Window' functionality
Formatting Options dialog has been redesigned for improved usability: option groups are now vertical, only one preview script is available per group of options, multiple individual options were renamed placed in corresponding groups and information balloons are added for each of the individual options
Schema Explorer database level Source Control commands Set up Source Control and Edit Source Control Setup no longer require database objects Source Control status refresh after closing the Source Control Wizard in order to successfully complete the database mapping to Source Control
Source Control refresh performance warning message following successful mapping of Schema Explorer database to Source Control can no longer be permanently hidden and is different than the performance warning message shown after any manually invoked batch Source Control operation
All application proprietary assemblies are now signed using ApexSQL private key and can be manually verified for validity

Known issues:

Encrypted database objects cannot be added to Team Foundation Server 2010 when connected using Native Team Foundation Server driver
INFORMATION_SCHEMA views are not recognized in Query Editor or suggested by the IntelliPrompt when connected to SQL Server 2000

Release:	2008.10.0169
Date:	March 18, 2010
Description:	Medium feature, major fix release

Enhancements:

Table Editor is now available for visual creation and editing of tables using the New Table and Edit Table context menu commands in the Schema Explorer's Table nodes
Remove Parameter Refactor is now available through the Refactor context menu of Stored Procedures and Functions in Schema Explorer
WITH common table expressions are now supported when "Show Temporary Table IntelliPrompt" functionality is enabled through Editor Options
SQL Server 2000 and SQL Server 2005 system functions IntelliPrompt pop-up help has been enhanced to support all of the existing system functions with detailed descriptions in tooltips
User interface customizations (main window panels, toolbars, menus, context menus, grids and window positions and sizes) are now preserved after the application is updated or reinstalled
Global aliases assigned to objects from Schema Explorer or application options are now listed in IntelliPrompt auto-completion lists where appropriate with suffix "(alias)"
Help topic context sensitivity is now improved to open more specific online help topics when help is requested using the F1 key on the application main window specific panels and throughout the application
Expand Wildcards, Qualify Object Name and Encapsulate As Refactors are now initializing much faster, up to 600% when refactoring SQL Servers over narrowband connections
Delete Source Control file feature is now available through the file context menu of Source Control Explorer

Fixes:

System function tooltip stays open after typing on the keyboard, preventing normal usage of Query Editor
Newly created tables do not show up in the IntelliPrompt auto-completion lists if they were created immediately after a new database was created from a script in Query Editor
On selecting entry from pick list, IntelliPrompt changes FROM clause part of a SELECT statement from Views by removing any additional specified data sources
GROUP BY clause IntelliPrompt stops working after editing any part of the query following the clause
'Test Mode' option doesn't display the word "TEST" in the tab caption of Query Editor window
Application doesn't display currently opened file name in the Query Editor window tab caption
Identical JOIN auto-complete candidates are displayed several times in the IntelliPrompt auto-completion lists
JOIN auto-completion candidates based on foreign key pairs are missing in the IntelliPrompt auto-completion lists
Multiple identical table columns are displayed in the IntelliPrompt auto-completion list after WHERE condition for table aliases
Object Search | What Is context menu command caption contains DDL script instead of the selected object's name
Columns for table aliases are missing in the IntelliPrompt auto-completion list in SELECT sub-query with JOINs
Query Editor tooltips don't change automatically when changing mouse hover position from one object name to another without a mouse click
Tooltip with table function parameters disappears after starting to type the first parameter value
Schema Explorer Source Control foreground refresh initialization takes several minutes instead of just several seconds for Native Subversion driver immediately after placing a database under Source Control
Query Editor tooltip stays open indefinitely after moving a mouse pointer away from an object name
Performing Check-Out followed by Get Latest Version on a Visual Source Safe 2005 connected database object will result in "Access to the path is denied" message when trying to save the opened script
Table names containing special characters don't show up in the IntelliPrompt auto-completion lists
Local variables and tables are displayed in an IntelliPrompt pick list after "FROM @" construction in a SELECT sub-query
Source Control state of Schema Explorer objects isn't updated if a database is connected to Source Control using non-default file name templates with Native Subversion driver
Table columns are listed twice in the IntelliPrompt auto-completion list if a table under default schema has been referenced several times in the same query, with schema and without it
"Navigate to Schema Tree Node" Query Editor context menu command doesn't work
"Show Sorted Column List" Editor option doesn't work and IntelliPrompt column auto-completion lists are always sorted
Current connection SPID is retrieved from the SQL Server in the background on every keystroke in Query Editor effectively reducing Query Editor responsiveness on remote SQL Server connections
"Copy Sql Code As" refactor language customization dialog doesn't remember any customizations between application sessions
"Get Row Count" Custom Menu action creates SQL code with many syntax errors
Up/Down keyboard arrows no longer browse through the Query Editor tooltip pages
"What Is" dialog opened from the Object Search results grid context menu doesn't display information for indexes
Saved queries cannot be opened from a workspace if related query connection is bound to an unavailable SQL Server instance
Source Control operations stop working after first Source Control Explorer context menu command when connected to a repository using Native Subversion driver
Table columns are listed twice in IntelliPrompt auto-completion list for JOIN auto-complete after ON keyword
Both tables and columns are displayed in IntelliPrompt auto-completion list after ON keyword in sub-query with any JOIN operation
"Use Alias/Table in Where Clause for Single Table" IntelliPrompt option doesn't work
Functions and their aliases are listed twice in IntelliPrompt auto-completion list for a WHERE clause
Columns IntelliPrompt auto-completion list is not displayed after SET keyword in the UPDATE statement
CURSOR entries are not displayed in IntelliPrompt auto-completion list after "FETCH NEXT FROM @" construction in Query Editor
Tooltips for system functions with already specified parameters are not displayed
Tooltips for system functions are not displayed on Shift+Ctrl+Space keyboard shortcut following '('
If the names of a database table and its schema are the same, IntelliPrompt auto-completion list displays database objects under the schema after "." for "<schema_name>.<object_name>" constructions instead of table columns
IntelliPrompt auto-completion list is not displayed after ON keyword in query with JOIN operation
After a WHERE clause if two different aliases for same table are used IntelliPrompt auto-completion list contains incorrect suggestions
"Navigate to Schema Tree Node" Object Search results context menu command works only for one use if the object is located by its parent
Foreign keys default schema actions are not working in Object Search results
CROSS JOINs after ORDER BY clause have no IntelliPrompt auto-completion lists invoked on space key
Assigned table aliases are not displayed in IntelliPrompt auto-completion list for DELETE statement
IntelliPrompt auto-completion list contains table names instead of columns for DELETE statement if table name and schema are the same
Auto-completion IntelliPrompt lists are triggered in comments after '@'
SELECT sub-queries IntelliPrompt auto-completion lists are not triggered after GROUP BY, HAVING and ORDER BY keywords
Query Editor tooltips are not displayed for most asymmetric key and certificate functions
Tooltips for GETANSINULL, OBJECTPROPERTY, PARSENAME, DATABASEPROPERTY, DATABASEPROPERTYEX, SERVERPROPERTY, and SQL_VARIANT_PROPERTY functions are not well formatted in Query Editor
Multiple function tooltips can be shown at one time by specifying function names and opening brackets in a single row one after another
Functions tooltips don't disappear if a cursor is moved down in the Query Editor window
Query execution messages are outputted in an incorrect order: affected rows information is displayed before the query execution message generated by scripts that preceded the query
Source Control password is requested to be inputted two times after the Source Control Wizard is closed if SourceGear Vault 4.1.4 system via native drivers is used
Arbitrary folder cannot be set for Source Control subproject working folder using Source Control Explorer context menu command Set Working Folder
"Specify local path" error message is displayed on creating a new Team Foundation Server project from Source Control Wizard using native Team Foundation Server driver
Set Query Tab Color feature doesn't work
TAB key no longer selects an entry from the IntelliPrompt auto-completion list
TAB characters are added as a part of column names for INSERT constructions IntelliPrompt auto-complete if a column name and column data type is tabulated
Objects containing Visual Source Safe unsupported characters in their name cannot be added to the Source Control system using Source Control Wizard and via native driver display "There was an error when adding file to Source Control" error message
Team Foundation Server projects cannot be deleted from the Source Control Explorer
Ctrl+C pressed in the Results window column causes an "Unable to cast object of type 'System.Drawing.Bitmap' to type 'System.Array'" exception error if a column contains an image data type
Application freezes when selecting "*" from the IntelliPrompt auto-completion table columns list if a single space is entered after "TableName (" of temporary table declaration
"There is no object with 'BarViewData' key in the collection" exception is encountered on application startup if Layouts.xml file is corrupted due to a previous unexpected application shutdown
Datetime field cannot be directly modified using keyboard in filter row of Edit Data window
"Apply Changes" command discards the inserted data instead of saving it in Edit Data window
When "Leave the Connection open" option is active, application doesn't display error messages for failed queries
Both a system function tooltip and IntelliPrompt auto-completion table columns list are displayed in Query Editor at the same time if a table name is used as a system function parameter
Modified rows are not highlighted in the Edit Data window grid
Apply Changes button in the Edit Data window removes the filters applied to displayed data in the grid
Schema Explorer doesn't refresh table indexes when the Refresh command is selected from Tables | {table_name} | Indexes context menu
Default schema cross-database statement doesn't show IntelliPrompt auto-completion list of columns after a WHERE clause
Save Macro command doesn't remember the query typed if the IntelliPrompt auto-completion is triggered by a mouse click
Save Macro command doesn't remember the Macro name in the Macros dialog box if the name is changed
Show Database/Source Control Script Differences command is enabled in the context menu of Schema Explorer even if a database isn't connected to a Source Control system
Edit Source Control Setup command executed from Schema Explorer database Source Control context menu always shows parameters from the last database mapped to a Source Control database
User-defined functions are available in INSERT INTO IntelliPrompt auto-completion lists
Refresh button in Edit Data window removes the filters applied to the displayed data
Table/view alias used in a multi-line comment section causes an execution error in subsequent SQL statements
"...Invalid access code (bad parameter)" error is encountered if a very long comment is added when Update Source Control command is executed from the Schema Explorer
Adding a new record that violates table constraints when editing data through the Edit Data command doesn't display any warnings about constraints violation
'Include Database Context' scripting option set for functions is not applied when creating the ALTER script for Functions
It is impossible to create a table if its name is used as an alias of another table
Displaying refactored (encapsulated) code in existing window doesn't mark modified and unmodified script parts correctly
Help main menu links to SQL Server newsgroups are not working
Check Syntax Refactor doesn't show syntax errors if the wrong alias name is used
Check Syntax Refactor doesn't show syntax error if a non-existing column name is used
"...has stopped working" error is encountered after opening multiple Query Windows on Windows Vista 64-bit SP1
"Object reference not set to an instance of an object" error is encountered on clicking the Cancel Query command during a query execution
Query Editor window tab color is not changed after modifying query connection using the Connection Manager
WITH option of PRIMARY KEY in CREATE TABLE statement is not indented during code formatting if 'Indent Based on Keyword Size' option is ON - CASE operator content isn't wrapped during code formatting if 'Wrap Lines if Greater Than' option is selected
Number following stored procedure after a semi-colon (";<number>") is always carried to the next line after formatting

Changes:

Query results can now be toggled between text and grid view using the new Ctrl+Shift+R keyboard shortcut instead of the old Ctrl+R shortcut

Release:	2008.09.0168
Date:	November 17, 2009
Description:	Major fix release

Enhancements:

Temporary table member listing in IntelliPrompt is now available when new option "Show Temporary Table Intellilists" under Editor Options | IntelliPrompt Options is enabled
Listing of synonym columns is now supported in IntelliPrompt
Options | Fonts and Colors | Results | Grid Results Alternate Row Color option is in to allow alternating row background colors in the results grid
Cross-database IntelliPrompt Table and View column listing is now supported allowing IntelliPrompt column lists to be shown for databases other than the currently connected one

Fixes:

"Object reference not set to an instance of an object" exception is encountered when deselecting last object of the filtered object list in the Source Control Wizard
IntelliPrompt doesn't display columns for alias containing special characters
All Settings dialog must be closed twice if there are no opened editor windows
Several All Settings dialogs can be opened at the same time
Permissions Viewer dialog cannot be closed using Cancel button nor Alt+F4 key combination
Anchoring Tear Off Results dialog covers upper part of the containing results grid
Ctrl-C key combination for copying selected text doesn't work in the query window
IntelliPrompt selects first table based on input instead of appropriate one used in current query context
SQL Server Books Online help doesn't open from query window
IntelliPrompt doesn't remove additional, already entered characters or columns on selecting "*" from the pick list
IntelliPrompt doesn't display tooltips for SQL Server 2000 system functions NULLIF and IDENT_SEED
IntelliPrompt displays function names after CREATE TABLE statement
Ctrl+R and Ctrl+E keyboard shortcuts don't work if Query Editor panel loses focus
Ctrl+R shortcut results in switching resulting data representation from Grid view to Text view
Ctrl+Shift+R shortcut doesn't start macro recording
"Object reference not set to an instance of an object" exception is encountered when running a query with Yes/No parameter defined
IntelliPrompt doesn't insert owner name when selecting "*" from pick list even if Insert Object Owner setting is set to True
"Apply Changes" command takes time to update cursor state to "busy" (hourglass) when editing data using Edit Data dialog
"Hide/Show Editor Pane" toolbar command doesn't keep its state when clicked
"Hide/Show Editor Pane" toolbar command doesn't work until code has been executed in the active Query Editor window
"Auto Fit Columns" option doesn't work when reusing the same Query Editor window after retrieving differently structured resulting data
It is impossible to close Edit Table window if "non-insertable" (duplicated key, particular column value) data exists in edited row
Mouse pointer isn't updated to busy (hourglass) status when performing Find and Replace All operations on larger scripts
Resulting data cannot be displayed in a text mode if Include Row Numbers option in Results parameters is True
"UpperCaseReservedWords" All Settings option doesn't control case of LEFT, RIGHT, OUTER, INNER, JOIN, AND, OR reserved words
Default Schema Actions set for tables are inherited by index in the Object Search results
Default Schema Actions set for columns and indexes aren't working in the Object Search results
IntelliPrompt list displays additional, wrong choices if there is a column with the same name as a table in the database
"Show System Tables" option doesn't determine both system tables and views visibility
Application freezes when cutting a block selection if it includes the last code line in query editor
After using Window | Tile Horizontally command, application fails to resize opened Query Editor and cuts scroll bars
Select Distinct Value command run for a column creates SELECT statement with schema and table name embraced in square brackets together
Navigating to Schema Tree Node command in Object Search dialog doesn't work if target server has been changed
Database Text Search dialog doesn't preserve search configuration on closing
IntelliPrompt displays columns from all tables in a SELECT statement if database contains several tables with the same name but with different schemas
IntelliPrompt doesn't prefix schema to the table name in SELECT statement when Pick Columns option is selected from the pick list and all columns are selected from the Select Columns dialog
IntelliPrompt displays table alias several times for GROUP BY and HAVING clauses
IntelliPrompt does not display table/view columns in SELECT statement for aggregate functions
SELECT statement cannot be executed correctly for tables with application set aliases if alias name is omitted after corresponding table name in the query
Selected text from Query Editor is not copied to Find/Replace dialog when invoking Find operation using Ctrl+F keyboard shortcut and Find/Replace dialog is already opened
SELECT FROM <temporary_table_name> statement cannot be executed if the temporary table is created using the CREATE TABLE statement
Application doesn't display Geography and Geometry data type values in Object Explorer using hexadecimal format
Tooltips are cut off from the top in Query Execution Plan diagram
Assigning alias from Schema Explorer to an object will automatically assign the same alias to all objects sharing the same name but with different schemas
Tear Off Results dialog displays DateTime values without the time portion
"Column doesn't allow null" message is shown for columns of GUID type when changing active Schema Explorer | Edit Data window
Application doesn't display "*" in edited Query Editor tab until the tab loses and regains focus
"Save changes before closing" dialog doesn't display "No to All" command if there are more than one modified Query Editor window on application shutdown
Application doesn't display numbering column in results displayed as text if CopyRowNumber All Settings option is set to False
Template Explorer pane does not display templates if the panel was hidden during application startup
Application creates local working folders when browsing Visual SourceSafe project from Source Control Explorer connected via MSSCCI
It is impossible to set arbitrary folder as Source Control subproject working folder using Source Control Explorer
"Error while getting reporting services reports" error is encountered on application startup if previously connected reporting server is not available
IntelliPrompt freezes the application for a few minutes on processing scripts with new table declaration
Custom Menus feature doesn't replace "{DatabaseName}" and "{ProcedureName}" tags with selected object's name
"PromptOnQueryClose" option is no longer available in the All Settings dialog
After renaming Source Control project from Source Control Explorer, project's working folder is changed to a new folder created in the application installation folder when using Visual SourceSafe via MSSCCI
Same working folder cannot be used for two different Visual SourceSafe projects
"You have no rights to any repositories on server" message is displayed per each object in the database if there are insufficient access privileges for current MSSCCI Vault connected database account
Source Control Item History dialog is missing information about performed operations
"Failed to connect to server" message is displayed for each database object on generating Database Vs Source Control Differences report for database connected to Subversion repository after a new object has been added to the repository
Application displays additional Source Control Log On dialog on refreshing Schema Explorer when a database is mapped to SourceGear Vault via MSSCCI
Query Editor Source Control context menu commands don't work for objects opened from Source Control Explorer connected to Visual SourceSafe project via MSSCCI
"Object reference not set to an instance of an object" error is encountered when adding files to Source Control using Query Editor context menu command "Add File to Source Control" when connected via MSSCCI
"Remove Source Control" operation doesn't disable Query Editor source control context menu for queries connected to a Subversion repository
Source Control Explorer's Show History context menu command doesn't work when connected to MSSCCI SourceGear Vault
Renaming the same project from Source Control Explorer multiple times leads to duplicating it on Team Foundation Server when connected via native drivers
Schema Explorer "Check-In" Source Control context menu command with "Keep Checked-Out" option enabled doesn't modify the file version in the connected repository if Visual SourceSafe is used via native drivers
If Source Control user password isn't saved on the Source Control Wizard login step, Source Control mapped objects state isn't refreshed in Schema Explorer
IntelliPrompt doesn't display pick lists in Query Editor window if database is connected via Windows Authentication mode and current Windows user has limited SQL Server access rights
"System.InvalidCastException" is encountered when running a query with a parameter of Data List type defined via Add/Edit Query Parameters dialog
"GetFile command failed" error is encountered on adding object via Query Editor context menu command "Add File to Source Control" for MSSCCI SourceGear Vault connected queries
IntelliPrompt places selected text from the pick list after the aggregate function parenthesis instead of inside them
"The specified path, file name, or both are too long" error is encountered on auto-updating if full path of any application folder exceeds length of 260 characters

Changes:

The functionalities provided by the ApexSQL Source Control add-in are now integrated to the application and no longer require the add-in nor the add-in's activation
Application evaluation period has been changed from 30 to 90 days

Release:	2008.08.0167
Date:	October 23, 2009
Description:	Minor fix release

Enhancements:

Source Control General Options | Check-Out on Source Control Explorer Open File setting is implemented allowing automatic Check-Out on Source Control Explorer Open File context menu command or on file node double-click
Show Database/Source Control Script Differences functionality is now available under Schema Explorer object level Source Control context menu

Fixes:

Refreshing Schema Explorer objects mapping state doesn't work if database is mapped to Source Control without remembering user password
Application opens ASCII files with UNICODE encoding which results in unreadable onscreen characters
Refactor | Encapsulate As... Query Editor context menu command processes entire editor code instead of highlighted code portion only
Executing USE database_name statement doesn't change active database context in case there is a comment before USE
"A network-related or instance-specific error occurred" exception is thrown on ApexSQL Edit startup if Load on Startup option is set in Tools | Options | Connection Management dialog box for unavailable SQL servers
Source Control Explorer fails to reconnect to the Source Control repository after application is restarted if connected using activated ApexSQL Source Control Native driver but after initial trial period has expired
"Object reference not set to an instance of an object" exception is thrown when modifying WITH statement of common table expressions in Query Editor
Show History Source Control Explorer context menu command doesn't work if connected to Microsoft Visual SourceSafe via MSSCCI
Torn off results grid (Results grid Tear Off Results context command) doesn't remember contents if another query is executed in the same window
"Object reference not set to an instance of an object" exception message is displayed on connecting database to Source Control if SQL Server is unavailable
"Item has already been added to collection" exception is thrown on using table type variables in self join query in Query Editor
ApexSQL Source Control Native add-in unregisters from available add-ins grid in About dialog on application startup if add-in was activated after the initial trial period has expired
IntelliPrompt doesn't display temporary table columns correctly if using table alias
IntelliPrompt doesn't work for cross join constructions
Selecting "*" from IntelliPrompt pick list does not remove previously selected columns
IntelliPrompt automatic pick list keyboard matching doesn't follow list selection order in a mixed case lists
"Save changes before closing" dialog displays "No to All" button if closing a single Query Editor window from a few opened ones
Comment above selected script that for "Encapsulate As" refactor is included in refactoring

Changes:

Source Control General Options | Open object for modification after Check-Out setting will now affect both Source Control Explorer and Schema Explorer Check-Out actions

Release:	2008.07.0166
Date:	October 5, 2009
Description:	Medium feature, major fix release

Enhancements:

Debugging and Profiling SQL Server 2008 stored procedures and user-defined functions are now supported
Encapsulate As refactor has been added to the Refactor context menu of the Query Editor. This allows for code encapsulation as stored procedures, scalar inline functions and table inline functions
The Schema Explorer Tooltip Timer Delay display option which specifies schema explorer mouse hover tooltip time delay in milliseconds has been added to General Application Options (default is 2000)
Snippet system literal $tblvw[N]$ is now available providing access to the IntelliPrompt list containing both tables and views
Default Schema Action is now functional in Object Search results grid on object double-click. If Default Schema Action is not defined for an object type, double-click will only navigate to the corresponding Schema Explorer node
What Is dialog can now be invoked using Ctrl+B keyboard shortcut

Fixes:

Default setting values aren't consistent for a number of settings (all Fonts and Colors options, Smart Indent Tokens, Characters in Tab, Tabs as Spaces, Query Open Connection, Prompt for DML Confirmation, Tracing Type, Leave Quick Info Window Open, Include Row Number in Results and more) and it is possible to start the application with different default values depending on the first setting usage context
Editor Options | Format Visual Query Text doesn't format text when returning from visual query editor to query editor
Show/Hide Editor Pane command hides editor and leaves the area blank instead of expanding results panel
Using MSSCCI-compatible drivers results in multiple consecutive prompts for login and Source Control project input
PureCM MSSCCI driver cannot be used as Source Control status isn't properly detected and Source Control commands fail
Incorrect Schema Explorer and Source Control Explorer Source Control status detection for MSSCCI-compatible drivers and ApexSQL Source Control Add-in Native drivers in multi-user working environment
Warning or error messages are displayed for some MSSCCI-compatible drivers (Team Foundation Server, PureCM, and others) when initiating any Source Control operation while the application is updating Schema Explorer objects' Source Control status in the background
What Is dialog is opening up much slower when invoked for large tables
IntelliPrompt does not display column list for an alias which is used for a temporary table
Output from DBCC commands like DBCC CHECKDB is not formatted correctly in the results output window
Query window information tooltips cover up window areas without disappearing after user action
Application doesn't switch to Results/Messages tab on errors and hides script execution errors
Application displays non-descriptive error message when debugging stored procedures for remote systems
Connecting to server by IP address throws CyptographicException exception
IntelliPrompt does not display column list after WHERE clause if table alias is not used
Enter key does not start Object Search automatically from search input box
'Path already mapped' exception is thrown if working folder used for connecting database to Team Foundation ServerSource Control is selected for another database
SELECT statement doesn't display IntelliPrompt for temporary tables
SQL Server 2000 triggers aren't scripted for Script As, CREATE To action
Team Foundation Server is unusable when used via MSSCCI: all source control operations throw errors on initialization
Application doesn't change active database when executing USE statement specifying database name in square brackets
'Cannot access disposed object' exception is thrown when trying to display the Results toolbar
IntelliPrompt doesn't filter columns from current SELECT construction in WHERE clause if preceding code contains several SELECTs
slow performance when executing Check-in operations on a database or folder using ApexSQL Source Control Native Visual SourceSafe driver
Application doesn't load workspace file created with ApexSQL Edit 2008.05
Double-clicking a temporary table name in Query Editor doesn't include "#" in the selection
Query editor Ctrl+F shortcut always opens a new find dialog even when a find dialog is already open
INTO keyword case is changed to lowercase when pressing a spacebar after typing INSERT INTO
Activation form for Source Control add-in appears even after successful activation
Query Editor "save changes" dialog contains 'No to All' button when closed as a single editor window
IntelliPrompt adds a dot before column names in SELECT statements for user defined functions
All database objects are displayed as connected and existing in source control right after connecting a database to source control using ApexSQL Source Control Native Visual SourceSafe driver
Variable tooltip is displayed on hovering mouse pointer over an error swirl instead of displaying error information if Check Syntax refactor is turned on
IntelliPrompt doesn't display columns in SELECT statement for table variables
IntelliPrompt doesn't work for cross join constructions
IntelliPrompt isn't displayed for Create Table constructions with special symbols in table name
IntelliPrompt doesn't display user-defined functions in SET constructions using CASE functions
Recent files list is limited to 19 entries instead of 15
Formatting options are not applied to the SELECT statement typed in the Query Editor window
Application doesn't offer to restore last backed up workspace on startup if connection to SQL Server was cancelled and previous session was forcefully terminated
Full Text View dialog shows wrong data after switching columns position
Aggregate functions cannot be added to Source Control
Datetimeoffset values lose their accuracy when displayed in the Object Explorer
Pressing CTRL+SHIFT+F for the second time changes already formatted code again
Place Operators at New Line (at End) formatting option doesn't work
'Do not indent' formatting option doesn't work
Renaming Source Control project from Source Control Explorer renames wrong project for ApexSQL Source Control Native Visual SourceSafe driver
Application doesn't allow performing any Source Control-related operations if ApexSQL Source Control add-in trial period is expired
Right-click on Source Control Explorer root node in disconnected mode throws NullReference exception
Qualify Object Names refactor includes wrong schema for object if two objects with the same name but with different schemas exist
Grid filter row is read only for Query Editor Executed Batches tab
Query Editor tab text changes its font on hovering with mouse pointer
Schema Explorer folder or database level initiated Source Control operation display empty object selection dialog if there are no objects to select from
Tear-Off Results grid is missing group and filter context menu commands
Results displayed in text mode are different from the results displayed in a grid
"Check Syntax" refactor doesn't work for constructions with non-existing table columns
Check In command via the Visual SourceSafe native driver fails if a local folder is changed for checked out files
Connection validation passes for Visual SourceSafe database even if used path points to non-existing file or folder
Adding a new folder to Team Foundation Server 2005/2008 via native driver fails if root folder on server is not mapped
"The path is already mapped" exception is thrown if different Team Foundation Server users are trying to map a database to the same computer folder via the native driver
Renaming a Subversion project via native driver also renames the working folder
It is impossible to rename a busy folder when using the Visual SourceSafe source control system via the native driver

Changes:

Activating the application no longer requires application restart
Workspaces saved from now on will be stored as standard XML files; backwards compatibility with previous version 2008 Workspaces is preserved
Projects saved from now on will be stored as standard zipped XML files effectively increasing loading speed for larger Projects by at least 20%; backwards compatibility with previous version 2008 Projects is preserved
Query Editor F2 keyboard shortcut now detects Source Control connected databases and initiates Source Control "Edit" command for object under caret instead of simply generating object script; functionality is unchanged for databases not connected to Source Control
Editor Options | Client Script options category with four belonging options have been deprecated as they were made obsolete by the Copy SQL Code As refactor
Tooltip Timer Delay (milliseconds) display option is renamed to Query Editor Tooltip Timer Delay and will now only affect query editor mouse hover tooltips
Schema explorer object nodes connected to Source Control are now always colored the same as all other schema explorer object nodes. MappedSchemaObject_FORECOLOR setting is deprecated
Ctrl+R and F9 keyboard shortcuts now both control results panel visibility and CtrlRHideResults setting is deprecated
QueryContinueOnError setting is deprecated making all queries always continue with the execution even if errors are encountered
General Information read-only Application Version and Edit Settings Path options are deprecated as information is redundant
Object Notes are now always stored in current database; centralized storing of Object Notes using ObjectNotesLocation and related settings have been deprecated

Products	Download	Purchase	Support	News	Company
Database administration	Installer	License	Support forum	What's new	Why ApexSQL?
SQL development	Patches	Resellers	Knowledgebase	What's next	Jobs
Productivity add-ins	System requirements	Competitive upgrades	Documentation	Press releases	Gear
Programmable APIs	Version information		Product videos	Product updates	Contact us

Server management

Programmable APIs

Database development

Productivity Add-ins

Value bundles

ApexSQL Edit release notes