ApexSQL Complete release notes

Enhancements:

• The time to display the right-click context menu in the Object Explorer panel has been improved up to 60%
• The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions

Fixes:

• 135365: SQL Server Management Studio freezes when a table from the hint list is selected and the Show object script option is enabled in settings on Azure SQL Databases
• 136831: Global aliases do not appear in the hint list when connected to an SQL Server instance using the IP address
• 143588: Results search window allows custom values in the predefined drop-down options under the Look in section
• 144110: Insert into statement sub-option from the Copy results as options under the rightclick context menu of the Results grid does not escape single quotation marks (') when exporting the date type value
• 146379: Auto-complete hint list does not show the column list of tables after the Openjson function
• 150182: Server Management Studio stops working when a large result set with more than 1,200,000 rows is searched using the Results search feature
• 153186: Context menu of SQL Server Management Studio’s Object Explorer needs about 10 seconds to appear and causes the host application to hang when a user has db_datareader and db_datawriter database permissions only
• 153951: SQL code competition doesn't work with SQL files that are coming from within a solution in Solution Explorer
• 156946: SQL Server Management Studio freezes up to a minute when the Linked server credentials window is shown in the query editor
• 161458: SQL Server Management Studio stops working when a new query is opened if the connection is established to an Azure instance using the Active Directory Universal with MFA support authentication method
• 161827: Query tabs are not restored on SQL Server Management Studio 2014 startup from the point when they have been saved using the Save workspace option
• 165808: Host application freezes when a table that does not exist in a database is specified in the Insert statement
• 166507: Performance degradation of 50% in processing typed characters when the .sql file location is on a network drive
• 166664: Auto-complete hint list is positioned incorrectly when the cursor is near the bottom of the query editor
• 168851: Auto-complete generates invalid syntax when a column is selected from the list of suggestions in the Create index statement
• 181162: Send anonymous usage statistics option is saved when checked and discard by clicking the Cancel button in the Options window
• 188582: SQL Server Management Studio stops working when the Edit and Delete buttons are clicked randomly in the Auto-replacement window
• 188918: Go to object feature does not query the selected database from either Object Explorer or Available Databases drop-down menu when a database for the connection is set to any database other than the default under connection properties
• 200849: The right-click context menu of Object Explorer has a delay of about 6 seconds when connected to an SQL Server instance using any of the Azure Active Directory authentication methods
• 193835: “Delete statement without a Where clause” built-in execution alert is triggered even though there is the Where clause in the Delete statement
• 193838: Execution alert conditions are not being saved after either SQL Server Management Studio or Visual Studio restart
• 194773: Auto-complete hint list does not show column suggestions after the Where clause when querying table containing a special character in its name
• 93604: Auto-complete hint list does not show context-sensitive hints after the Join keyword when used after the Cross join statement

Changes:

• Executed queries feature has been renamed to Query history
• Log executed queries option has been renamed to Log ran queries

Changes:

• The application is now part of the ApexSQL Fundamentals Toolkit for SQL Server bundle and requires activation

Fixes:

• 193844: Performance deterioration in processing typed characters speed when using the auto-complete feature on a remote SQL Server

Fixes:

• 188619: SQL Server Management Studio stops working when joining a temporary table to another regular table in the Select statement from the hint-list of suggestions
• 164702: The toolbar remains in both SQL Server Management Studio version 2012 and 2014 after the add-in has been uninstalled

Changes:

• Error handling and send logs functionality has been modified

Enhancements:

• Application telemetry now collects anonymous data on the use and performance of applications and application component
• New ApexSQL Updater allows users to configure advanced updating settings of all installed ApexSQL products

Fixes:

• "System.IndexOutOfRangeException" error is encountered when the Hint-list feature is used on the SQL Server 2008 R2 version
• Data from the Results panel of the executed Select query with the Cast function is dropped from the column in the exported Excel sheet
• Date column under the list of the Executed queries window is missing the timestamp when the query was executed
• Export to Excel feature does not export the Null value from columns correctly for some built-in data types
• Font weight of the tab in use loses bold when either selected portion of the code or entire code in query editor is executed
• SQL auto-complete inserts invalid code from the Select query with the Join clause when the Insert column owner option is disabled from the Inserts tab of the Options window
• SQL Server Management Studio stops working when trying to use the hint-list feature without permissions to access the master database

Enhancements:

• Active Directory – Integrated authentication support
• Current statement execution option is added under the right-click context menu of Query Editor
• Enclose identifiers within square brackets option is added under the CRUD submenus of the Options window

Fixes:

• "Error generating CRUD procedures" error is encountered when the Create CRUD procedures command is used from Object Explorer on a database which contains one or more tables without a primary key
• "Error navigating to node" error is encountered when the Navigate to object command is used on a column name in a Select statement from the right-click context menu in the query editor
• "No data to export" message is shown when the Export to Excel button is clicked on a very large query result set
• Export to Excel removes decimal points with numeric data types for the European convention where the dot is the thousands separator and the comma is the decimal separator
• Host application freezes for a few seconds when a database context is specified to a database name that does not exist on a connected SQL Server
• "Object reference not set to an instance of an object" error is encountered when the Options command is used from add-in main menu in Visual Studio 2019
• Object script preview window is unusable on high DPI and 4K resolution
• Scrolling down the list of suggestion in order to view the remaining columns using either mouse wheel or clicking the lower right tiny triangle does not work properly
• SQL auto-complete does not show database objects within either the Create or Alter procedure statement
• SQL auto-complete does not show the list of suggestions after the Isnull function in the Select statement
• SQL auto-complete does not show variables that have been declared and used in a Select statement within the Between operator after And keyword
• SQL auto-complete inserts objects incorrectly when the Format keywords option under General tab of Options window is set to the Proper capitalization value
• SQL auto-complete removes database name from the statement when a table from a different database is selected from the hint-list
• SQL Server Management Studio stops working when code of a query is copied to the clipboard from the Executed queries dialog and the Escape key is pressed to close the dialog
• Tab coloring function loses bold effect when switched to another application and back to host application
• The add-in toolbar disappears when a solution is closed in SQL Server Management Studio 2014
• The application does not integrate into Visual Studio 2017 Community version, even though it was selected during the installation process
• The application shortcut settings are not fully visible under the Shortcuts tab of the Options window on high DPI and 4K resolution
• The application tab navigation settings are not fully visible under the Tab navigation tab of the Options window on high DPI and 4K resolution
• The Availability Database drop-down box cannot be highlighted when Ctrl + U keyboard shortcut is used within SQL Server Management Studio 2016 and higher
• The context menu has a 3 seconds delay until is displayed when right-click is used on a trigger in Object Explorer
• The money data type is exported as a date format in Excel sheet when the numbers from the query results set are with a decimal symbol
• Visual Studio 2019 stops working when a new query editor is opened

Changes:

• Software Transaction Agreement is added as a new step in the installation wizard and updated in accordance with https://www.quest.com/legal/sta.aspx

Fixes:

• SQL Server Management Studio stops working after the Linked dialog is shown
• The add-in doesn't integrate with SQL Server Management Studio 18 GA version
• The add-in doesn't work in Visual Studio 2017

Fixes:

• A custom execution alert for the Alter statement cannot be configured using the options in the New alert dialog
• The application installer does not check if the .NET Framework 4.7.2 is installed on the operating system
• Usage of the '%PROMPT%' macro variable in a snippet generates two empty lines in the output script

Changes:

• ApexSQL parent menu of the add-in is now located under the Extensions main menu in Visual Studio 2019

Enhancements:

• Visual Studio 2019 integration support

Fixes:

• The hint-list inserts the full column path after the Where clause when the 'at' table alias is used
• Tab coloring feature makes it hard to distinguish the currently active tab from other tabs when multiple tabs are opened side-by-side on the same environment

Changes:

• The application now requires Microsoft .NET Framework 4.7.2

Fixes:

• Check for updates on startup option in the available updates dialog is not saved when unchecked
• The names of the hosts in the host integration step are cutoff on high DPI and 4K resolution
• SQL Server Management Studio stops working after connecting to a SQL Server Analysis Services instance
• SQL Server Management Studio stops working after connecting to a SQL Server Reporting Services instance
• The "The ApexSQL Complete _Inst Package" package has not loaded correctly" warning message appears when launching SQL Server Management Studio 18 preview

Enhancements:

• Alter object scripting
• Improved application installer with a dark theme
• New application icon
• New error handling and send logs functionality
• SQL Server 2019 CTP 2.0 support
• SQL Server Management Studio 18 integration support

Fixes:

• “Couldn't locate this type of object or this object doesn't exist in the currently connected database. Check if this type of object is included for display in the hint-list” error is encountered when the Code structure window is active and the “Navigate to object” command is used from the right-click context menu in query editor
• “Create CRUD procedures” command omits square brackets in the generated script when used on an object from Object Explorer
• “Error navigating to node” message is shown when double-clicking a temporal history table in Go to object window to navigate to object in Object Explorer
• “Error navigating to node” message is shown when the “Navigate to object” command is used on a Temporal (History) table which has underscore (_) in its name from the query editor
• “No matches are found” message is shown when “Matching type:” radio button is set to “Regular expressions” option and the Highlight all button is clicked in the Results search dialog
• Auto-complete is sometimes disabled on startup in SQL Server Management Studio
• In the “Look in:” drop-down box of the Results search window the “Current results grid” option is not selected by default
• Missing icons for all object types in the hint-list on high DPI and 4K resolution
• Missing the “Go to object” command in the right-click context menu under the Go to object dialog
• SQL Server Management Studio 17.8 stops working when the Where clause is used in a Select statement and the connection is established to an Azure SQL Database
• SQL Server Management Studio/Visual Studio stops working when the Left join keyword is used to a linked server as the cross reference in the Select statement
• SQL Server Management Studio/Visual Studio stops working when the “Navigate to object” command is used and the user is connected to Azure SQL database via Active Directory - Password authentication
• The application executable installer does not detect that Visual Studio 2017 is running in the background
• The Executed queries feature does not log a query that was executed using the “Select Top X Rows” command from the right-click context menu in Object Explorer
• The execution alert prompt dialog is unusable on high DPI and 4K resolution
• The hint-list runs in the background when called using the Ctrl+Shift+Alt+N key combination from the keyboard to insert a snippet and the query editor tab is floated
• The object tooltip does not show all parameters for objects with more than 5 on mouse over in the query editor
• The Result search window does not close when the Esc key is pressed from the keyboard
• The SQL Server Management Studio is switched to another random running application when the Results search dialog is closed
• The SQL Translate function does not appear in the hint-list on SQL Server 2017

Enhancements:

• Full support for Azure SQL Database

Fixes:

• Tabs are restored upon SQL Server Management Studio startup from a point when they have been saved using the "Save workspace" command even though the "Restore tabs at startup from" option is disabled in the Options dialog
• The "The file has unsaved changes inside this editor and has been changed externally" message is encountered when there are two query editors with the same name and the “Automatic tab renaming” option, under the General tab of the Options dialog, is enabled
• The "Insert into statement" option doesn't escape apostrophes for a string copied from the Results grid
• The Connect to Database Engine error message box appears when the Create CRUD procedure command is used and the connection is established to an Azure SQL Database using the Active Directory - Password authentication
• The data types do not appear in the hint-list suggestions when variables are declared in a Create or alter statement
• The drop table execution alert rule is shown when the Drop database statement is used to delete a database from an instance of SQL Server
• The drop table execution alert rule is shown when the Drop index statement is used to delete an index in a table
• The Navigate to object feature does not work when the Active Directory - Password authentication is used
• The SQL:
  • column master key, algorithm, encrypted value keys,
  • columnstore archive compression,
  • compress all row groups,
  • concat ws function,
  • edition, size and service objective,
  • endpoint,
  • external library,
  • format type,
  • graph options,
  • key store provider name and key path,
  • location and resource manager location,
  • query store,
  • resumable index rebuild,
  • scoped configuration key,
  • scoped credential key,
  • security policy,
  • string agg function,
  • trim function,
  • wait at low priority do not appear in the hint-list

Enhancements:

• Active Directory – Password authentication support

Fixes:

• SQL Server Management Studio stops working when the connection is established to an Azure SQL Database and the "Show object script" option under the General tab of the Options dialog is enabled
• The search result in the code section of the Tab navigation window is not highlighted when the Enter key from the keyboard is pressed
• The Code structure window does not appear when is for the second time launched from main menu
• The search result in the code section of the Executed queries dialog is not highlighted when the Search button is pressed
• The Copy button on the Object script dialog does not work

Enhancements:

• The time for first appearance of the auto-complete hint-list has been improved by up to 80%

Fixes:

• "No data to export" message is shown when the Export to Excel command is used and columns order is changed in the Result grid of a query
• "No data to export" message is shown when the Export to Excel command is used and the Result grid of a query contains a cell of nvarchar type with more than 32,767 characters
• SQL Server Management Studio 2012/2014 stops working when a new query is opened and the Databases folder is expanded in the Object Explorer
• The column list of a table is not fully visible in the hint-list when expanded and the table has more than 19 columns
• The execution alert rule is omitted if it is not selected (highlighted) in the list of rules under the Execution alerts tab of the Option dialog
• The hint-list does not show up if the host application is the German localized version
• Query editor tab caption is barely visible when database connection color is set to a darker shade under the Tab coloring tab of the Options dialog

Fixes:

• The "Error opening Options2 form" error message is encountered when closing the Options dialog and a query editor is disconnected
• The "No data to export" error message is encountered when Export to Excel command is used and Results grid has valid data
• The add-in icons disappear in SQL Server Management Studio 2012 and 2014 when installed in parallel with any other ApexSQL add-in product released after January 22, 2018
• The Close button in the Code description window does not work
• The Code description window shows incorrect data about an object
• The object owner of the column does not appear in the hint-list suggestions

Enhancements:

• High DPI and 4K resolution support
• Applied concepts of Visual Language Dictionary for Visual Studio for iconography, imagery, colors, menus, fonts, formatting and other GUI elements
• Auto-complete hints list appearing time has been improved by up to 100%
• The time for first appearance of the auto-complete hint-list has been improved by up to 280%

Fixes:

• All execution alert rules are deleted from the list when only one is selected and the Delete button is clicked under the Execution alerts tab of the Options dialog
• Double left-click between the Name and Owner columns header in the Go to object dialog selects the object in Object Explorer that is selected in the list
• Double left-click between the Owner and Type columns header in the Go to object dialog selects the object in Object Explorer that is selected in the list
• Double left-click on the columns header in the Executed queries dialog opens three new query editor tabs
• Execution alert does not prevent execution of a query that contains the Drop table statement
• SQL Server Management Studio 2014 stops working when the Top expression is used in a Select statement
• SQL Server Management Studio stops working when the CAST function is used in a Select statement
• SQL Server Management Studio stops working when a linked server table is used in an Inner join statement
• SQL Server Management Studio stops working when in the Look in drop-down box is selected the Current results grid value and the value in the Search term box is 1 in the Results grid dialog when the Results grid is empty
• SQL Server Management Studio stops working when an invalid database name is used in a Use statement
• SQL Server Management Studio stops working when scrolling through the hint-list if the current Windows account is configured as a Standard user
• SQL Server Management Studio stops working when selecting objects from the hint-list in a SQL script that has over 10.000 lines of code
• SQL Server Management Studio stops working when the Decrypt encrypted objects check-box is checked under the General tab of the Options dialog and there are more than one cached databases
• SQL Server Management Studio stops working when the Show object script check box in the General tab of the Options dialog is checked
• SQL Server Management Studio stops working when the hint-list appears while editing list of columns in a Select statement
• Table names are not inserted correctly if columns from different tables are checked in the hint list
• The ApexSQL defaults, My defaults, and Save as my defaults buttons are hidden until scrolled all the way down under the Inserts tab of the Options dialog
• The Options dialog takes 8 seconds to appear when the Options command is clicked from the add-in main menu
• The code preview is changed for the selected query when the list of executed queries is ordered by any of the columns in the Executed queries dialog
• The hint-list disappears when second character is typed in the query editor
• The number of found matches in the Results search dialog does not meet search criteria for the “Current results grid selection” and “Match whole cell content” options
• The leading zero in a value is dropped when exporting 'varchar' data type from Results grid to an Excel document
• The hint-list disappears when the right arrow key is pressed to expand the table’s columns list for the first table in the list
• The Export to Excel command generates a file with incorrect column names after the 10th column
• The hint-list shows two same table names in the same color of which one is an existing table and the other is from a Create statement inside the query
• “Drag a column header here to group by that column” option does not work under Schema cache tab of the Options dialog

Changes:

• The application now requires Microsoft .NET Framework 4.7.1

Fixes:

• "Microsoft SQL Server Management Studio 17 is not installed. Please install this version to integrate into" message is shown and the add-in installation doesn’t continue when SQL Server Management Studio 17.4 is installed
• "Auto-complete must be enabled to perform this operation. Do you want to enable code auto-complete?" message is shown when using New snippet query editor context menu command on a selected block of code while auto-complete is disabled

Fixes:

• The Tab navigation window cannot be reopened when closed by either Hide or Auto Hide option
• User-created execution alerts rules are removed from the list under the Execution alerts tab of the Options dialog when the Default button is clicked
• The hint-list becomes unresponsive after an Insert statement in SQL Server Management Studio 17
• The OK button in the Edit alert dialog closes the Options dialog and deletes edited execution alert rule
• The code preview pane of the Tab navigation window can be manipulated by user
• The Refresh cache dialog appears multiple times when pressing the Refresh cache button
• The hint-list expands table columns for a table under the active table when using the down arrow key to navigate through columns
• The "Do not use alerts for scripts bigger than" numeric up/down control allows negative number in the Execution alerts tab
• The "Do not use alerts for scripts bigger than" numeric up/down value is not saved when the OK button is pressed in the Options dialog
• The "Error opening Options2 form" error message is encountered upon closing the Options dialog when a user profile is imported made in one of the previous add-in versions
• The Options dialog does not close when pressing the Esc key from the keyboard
• The Go to object dialog does not close when pressing the Esc key from the keyboard
• The auto-complete keeps only the first auto-generated table after the From clause and does not add new one when column from another table is selected in the hint-list
• Changes made for shortcuts are not saved and applied under the Shortcuts tab of the Options dialog
• The My defaults settings are not applied for the shortcuts under the Shortcuts tab of the Options dialog
• Execution alerts does not apply after add-in installation until the Options dialog is opened for the first time
• The filter pane in the Go to object dialog can be set to user-defined width and height by moving the mouse
• The shortcuts can be set to only one number or character instead of combination of keys under the Shortcuts tab of the Options dialog
• The Ctrl, Alt, Shift key combination from the keyboard cannot be entered in the Shortcuts tab of the Options dialog
• Missing the "Drag a column header here to group by that column" option in the Executed queries dialog
• The same database can be assigned to two different environments under the Tab coloring tab
• The Import option under the Execution alerts tab of the Options dialog does not import execution alert rules from the Alerts.zip file
• The hint-list inserts the table name of the second table after the From clause only for the first time when checked
• Changes made for a snippet name in the Edit snippet dialog under the Snippets tab of the Options dialog are not saved when the OK button is clicked
• SQL Server Management Studio stops working on Inner join statement when From clause has a linked server as source
• SQL Server Management Studio stops working when the Schema cache list of objects has more than one database cached and the Decrypt encrypted objects check-box under the General tab of the Options dialog is checked

Enhancements:

• GUI themes:
  • Light
  • Blue
  • Dark

Fixes:

• The SQL:
  • move to,
  • reorganize,
  • maxdop,
  • external data source,
  • external resource pool,
  • columnstore compression,
  • pause options of the SQL alter statement do not appear in the hint-list
• The Linked dialog appears even if the “Linked servers hints” option under the Hints tab of the Options dialog is unchecked
• The add-in does not integrate with SQL Server Management Studio 2014 SP2 when the user who started the installation does not have administrator rights
• To date selection field in the Executed queries dialog shows the add-in installation date instead of the current date

Changes:

• The Defaults button in the Options dialog is replaced with the My defaults, Save as my defaults and ApexSQL defaults buttons

Enhancements:

• Export data to XLSX Excel file format from the Results grid context menu
• Automatically create select, insert, update and delete stored procedures from the Object Explorer context menu
• Prevent accidental data modification/loss with the “Execution alerts” options under the Execution alerts tab of the Options dialog
• SQL Server 2017 CTP 2 support

Fixes:

• SQL Server Management Studio v17.1 stops responding when entering a value for the Custom text rule type under the New alerts dialog
• SQL Server Management Studio 2014 stops responding when using group by clause in some cases
• SQL Server Management Studio stops responding when selecting objects from the hint-list in a SQL script that has over 5,000 lines of code
• Executed queries are not saved in Visual Studio 2017
• The "Microsoft SQL Server Management Studio is busy" message is encountered when the Tab navigation is actively used for longer than 2 hours in some cases
• The Copy results as is not copying null value
• The “Auto-generate aliases” option does not generate aliases correctly in join statements
• The Code structure cannot be enabled after using the Reset Window Layout from the SQL Server Management Studio Window menu
• The “Error opening Options form” message is encountered when the “Recover previous session after crash” option under the Tab navigation tab of the Options dialog is enabled and the OK button is pressed
• Tab coloring tab context menu options in the Options dialog do not work
• SQL Server Management Studio stops responding when credentials are entered or the Cancel button is pressed in the Linked server credentials box
• SQL Server Management Studio 2014 stops responding when (Ctrl+Space) keys are pressed in a join statement
• The hint-list is delayed for up to 1 second when it needs to display objects from a linked server
• The results count information under the Results search dialog shows inaccurate number of results
• SQL Server Management Studio stops working when results search is performed for two or more Results grids

Fixes:

• “Exception of type ‘System.OutOfMemoryException’ was thrown.” message is encountered when the add-in is actively used for longer than 3 hours in some cases
• The Go to object, Manage snippets and Test mode shortcuts under the Shortcuts tab of the Options dialog do not work
• SQL Server Management Studio stops responding when the hints list is opened for a SQL synonym
• Auto-complete hints list does not provide SQL synonyms in join statements

Enhancements:

• Support for temporal tables in SQL Server 2016

Fixes:

• The search hint won’t automatically mark the results and the previous search will remain, when searching the query content in the Tab navigation pane
• The hint-list is not shown after the table name in a SELECT statement when the schema name is not explicitly specified before table name
• The hint-list is not showing table columns under the selected schema from the linked server database
• The hint-list does not output columns in the query editor when the table name is chosen in the hint-list after an INSERT statement when connected to the Azure SQL Database
• The hint-list does not provide a list of columns after comma in an INSERT statement when connected to the Azure SQL Database
• The recently closed queries from previous session in the Recently closed tabs under the Tab navigation pane cannot be opened in Visual Studio
• Background queries executed on the connected SQL Server by the add-in cannot be filtered in the SQL Server Profiler
• Excess space is added when columns are chosen from the hint-list in a SELECT statement
• The add-in reloads objects in the hint-list after insertion of two dots (..) in a WHERE clause
• SQL Server Management Studio 2016 connected to Azure SQL Database with large number of objects stops working when a column from the hint-list is chosen
• Database objects are not loaded in the hint-list after a USE statement in the query editor when connected to the SQL Server via IP address
• Restoring tabs from previous session does not work when the Last session option under the Restore tabs on startup from in the Tab navigation tabs is checked
• SQL Server Management Studio is frozen after a couple of minutes working with the Tab navigation pane
• Global aliases do not appear in the hint-list
• The question mark (?) button on the Tab coloring tab, closes the Options dialog
• "Please specify tab coloring to save" message appears after the Save button is clicked under the Tab coloring tab in the Options dialog
• When tab coloring option is specified for a SQL Server master database, the specified color will not be applied when the New query command is selected on the SQL Server level
• The Database column is empty in the Executed queries dialog for queries executed on the master database
• "Error opening form" message appears when closing the Options dialog while the Tab coloring tab is displayed
• Connected SQL Server vNext does not appear in the Schema cache tab
• Create auto-replacement and Edit auto-replacement dialogs do not close when the Esc key is pressed
• SQL Server Management Studio and Visual Studio stop working when the User filter and the Ignore case check box in the Executed queries dialog are used and the Search button is clicked
• The Auto-replacements dialog closes when the list is empty and the Edit button is clicked
• The expand and collapse buttons do not work in the Code structure tool window
• Different colors in the Tab and Status bar of the query window appear when the Tab color is changed
• The status bar in SQL Server Management Studio is not colored when the color under the Tab coloring tab for the database or server is set for the first time
• When the same shortcut is assigned to two different options, the shortcut for the previous option is removed automatically
• The query tab becomes transparent when the Environment in the Tab coloring tab is deleted
• An Environment with the same name can be created, but it cannot be used afterwards
• The System functions check box under the Hints tab in the Options dialog does not work
• The hint-list duplicates a name of the table after a FROM clause when numbers are used for the table name
• SQL Server Management Studio stops working when the asterisk (*) from the hint-list is double clicked after a SELECT keyword and a JOIN statement
• The hint-list does not show objects when after the ON clause AND or OR operators are used
• The Pair Highlighting feature does not work for BEGIN/END block of code
• The Auto-replacements feature does not work in a USE statement
• The Tab navigation pane does not track the query window that was opened before the feature was activated
• The context menu in the Auto-replacements dialog remains open after using the Delete command
• The add-in does not provide information during the installation process when an older version is already installed
• The previously installed add-in version is not removed when the default installation path is changed during the installation of the newer version
• The filters under the Snippets tab in the Options form does not work
• The closed tabs are not shown immediately in the Closed tabs section under the Tab navigation pane
• “Object reference not set to an instance of an object” warning message is encountered when attempting to delete an environment with no name
• The script text can be deleted in the script editor under the Tab navigation pane by using the Cut command from the context menu
• Default Windows shortcuts (CTRL+X, CTRL+C) can be overwritten

Enhancements:

• Tab coloring
• Results search

Fixes:

• The hint-list sometimes becomes unresponsive after a INSERT statement
• Microsoft SQL Server Management Studio occasionally stops working when stored procedures are used from the hint list
• The “Copy code as” options copies only the results from the first set of the result grid
• The “Executed queries” feature does not work when you are connected via SQL Server Authentication
• The “Navigate to the object” option, does not enable the auto-complete option when this option is turned off
• Microsoft SQL Server Management Studio occasionally stops working when use the Manage auto-replacements feature
• The Log folder under the “Executed queries” tab opens a different location than the one that is set in the text box when DPI is set on 125%
• The “Copy results as -> Insert into statement" option does not copy text results with single quotes correctly
• The hint-list does not show objects from the database that is set as a default
• Slow performance in the renaming query tab when using the “Automatic tab renaming” option
• The “Recently closed” tab does not work in some circumstances
• The “Auto-complete” option does not work when opened from the Solution Explorer pane in some circumstances
• The “Automatic tab renaming” option sometimes does not work when a query editor from the Solution Explorer pane
• The “Insert object owner” and “Insert column owner” options do not work as expected in some circumstances
• The “Restore workspace” button does not work in some circumstances
• The hint-list does not work correctly if the Tab key or Space key is pressed, and then typing is resumed
• The installation process will not continue with the installation if detects that some of the Visual Studio instances are running, even though these are explicitly omitted from the list in the “Host integration” form
• A wrong title appears in the info box that appears when the “Navigate to object” option in the context menu from query window couldn't locate type of the object
• The ApexSQL main menu does not show in Microsoft SQL Server Management Studio 2016 in some circumstances
• A Microsoft SQL Server management Studio warning message sometimes appears, when using the Test mode feature
• The hint-list does not work correctly when use SYNONYM
• Unable to execute file in a temporary directory. Setup aborted, when downloading and installing ApexSQL Complete
• The “Sort alphabetically” and “System function” check box are disabled
• The "The 'ApexSQLComplete_InstPacage' package did not load correctly" message may appear when launched Visual Studio 2013/2015
• The "Recently closed" tab in the "Tab navigation" feature does not show recently closed tabs in Microsoft SQL Server Management Studio 2014/2016
• Auto-complete starts to cause delay in the hint-list showing after updating Windows Defender
• The hint-list does not appear when use the "Open empty environment" for the Object Explorer pane in Microsoft SQL Server Management Studio
• The Code tab under the Object script editor does not show correct data when switching from a snippet to some scalar function in the hint-list
• The hint-list removes comments when using an ALTER statement
• The space key does not work for the “Auto-replacements” feature when is active Space key in “Inserts” tab
• The "Copy result as" option does not work correctly with multiple result grids
• The shortcut for the “Create snippet” option is the same as shortcut for the Template Explorer pane
• The name of the second table does not show in the FROM clause list, when from the hint-list in the SELECT statement, choose column from the second table
• Unable to see the Object definition feature when the hint-list is too wide
• Microsoft SQL Server Management Studio may freeze, when trying to insert data and the “auto-complete” option is active
• The hint-list does not show tables when you are connected on default instance of SQL Server
• The hint-list does not work correctly when a query window is dragged from the main window, and not docked
• Microsoft SQL Server Management Studio may stop working when select columns from the different tables in the hint-list
• Microsoft SQL Server Management Studio may stop working, when the shortcut in the “Shortcuts” tab contain a number
• The servers do not appear in the “Server” dropdown box under the “Aliases” tab when initiate “Options” form via the “Manage snippets” option in Visual Studio 2013
• The hint-list does not show up when press dot(.) although the “Show hint list after space” tab or dot option is checked
• An incorrect title appears for the info box when click the "Go to object" feature and not selected a database
• An incorrect title appears for the info box when click the "Restore workspace" feature and there is nothing to restore
• Microsoft SQL Server Management Studio may stop working when using the “Manage auto-replacements” feature
• The hint-list does not show defined aliases in the “Aliases” tab for the tables that use number for the name
• Missing close (x) button on the last window of the installation process
• The hint-list may not show, when loading data in the list the first time
• The “Code structure” feature expands all collapsed code in the query window
• The hint-list does not insert a name of a table in the FORM clause
• Text boxes for shortcuts stay active although the check box is unchecked
• An incorrect tooltip for the “Object” macro under the “New snippet” form
• When a column from the hint-list is checked and double click on the same column, the column will be inserted twice
• The name of the procedure from active query window does not appear in the hint list
• The "Object script" editor allows deleting code from the "Code" tab
• Superfluous dialog box appears in the "Auto-replacements" option, when changing a name that already exists in the "Replace" column
• Check boxes does not show in the hint-list, when using parentheses in aliases
• The text from the “Search” box do not automatically reflect in the code editor under the “Tab navigation” pane
• The same executed query keeps opening in a new tab each time on double click from the "Executed queries" form
• An "Error opening Code structure" error is encountered when the script cannot be loaded properly
• Missing a shortcut for the “Code structure” feature
• The “Decrypt encrypted objects” option does not work in some circumstances
• Content of the query may disappear when clicking the "Save opened tabs" button in the "Tab navigation" pane
• The Microsoft SQL Server Management Studio IntelliSense overlaps the hint-list
• The hint-list does not show list of tables after USE statement
• The “Last session” option under the “Restore” tabs on startup form does not work in some cases

Enhancements:

• Visual Studio 2017 RC integration
• SQL Server Management Studio v17.0 RC1 integration
• SQL Server vNext CTP1 support

Fixes:

• The auto-complete option does not work when you are connected to SQL Server via SQL Server Authentication
• The Runtime Error appears when installing add-in on Windows 7 Pro 32-bit OS
• The Single quotation mark and Comment mark under the Inserts tab do not work
• The Sort alphabetically and System function check box are disabled
• The Insert object owner and Insert column owner do not work as expected
• The Snippet does not work, when in the snippet is inserted the Object macro
• Visual Studio 2010 stops working when the add-in is installed

Enhancements:

• Visual Studio 2015 integration
• Tab navigation
  • Resume work
  • Close unmodified tabs
• Result grid
  • Copy result grid data as INSERT INTO
  • Copy result grid data as IN clause
• Automatic tab renaming

Fixes:

• Opening 'Recently closed tabs' in Visual Studio 2013 will bring a warning dialog that access to some Visual Studio installation file which is denied
• The "Save workspace" does not work properly when multiple Microsoft SQL Server Management Studio instances running
• The hint-list slows down after inserting INSERT statement
• The hint-list does not insert aliases for columns after ON clause
• The hint-list duplicates the name of the aliases after ON clause
• Snippet does not work, when in the snippet is inserted the Object macro
• The "Could not connect to server " warning message appears, when USE statement is used in the query window and the Refresh cashe button is pressed
• The 'System.OutOfMemoryException' error occurs when working with the hint-list couple of hours

Changes:

• Deprecated support for SQL Server Management Studio versions prior to 2012
• Deprecated support for Visual Studio versions prior to 2010

Enhancements:

• Support for SQL Server 2016
• Support for SQL Server Management Studio 2016 integration

Fixes:

• Microsoft SQL Server Management Studio 2016 stops working, when the hint-list start to load data
• The AND, OR, INNER JOIN clauses do not appear in the hint-list

Enhancements:

• SQL Server 2016 RC2 support
• SQL Server Management Studio 2016 RC1 integration
• Improved Go to object feature performance, process of loading objects is now up 50% faster

Fixes:

• SQL Server Management Studio 2016 CTP3.1 stops working when ApexSQL Complete is trying to display a tooltip for the table
• The AS keyword increases by one in a query, when only the "Show hint list after space, tab or dot" option is checked under the "Options" form in the "General" tab
• The superfluous bracket occurs in WHERE clause under the UPDATE statement, when from the hint-list adds column
• The hint-list inserts the same alias for the different tables in FORM clause, when use the "Use first three letters for alias" option
• The hint-list, removes code from the right side of the comma, when in the SELECT statement after comma enters a column from the hint-list and then the same column uncheck from the hint-list
• The hint-list adds the name of the server and the name of the database in FROM clause, when from the list, select any column in SQL Server Management Studio 2012
• The check boxes in the hint-list are inactive for the functions and procedures
• The hint-list does not show checkboxes for the columns under the all functions
• The data from the "Tab navigation" folder should not be deleted when disabled this option in the "Tab navigation" tab
• The hint-list, add additional brackets around the SQL keyword when used for aliases
• The highlighting option does not highlight the EXEC statement when using the "Code structure"
• The check box for all column fields (*) in the table does not work correctly when using in Update statement. When check and after uncheck this box, does not remove columns from the query
• The auto-complete option is disabled when in the query window is a query from linked server, close and then again open SQL Server Management Studio
• The "Executed queries" form causes SQL Server Management Studio to stop working, when scrolling days in the "To" or the "From" field
• In the code preview under the Snippets tab should stay only the "Copy" and the "Select All" option on the mouse right-click
• The excess bracket is inserted, when insert all (*) columns in the INSERT statement
• The "Object definition" window closes, when scrolling in the code editor
• The highlighting option does not highlight the code properly under the "Code structure" feature
• There is no sorting option when click on column under the Go to object feature
• Missing option for the highlighting code and the Expand All/Collapse All options in the Code structure feature
• Missing check boxes for the columns in the hint-list after you typed CASE WHEN statement
• In Snippets tab for the snippet list should be an option when click on any letter from keyboard to search all snippets that begins with that letter and positioning on the first snippet
• When the cursor is in the Name text box and you press the Tab key it will switch you to the Cancel button under the New snippet form
• When open a new or edit the existing snippet, the cursor should appear in the Name text box
• Table alias disappears after selecting a field from the hint-list in SELECT statement
• The hint-list does not follow the cursor when typing queries in specific cases
• The "Test mode" features causes SQL Server Management Studio to stop working if the script is modified after the execution
• There is no hint list for columns after the schema is specified, followed by the dot sign in the JOIN statement
• The installation wizard offers SQL Server Management Studio integration even if that version is uninstalled
• The "Enclose identifier within square brackets" option does not enclose the alias of the first column in the SELECT statement, and encloses it if the FROM is already specified
• The add-in does not recognize an alias in the self CROSS JOIN statement
• The Microsoft SQL Server Management Studio stops working when auto-completing queries while connected to the server from the network
• The hint-list does not contain database objects (tables, views, etc.) from Azure database
• The check box for all columns (*) in the table under the schema in the hint-list is inactive
• Tabs will be restored on startup when starting a new instance of SQL Server Management Studio, even if the "Restore workspace on startup" option is not checked
• The Go to object search function is not narrowing down the list while typing the object name
• Wrong information about the number of objects in the Go to objects window
• The functions are not searchable from the Go to object option
• The "Microsoft SQL Server Management Studio is busy" message appears after pressing the Space key for a specific statement
• If the joined object is specified using the schema in the JOIN statement, the schema name will be duplicated
• The "Date" filter is not applied automatically in the "Executed queries" form
• Missing an option to choose which objects should be searchable in the Go to object option
• The last hint in the hint-list will be cut off if DPI is increased
• Object's hint is not shown when a DPI size is increased
• The column is incorrectly auto-completed in the DATEADD function
• The add-in is missing the "Cancel" button when loading hints or refreshing, which causes SQL Server Management Studio to become unresponsive in specific situations
• The SQL Server Management Studio stops working when "Executed queries" form is being launched
• CR line ending will be removed after the add-in loads pre-defined snippets
• The created alias cannot be the same as a keyword
• The add-in log file is not compressed automatically
• The hint-list goes black when it tries to list all table/view from the database on SSMS 2014 and Windows 10 OS
• Missing option to prevent the check for updates automatically after the host application starts
• The first check box is inactive in the hint-list for the table that created in the same query window where the hint-list is used
• The columns from hint-list are indented for additional one space, except the first one after SET clause under UPDATE statement
• Description grid is not transparent when press CTRL key
• Object definition does not show, Copy and Close button, when the name of a database or table is large
• The Manage snippet shortcuts is checked although I set up configured differently in ApexSQLComplete.xml file
• The OK button is inactive in the "New snippet" form, when using code from the query window for the snippet
• The "Executed queries" form reset SQL Server Management Studio, when you right-click on the list
• The tab navigation grid does not show correct data when the switch from the Opened tab to the recently closed tab and vice versa
• Shortcut for creating new snippet is inactive (Ctrl+Shift+Alt+C)
• SQL Server Management Studio stops working when is being typed "/**/" in the search box under Executed queries and the "Ignore case" and the "Whole word" are being checked
• The Auto-replacement form from context menu should not be closed when click the Cancel button
• The add-in closes the hint list after the first column is inserted using the arrow keys and the SPACE button
• When using the schema in the JOIN statement, the schema name will be duplicated
• The "All columns" hint is not consistent across the multiple occurrences
• Instead of the hint-list, a tooltip is shown after the SELECT SUM (statement is typed
• There are no objects in the hint-list in the CREATE TABLE statement, after the REFERENCES keyword
• ApexSQL Complete change status bar color in the query window

Known issues:

• SQL Server Management Studio will timeout after viewing the query in the Tab navigation feature and saving the workspace, if the corresponding VPN connection is closed

Enhancements:

• SQL Server 2016 CTP3 support
• SQL Server Management Studio 2016 CTP3 integration

Fixes:

• "Object reference not set to an instance of an object" error is encountered when closing SQL Server Management Studio
• The "Loading database objects" progress bar does not stop loading after a specific statement
• Missing an option that will disable showing snippets in the hint-list
• The database is changed to the first one in the database drop-down list, after adding a new alias
• The "Test mode" option is applied to all queries
• "The alias already exists" message is encountered when the Save button is clicked on the Aliases tab, even if there is no saved aliases
• The hint-list does not show columns within the ALTER statement
• SQL Server Management Studio stops working if the hints are used from the deleted database
• The hint for the PATINDEX function is duplicated in the hint list
• Excessive parenthesis is added, when auto-completing the CURRENT_TIMESTAMP function
• Missing a hint for the CONCAT function
• Missing a hint for the FORMAT function
• Missing a hint for the EOMONTH function
• Missing hints for a collection of FROMPARTS function
• Hints are not automatically displayed after the single line comment
• There are no appropriate hints after the INNER JOIN keyword
• The parenthesis are not auto-completed after the COUNT function
• The add-in inserts selection from the hint-list on the Spaces key, even if it is not selected in the Options window
• The hint-list does not appear when the dot is typed after an alias in specific cases
• The alias is deleted and the dot was incorrectly inserted after the selected column in the SELECT statement
• The SELECT statement cannot be executed if the Object owner and Column owner options are unchecked
• Incorrect hints are shown in the SELECT statement, after the USE statement is executed and then deleted
• Incorrect hints are shown after typing the JOIN keyword and the object owner
• Database objects are not shown after the JOIN keyword, in the SELECT statement
• "Object reference not set to an instance of an object" error is encountered when closing SQL Server Management Studio
• Tables from different schemas will be shown in the hint-list even if the specific schema is already specified in the statement
• The statement will be auto-completed incorrectly if the table from different schema is selected from the hint list after the specific schema is already selected
• The Tab navigation option disables an option to restore database in SQL Server Management Studio
• SQL Server Management Studio stops working when a couple of dots are typed in a row in the INSERT INTO statement
• The "Loading database objects" progress bar does not stop loading objects after the INSERT INTO statement is pasted
• The "Insert column owner" is applied in the ALTER COLUMN statement making it incorrect
• The add-in causes SQL Server Management Studio to stop working if columns from different tables are checked in the hint list
• Table name will be changed with table alias, even if there is no alias specified for that table
• Intellisense becomes slow when working with the opened external file
• Server name does not appear in the Server drop-down list under the Aliases tab
• Auto-replacements are not imported after the add-in is updated to the latest version
• The Format keywords and Script objects sorting options setup are not remembered after restarting SQL Server Management Studio or Visual Studio
• The Log folder paths for Tab navigation and Executed queries are not remembered after setting up a new path
• The Export option is exporting default options, instead of the ones that are selected for exporting
• Custom created snippets are not imported after the add-in is updated to the latest version
• Executed queries are not imported after the add-in is updated to the latest version
• Tab navigations are not imported after the add-in is updated to the latest version
• Aliases are deleted after the add-in is updated to the latest version
• All options are reverted to defaults after the add-in is updated to the latest version

Changes:

• Default installation folder changed
• Changed AppData application folder name
• The "Procedure and function member lists" option is checked by default
• The "System functions" option is checked by default
• The "System tables and views" option is checked by default

Known issues:

• SQL Server Management Studio will timeout after viewing the query in the Tab navigation feature and saving the workspace, if the corresponding VPN connection is closed
• The add-in auto-update form contains the wrong message which says that users should be under subscription in order to the upgraded to a new version

Fixes:

• The add-in does not show hints for objects of the selected database, if the Cumulative update 7 for SQL Server 2012 Service pack 2 is installed
• SQL Server Management Studio and Visual Studio loads slower after installing the add-in

Known issues:

• SQL Server Management Studio will timeout after viewing the query in the Tab navigation feature and saving the workspace, if the corresponding VPN connection is closed

Fixes:

• The add-in is not shown in SQL Server Management Studio, if logged into Windows as a standard user
• The add-in fails to show the hint-list after the dot, when the "Show hint list after any letter" option is not checked
• The system functions are not shown in the hint-list
• The add-in does not show proper hints after the BEGIN TRANSACTION statement
• The add-in inserts column owner, even if this option is unchecked
• The add-in encloses data types in square brackets
• The SELECT hint will not be shown in the hint-list, if the "Format keyword - Proper" option is selected
• The add-in will auto-complete SQL code wrongly, when the "Enclose identifiers in square brackets" option is selected
• The cursor is back to a place where the table/view name is inserted, when the specific snippet is added after indenting
• The add-in fails to show hints after the ON keyword in the JOIN statement, if the table alias is not specified
• The add-in does not delete the underlying text in the SELECT statement, when the column list is on a new line
• The "Navigate to object" feature does not work for all object types
• The snippet list is set to the end by default
• The hint-list will be shown even after the query window is closed
• Columns are resizable in some cases and it overlaps table names in the hint-list

Known issues:

• SQL Server Management Studio will timeout after viewing the query in the Tab navigation feature and saving the workspace, if the corresponding VPN connection is closed

Fixes:

• Unexpected tree structure in the Code structure window is encountered when complex queries, such as multiple selects, updates, transactions, etc., are expanded
• Two function's tooltips are overlapping each other in the SQL Server Management Studio query
• Sufficient square brackets or parenthesis are added when typing the JOIN statement in specific cases
• The "Navigate to object" feature navigates to the schema name when the table name is right-clicked and has the same name as the schema
• Square brackets will be removed around datatypes, even if the "Square brackets" closing character option is checked
• Aliases cannot be defined on a local server using the "." or "local" as a server name
• The auto-completion of the INSERT statement adds value for the identity column
• The table alias will be removed if the "Insert column owner" option is not checked
• The "Send logs" button does not open the log file location, if there is no e-mail client installed on system
• The Linked server credentials window occurs even if the "Linked server hints" option is unchecked
• The add-in fails to initiate the hint-list if a query is started from Server Object Explorer in Visual Studio
• Only the last hint is shown when scrolling down to the end of the hint-list
• Inserted snippets are not indented as the rest of the code
• The data source is not added in the FROM statement, when a column is added from a non-existing data source
• The "Save opened tabs" option does not refresh the Preview window correctly
• The add-in installation directory is not empty after it's uninstalled
• The hint-list fails to follow the query window, if it's moved to a secondary monitor
• The hint-list columns are not auto-sized
• The hint-list will not show schemas or tables after the JOIN statement is typed for a database
• A huge lag is encountered when scrolling through the script in Visual Studio, while connected to the remote database
• Redundant toolbar in Visual Studio, which appears when it is unchecked and Visual Studio restarted
• The auto-completed column name gets reversed after the ORDER BY statement
• The add-in inserts column owner in the INSERT statement
• The version of the installer and in the Control panel is not correct
• The hint-list is not auto-sized when expanding nodes
• SQL Server Management Studio stops working when connected to a database on a remote server
• The add-in's hint-list does not follow the SQL Server Management Studio query window, if it's moved to a secondary monitor
• The add-in is not integrated into SQL Server Management Studio, if logged into Windows as a standard user

Changes:

• The hint-list is now auto-sizable
• The "Procedure and function member lists" option is unchecked by default
• The "System functions" option is unchecked by default
• The "System tables and views" option is unchecked by default

Known issues:

• SQL Server Management Studio will timeout after viewing the query in the Tab navigation feature and saving the workspace, if the corresponding VPN connection is closed

Enhancements:

• Over 200 snippets are added to the built-in snippets library

Fixes:

• Missing note/hint in the "Executed queries" feature, that double-clicking a query from the list will open a new window containing that query
• Parallel application installations can be started at same time
• The "Object details" window stays on top even if the user switch to another application
• When the cursor is on schema name in the query window, the shortcut for the "Go to object" form, is changing places of schema name and table name, instead of opening the option
• The add-in inserts schema name in front of the temporary table
• The END keyword will be duplicated when using SHIFT+TAB to set the indentation in the OUTPUT statement
• The add-in toolbar appears each time when SQL Server Management Studio starts
• The "OFFSET" keyword is missing in the hint list
• The "Tab navigation" tab is not saved after SQL Server Management Studio is restarted
• Changing recently closed queries with arrow keys does not change the preview in the "Tab navigation" window
• The selected "Recently closed tabs" tab becomes unselected when the focus is moved to the "Preview" window
• Wrong bracket highlighting is encountered when the font size is increased in the query window
• Store procedure's default values are not inserted when store procedure parameters are automatically inserted
• The "Go to object" list can be scrolled only using scroll bar bar
• "Object reference not set to an instance of an object." error is encountered when inserting values into temporary table
• "The Object Explorer doesn't contain nodes for Credential objects" error is encountered when choosing a credential from the "Go to object" drop down list
• Comma is surrounded with single quotes, when selecting "abc" from behind in the "SET @ABC = abc" statement
• "Object reference not set to an instance of an object." error is encountered when clicking the SPACE key, after auto-completed OUTPUT keyword
• The add-in "Options" are not saved when clicking the "OK" button, but on SQL Server Management Studio restart
• The "Navigate to Object Explorer" option does not work in SQL Server Management Studio 2008
• SQL keywords are not excluded from the applicable aliases
• The add-in stops SQL Server Management Studio if the user is dropped for database and the "Log executed queries" feature is enabled
• The "Go to object" assigned shortcut does not work
• The default location for add-in files is changed after a specific Windows update
• Changing the NULL keyword to apostrophe, brakes code and replaces comma
• Multiple brackets are added when query contains multiple JOINS
• SQL Server Management Studio stops working in case that column is added via auto-complete if the code following it references wrong object
• The setting for the "Suppress tab key" is not remembered after restarting SQL Server Management Studio
• Sufficient comment mark is added after closing the previous one
• The add-in does not allow using quotation marks when using the multi cursor feature
• The "Send logs" button sends logs for wrong add-in
• The column hints are not shown when the SELECT statement is typed within ALTER PROCEDURE or ALTER FUNCTION
• Servers and databases are not shown in the "Aliases" drop-down lists
• Missing the "Edit alias" option in the "Aliases" options
• Saved aliases list disappears when typing the name of the server/database that is different from the ones in the list
• Aliases are not generated for tables when using the "SelectFrom" snippet
• Sufficient alias is created for the same table in a wrong position
• The "Display object script" value cannot be set to a value less than 1500 ms
• The "Object script box" fails to appear for some hint when they are mouse clicked
• The add-in fails to preview hints for the current database when opening a new query
• The add-in fails to preview the tooltip with columns and description if the zoom of the query window is changed, or the TAB key is used inside the query
• Excessive square brackets will be added when completing the JOIN statement
• The add-in allows creating aliases with the same name
• The add-in fails to show hints if the SQL Server collation is set to case sensitive
• The "Refresh cache" shortcut is missing in the add-in options
• The "ApexSQL Defaults" button fails to set all shortcuts to default values

Known issues:

• The add-in fails to initiate the hint list if a query is started from Server Object Explorer in Visual Studio

Enhancements:

• The add-in now supports Azure SQL Database V12

Known issues:

• The add-in encounters an error on attempt to insert a value into table that is not yet created

Fixes:

• The "Object reference not set to an instance of an object" error is encountered when the SPACE key is pressed, after the OUTPUT keyword is auto-completed
• The auto-complete feature is not working in Visual Studio, if logged with the SQL Server authentication
• Various application errors are encountered by exception report module, which are not releated to the add-in

Known issues:

• The add-in encounters an error on attempt to insert a value into table that is not yet created

Enhancements:

• The add-in now fully supports SQL Azure
• The custom format for $TIME$ and $DATE$ snippet variable is added
• The "Go to object" feature now also allows to find triggers, parameters, and columns

Fixes:

• The installer will not give a warning that Visual Studio is running when only Visual Studio is checked for integration
• The TAB key does not auto-complete the word, indent it, and show the hint-list
• The hint-list doesn't show database hints for the Reserved groups
• The created object aliases are not saved after restarting SQL Server Management Studio
• The "Options" and "Manage snippets" do not work in Visual Studio 2008
• The "Insert column owner" option is not checked by default
• Incorrect option name of the "Any server" in the Alias tab
• The "Object reference not set to an instance of an object" error is encountered when the SPACE key is pressed inside the parentheses of a decimal data type
• A missing keyboard shortcut for the "Test mode" feature
• The "Send logs" button opens a new e-mail window, which stays on top, and does not allow to switch to another application
• The "Code structure" feature initiated without a query window opened, opens with the wrong title
• The "Tab navigation" feature initiated without a query window opened, opens with the wrong title
• The "ApexSQL Complete" menu becomes duplicated when using keyboard arrows to navigate through objects in the Object Explorer window
• Selecting particular statement and pressing a single quote key will erase the selected statement and surround the next word in quotes with a space on either end
• Aliases will be duplicated when exported settings are imported again
• The encrypted objects are not properly shown in the "Object details" window in SQL Server Management Studio 2014

Known issues:

• The add-in encounters an error on atempt to insert a value into table that is not yet created

Enhancements:

• The "Go to object" feature allows to find an object inside the object explorer is implemented
• Uppercase aliases option is added
• The "Copy results as" feature allows to copy query execution results to clipboard as CSV, HTML, or XML format is implemented

Fixes:

• The hint-list interferes with manual indentation TAB key
• The "Auto-complete" feature does not consider schema from the EVENTS table after the WHERE statement
• Closed tabs are saved even if they are empty
• The "Restore workspace" function is limited to only one restoring
• When using the "Selectfrom" snippet, spaces are inserted before the FROM, WHERE, GROUP BY and ORDER BY clauses
• An excessive dot will be added when selecting a column from the hint list, after the "<schema>." is specified in the WHERE condition
• The current state of the "Insert column owner" option is not saved after SQL Server Management Studio is restarted
• The "DELETE table WHERE column IN (SELECT <space>" statement will cause an exception in SQL Server Management Studio

Fixes:

• The "UPDATE table SET field = ( SELECT <space>" statement will cause an exception in SQL Server Management Studio
• The hint-list is not showing every time
• SQL Server Management Studio exception may be experienced when autocomplete is enabled after the "USE [" statement is used in large scripts
• The "Auto generate alias" option does not work for the subsequent join tables if the "Join candidates" hint option is unchecked
• Code from last search will be shown when the "Ignore case" or "Whole word" options are changed inside the "Executed queries" window
• Begin and Rollback transaction will sometimes stay in query code after using the "Test mode" feature
• The "System.OutOfMemoryException" error is sometimes encountered when working with a query containing more than 20,000 lines

Enhancements:

• The add-in now fully supports Linked Servers
• The "Restore workspace" feature is added
• The Import and Export options for snippet forms are added
• The shortcut for the "Manage snippets" option is added
• The Objects script box for snippets is added
• An option to create an alias from the first three letters of a table is added
• An option to use AS keyword with alias is added
• An option to insert column owner is added

Fixes:

• The hint-list cannot recognize parameters for the table valued functions in OUTER APPLY and CROSS APPLY statements
• The auto-complete feature adds aliases or an object name to columns
• The "Tab navigation" feature will not open 'not connected' queries in Visual Studio
• The "Insertion keys" option is not working correctly
• The "Object reference not set to an instance of an object" error is encountered after trying to change SQL Server connection with the "Auto-complete" feature enabled
• The "Object reference not set to an instance of an object" error message is encountered after trying to change SQL Server connection with the "Tab navigation" feature enabled
• Any file can be imported as the Options file
• Macro insertion in the Create/Edit a new snippet wizard is not working
• The 'Ignore case' and the 'Whole word' check boxes are not positioned correctly inside the Executed queries wizard
• Click on code field under the Snippets tab in the Options dialog will deselect a snippet
• The variable $USER$ is replaced with the schema name associated to the user, and not the user name
• The 'The Object Explorer doesn't contain nodes for Roles objects' warning is shown for Roles objects in the "Navigate to object" option
• The 'The Object Explorer doesn't contain nodes for Routes objects' warning is shown for Routes objects in the "Navigate to object" option
• The 'The Object Explorer doesn't contain nodes for Services objects' warning is shown for Services objects in the "Navigate to object" option
• The 'The Object Explorer doesn't contain nodes for Contracts objects' warning is shown for Contracts objects in the "Navigate to object" option
• The "Navigate to object" option mismatch User to Schema and Schema to Roles objects
• The application changes the SQL Server Management Studio Find window focus away from dialog
• Wrong application name in the dialog titles
• Random characters in the Create/Edit a snippet wizard on Windows Server 2003
• The Create snippet shortcut is not working
• The "Code structure" feature will not refresh a list after the "Insert snippet" option
• The "Ifexist" snippet will be inserted with the $CARET$ variable
• The Tab navigation and the Executed queries shortcuts do not work in Visual Studio
• Schema prefix cannot be suppressed for temporary tables
• Drag 'n drop of .sql file into SQL Server Management Studio will bring the hint-list with all the keyboard strokes in the 'Connect to database engine' wizard
• Missing information about where to create workspace in the 'no workspace to restore' dialog
• The 'From'/'To' values can be set to impossible values in the Executed queries dialog
• The snippets list inside the Options allows 'grouping by dragging columns'

Changes:

• The Help command is placed under the Resources menu item
• The About command is placed under the Resources menu item
• The Check for updates command is placed under the Resources menu item
• The Send logs command is added to the Resources menu item
• The Product page command is added to the Resources menu item
• The Support center command is added to the Resources menu item
• The Contact us command is added to the Resources menu item

Fixes:

• SQL Server Management Studio stopped working after trying to open "not connected" query from the "Tab navigation" pane
• The hint-list does not show database objects if non-English SQL Server Management Studio is installed
• The "Auto-complete" feature does not recognize some non-Latin letters
• The query editor is unresponsive after typing Italian accent characters until the focus is changed

Enhancements:

• The add-in now fully supports SQL Server 2014
• The "Tab navigation" feature that monitors opened and recently closed tabs is implemented-not supported in Visual Studio 2005 and Visual Studio 2008
• The "Executed queries" feature that logs executed queries is implemented-not supported in Visual Studio 2005 and Visual Studio 2008
• The "Navigate to object" feature that locates objects from script in Object Explorer is implemented-not supported in Visual Studio 2005 and Visual Studio 2008
• The "Test mode" feature that wraps the query in a transaction and executes it without consequences to the database is implemented-not supported in Visual Studio 2005 and Visual Studio 2008
• Improved snippets creation and adding variables to snippets
• The $CARET$ variable is added to the list of available variables for snippets, which represents cursor position
• The built-in snippets library is added
• The "Code structure" feature is improved with more information about the statements in the preview window

Fixes:

• The "Ctrl+Shift+Alt+R" shortcut opens the "Auto-complete" hint-list instead the "Manage auto replacement" option in Visual Studio 2013
• Servers added in the "Aliases" window under the "Options" dialog will not be remembered in Visual Studio
• The hint-list becomes transparent and content invisible when copying code for specific objects from the pick list
• The hint-list won't appear if the INNER JOIN statement points out to another database
• The "Insert object owner" option is disabled by default
• Overwriting a marked text with "[" after the USE keyword will not replace marked text
• The "Auto-complete" feature doesn't recognize some letters for Serbian/Slovenian and Russian keyboard
• The "Auto-replacement" feature does not replace the managed auto-replacement text automatically until SPACE is pressed
• The "Ctrl+Shift+Alt+R" shortcut opens the "Auto-complete" hint-list before the "Manage Auto replacement" dialog
• SQL Server Management Studio goes out of focus when if the Auto-complete feature is enabled using the "Ctrl+Alt+A" shortcut
• The hint-list does not appear for objects with a name written using the localized Cyrillic font
• The incorrect hint-list is prompted after a column type is followed by a bracket
• The DDL window size does not remember vertical size set by the user
• A table previously created in the same query is missing from the hint-list after the SELECT statement if the GO command is included
• Punctuation symbols following the value are taken between the apostrophes when a value (without symbols) is replaced with an apostrophe
• The hint-list is missing choices after the "ON" keyword in the CREATE TABLE statement
• The closing bracket is deleted for the char data type
• The hint-list for the CTE appears in the CTE query in all cases
• The column list is not right for alias in the MERGE statement
• The output doesn't support the "$action" variable
• The "Browse" dialog is missing the "Make new folder" option in the Installation Wizard for the "Select destination location" and the "Select Start menu folder" steps
• The help file for the Snippet options is opened without the left menu
• The "Schema cache" grid context menu commands missing icons in Visual Studio
• SQL Server Management Studio goes out of focus when the "SELECT function(" is typed
• SQL Server Management Studio stops working because of the DEP incompatibility
• The "Value '0' is not a valid value for Interval. Interval must be greater than 0? error is encountered in SQL Server Management Studio with the add-in installed
• The "System.Data.SyntaxErrorException: The expression contains an invalid string constant: '" error is encountered when the " ' " (apostrophe) character is typed inside the drop down input fields
• The "Import" option will completely clear the snippets list

Changes:

• The "Syntax error highlighting" feature is deprecated
• New user interface that follows Metro UI style
• The "Display object script after" option minimum interval is now set to 1500ms

Enhancements:

• Reworked and improved 200+ hint-list templates, most notably
  • Column hints for SELECT tablename
  • Table hints for SELECT columnname INTO
  • Removed column hints for SELECT * FROM
  • Variable hints for SELECT * FROM OPENXML(
  • Only keyword hints for SELECT ProductID, GETDATE() FROM(
  • Variable hints for SELECT * FROM tablename OPTION(OPTIMIZE FOR (
  • Appropriate keywords for ...OPTION(TABLE HINT (tablename,
  • Index hints for ...OPTION (TABLE HINT (tablename, FORCESEEK(
  • Column hints for ...OPTION (TABLE HINT(tablename, FORCESEEK(indexname(
  • Index hints for ...OPTION (TABLE HINT(tablename, INDEX(
  • Linked server hints for INSERT OPENQUERY(
  • Keyword hints for INSERT OPENROWSET(BULK 's',
  • Keyword hints for INSERT OPENROWSET(BULK 's', FORMATFILE = "ss" ,
  • Keyword hints (CURSOR,XML...) for DECLARE @variablename
  • Linked server hints and table - valued functions hints for DELETE statement
  • Table - valued functions hints for UPDATE statement
  • Keyword hints for
    • UPDATE tablename
    • SET columnname = 1
  • Keyword hints for
    • UPDATE tablename
    • SET columnname = 1 [FROM] [WHERE] OPTION(
  • xmlschemaname hints for CREATE TABLE tableName (columnName xml ([CONTENT] [DOCUMENT]
  • IDENTITY keyword hidden ( IDENTITY keyword only for tinyint, smallint, int, bigint, decimal(p,0), or numeric(p,0) columns.) for CREATE TABLE dbo.Test (columnName nvarchar(200)
  • Partition schema hints for cases:
    • CREATE TABLE tableName
    • (
    • columnName int PRIMARY KEY,
    • CONSTRAINT constraintName UNIQUE CLUSTERED (columnName) ON - Partition schema hints
    • )
  • Column hints for
    • ALTER TABLE tableName
    • ADD columnName FOREIGN KEY REFERENCES tableName (
  • Table hints for
    • ALTER TABLE tableName
    • ADD COLUMN [NULL\NOT NULL] [CONSTRAINT C] FOREIGN KEY REFERENCES
  • Column hints for
    • ALTER TABLE tableName
    • ADD COLUMN [NULL\NOT NULL] [CONSTRAINT C] FOREIGN KEY REFERENCES tableName (
  • Appropriate keywords, filegroups and partition schemas hints:
    • CREATE TABLE tableName
    • (
    • columnName int
    • )
    • [ON] - Appropriate keywords, filegroups and partition schemas with partition columns hints
    • [TEXTIMAGE_ON] - Appropriate keywords, filegroups and partition schemas hints
    • [FILESTREAM_ON] - Appropriate keywords, filegroups and partition schemas hints
  • For ALTER VIEW - Removed unnecessary hints
  • For ALTER SCHEMA schemaName - Removed unnecessary hints
  • For ALTER PROCEDURE procName - Removed unnecessary hints
  • For ENABLE\DISABLE TRIGGER triggerName - Removed unnecessary hints
  • For DECLARE @DBNAME VARCHAR(50)
    • SET @DBNAME = 'TEST';
    • DECLARE @MyDate date;
    • BACKUP DATABASE - Show database hints automatically
    • READ_WRITE_FILEGROUPS TO DISK = - Removed unnecessary hints and added variable hints
    • WITH EXPIREDATE = - Removed unnecessary hints and added variable hints
  • Schema hints:
    • ALTER APPLICATION ROLE approle WITH NAME = appname, PASSWORD = 'apppass',
    • DEFAULT_SCHEMA =
  • Symmetric and asymmetric keys hints:
    • ALTER SYMMETRIC KEY symmetricKeyName
    • ADD ENCRYPTION BY PASSWORD = 'asd',
    • CERTIFICATE - Certificate hints,
    • SYMMETRIC KEY - Symmetric keys hints
    • ASYMMETRIC KEY - Asymmetric keys hints
  • Services and queue hints:
    • ALTER SERVICE - All services hints
    • ON QUEUE - Queue hints
  • For ALTER SERVICE serviceName
    • ([ADD CONTRACT] - Contract hints
    • [DROP CONTRACT] - Contract hints);
  • Table hints for REVOKE [ GRANT OPTION FOR ] REFERENCES ON OBJECT::
  • Table columns hints for REVOKE [ GRANT OPTION FOR ] REFERENCES ON OBJECT:: tableName(
  • Database hints for ALTER LOGIN login_name WITH DEFAULT_DATABASE =
  • Credential hints for ALTER LOGIN login_name WITH CREDENTIALS =
  • Filegroup hints for
    • ALTER FUNCTION funcName ()
    • RETURNS @tabVa TABLE(c1 int PRIMARY KEY ON
  • Constraints keywords for DECLARE @var AS TABLE(
  • Column hints for CREATE INDEX indexName ON PartitionTable (AddressLine1, FirstName ASC) ON myRangePS1(
  • Column hints for ALTER FULLTEXT INDEX ON Person.Address ADD(
  • Sequence hints for DROP SEQUENCE name,
  • Index hints for MERGE Production.UnitMeasure WITH (INDEX(
  • Column hints for BULK INSERT t FROM 'path' WITH (ORDER (
  • Auto table hints for CREATE STATISTICS asd ON
  • Column hints for CREATE STATISTICS asd ON tableName(columnName,
  • User hints for DENY ALL TO
  • User hints for DENY ALL ON tableName TO
  • Hint - list ordering for
    • UPDATE STATISTICS t - <index, statistics, keys>
    • CREATE FULLTEXT STOPLIST asd FROM - <stoplist, database, keywords>
    • DROP AGGREGATE - <aggregate, schema>
    • DROP DEFAULT - <default, schema>
    • DROP PROC and DROP PROCEDURE - <procedure, schema>
    • DROP QUEUE - <QUEUE, schema, db>
    • DROP RULE - <rule, schema>
    • DROP SYNONYM - <synonym, schema>
    • DROP XML SCHEMA COLLECTION - <xml, schema>
    • DROP SEQUENCE - <sequence, schema, db>
    • DROP TRIGGER - <trigger, schema>
    • DROP INDEX{0} i on t WITH ({1}MOVE TO ps(<column_hints>
• Hint-list ordering is now based on context
• Performance improvement in processing typed characters and keyboard typing response speed is up by 50%
• Hint - list can now be made transparent by pressing CTRL
• Custom shortcuts for commands can now be defined

Changes:

• Default shortcut keys combination for the Insert snippet command is now 'Ctrl+Shift+Alt+N'
• Default shortcut keys combination for the Enable Auto-replacement command is now 'Ctrl+Shift+Alt+J'
• Default shortcut keys combination for the Show Error list command is now 'Ctrl+Shift+Alt+I'
• Default shortcut keys combination for the Syntax Error Highlighting command is now 'Ctrl+Shift+Alt+P'

Fixes:

• The Auto-complete feature interferes with typing of the accentuation characters
• Overwriting marked text with '[' after the 'USE' statement will not offer complete hints
• The Error list feature is not highlighted when active
• The Code Structure feature is not highlighted when active
• SSMS Intellisense title stays over the top of the tooltip
• The Insert full INSERT statement option does not have help information
• The Code Structure feature marks wrong command in query in case of code errors
• Missing keyboard shortcut for the Syntax Error Highlighting feature
• The "System.TypeLoadException: Method 'GetMenuItems' in type 'ApexSql.Complete.." message is shown when SSMS 2005 is started
• Adding long code via the Auto-complete feature will not navigate query to the end of code
• When assigning auto replacements from the Object Explorer pane and naming it with space in the name, space is not deleted
• In VS the 'Ctrl+Shift+A' shortcut should launch the add new item window
• Missing icons on right 'click menu'
• SQL Server Management Studio stops working when the Auto-complete feature is being enabled
• The 'Ctrl+Shift+A' shortcut deselect actual SSMS window after activating the add-in
• The 'Ctrl+Shift+Alt+A' shortcut for the Assign Auto Replacement feature is duplicated with the same shortcut for the Smart Rename feature in ApexSQL Refactor
• The 'Ctrl+Shift+Alt+E' shortcut for the Error List feature is duplicated with the same shortcut for the Replace one-to-many relationship feature in ApexSQL Refactor

Enhancements:

• The add-in now integrates with Visual Studio 2013
• The SSMS Intellisense Auto list members feature is now disabled automatically while the Auto-complete feature is enabled

Fixes:

• The 'Incremental search' feature in SSMS gets interrupted and disabled when the Auto-complete feature is enabled
• The add-in replaces existing code with random characters if block-selection is used

Fixes:

• Full server name must be entered for alias to be defined (the application will not accept "(local)" or ".")
• The false positive error Wrong "Undisclosed quotation mark" is reported when special characters are quoted
• The false positive "Incorrect syntax" error is reported when specific characters are quoted in a proper way
• Using Syntax error highlighting when processing the large script with SQL Server 2012 specific object types never completes, consuming all available CPU resources
• False positive errors are reported after the SWITCH PARTITION .. TO .. PARTITION clause of ALTER TABLE statement
• Shortcut key combination for the Error list(Ctrl+Shift+E) does not work
• Add-in does not display already displayed error list when the Check syntax interval option has a value larger than 50
• Schema entries are missed in the hint list for the ALTER AUTHORIZATION ON CONTRACT statement of the TO clause
• An incomplete list of keywords is offered in the hint list for ALTER AUTHORIZATION ON construction
• The DECLARE keyword is not formatted properly if TO UPPER is selected for the Format keyword option
• The END keyword is not properly formatted if TO UPPER is selected for the Format keyword option
• The "Deleted" alias is not offered as a valid hint for the FOR DELETE table trigger
• The Syntax error highlighting feature does not identifies the incorrect usage of the NULL value after the INCREMENT BY clause of the CREATE SEQUENCE construction
• The Syntax error highlighting feature reports the false positive error for usage of the valid ALTER SERVICE <service_name> ON QUEUE <queue_name> construction
• The Syntax error highlighting feature reports the false positive error if code contains the DROP XML SCHEMA COLLECTION construction
• The Syntax error highlighting feature does not detect if the ALTER SEARCH PROPERTY LIST code parameters are not in the proper order, which prevents code execution
• The Syntax error highlighting feature does not detect error if UNION is used between two SELECT NEXT VALUE FOR <sequence_name> statements
• The Syntax error highlighting feature does not detect if there is no at least one message of SENT BY INITIATOR or ANY type, when processing the CREATE CONTRACT construction
• Table column hints are not included in the hint list for table alias used after the WHERE clause of a sub-query which is a part of the CROSS APPLY construction
• The Syntax error highlighting feature reports the false positive error if valid DATEADD function parameter abbreviation is used inside the INSERT INTO construction
• The Syntax error highlighting feature reports the false positive error when non-existing objects are used inside the IF EXISTS construction
• The Syntax error highlighting feature reports the false positive error "The "CURRENT_TIMESTAMP" name is not permitted in this context." if the CURRENT_TIMESTAMP system function is used as a value for the INSERT INTO statement
• The Syntax error highlighting reports false positive error for the CREATE LOGIN construction when password parameter is included as hexadecimal value
• The Syntax error highlighting feature reports the false positive error "Un quotation mark after the character string ..." if string with Unicode characters is used as the sp_addextendedproperty procedure's parameter value
• The Syntax error highlighting feature reports the false positive error "The procedure or function '[00001]' does not exist." if [00001] is used as the sp_addextendedproperty procedure's parameter value
• The Syntax error highlighting feature reports the false positive error "The 'DELETED' correlation name is specified multiple times in the FROM clause." if the DELETED alias is used for the JOIN construction inside the FOR DELETE trigger
• Valid tables are marked as "do not exist" if they are used after the CREATE FULL TEXT INDEX ON statement inside code generated via the Replace One-to-many relationship feature
• The main menu command for displaying Options dialog is named Code Completion Options which is misleading as other features related settings are configured via the same dialog
• Error locations in the Errol list grid aren't updated after formatting the code
• The Auto-complete feature does not display sequence objects in the hint list for the NEXT VALUE FOR construction
• The Syntax error highlighting feature reports the false positive error for when the multi-part identifiers System functions are used after the SELECT keyword
• The "Incorrect syntax near ')'" error is encountered and execution is terminated when code is completed via selecting the system function from the Auto-complete hint list for the SELECT keyword
• The displayed Code structure pane is disabled, when Auto-complete option is disabled
• The "The Value does not fall within the expected range: Microsoft.VisualStudio.CommandBars"" error is encountered when Visual Studio or SSMS starts
• The CPU usage increases dramatically when working on a large script with the Syntax highlight feature enabled
• The memory usage of SSMS and VS increases by up to 100% when add-in is installed
• The DECLARE statement does not exist in the hint list when trying to declare the second variable
• SQL Server Management Studio stops working due to constant memory consumption when specific script is being executed
• The add-in disabled from Visual Studio's Add-in Manager cannot be re-enabled without restarting Visual Studio

Changes:

• The Syntax error highlighting feature can now be enabled/disabled from the main menu

Enhancements:

• The "Create snippet" command in the query editor context menu creates a snippet from a text selection
• The "Insert snippet" command in the query editor context menu inserts a snippet at the cursor location
• The $SELECTION$ variable added to the list of available variables for snippets allows the text selected in query editor to be wrapped with the snippet text

Fixes:

• The insertion key is added to the end of the Auto-complete statement
• An alias from the main SELECT constructions isn't offered for the WHERE clause of the nested SELECT statement
• The Auto-complete feature doesn't offer correct hints for the PIVOT operator
• Incorrect errors are reported for the UPDATE statement with the JOIN clause
• The Auto-complete hint list doesn't extend over SSMS GUI, which results in partially visible hints in a long hint list
• The "The object name '<object name>' contains more than the allowed number of prefixes." error is encountered in cases where complex schema name is used as the ALTER SCHEMA construction's parameter
• The hint list for the CONTAINS clause in the ALTER DATABASE .. ADD FILEGROUP construction is missing
• Existing SQL sequences aren't offered in the hint list for the NEXT VALUE FOR clause of the DECLARE variable construction
• SQL table columns aren't offered in the hint list for the FOR clause of the ALTER TABLE .. ADD DEFAULT construction
• Database roles aren't offered in the hint list for the AUTHORIZATION clause of the CREATE SCHEMA construction
• System functions aren't offered in the hint list for the AS clause of the CREATE DEFAULT construction on Ctrl+Space
• Table columns in the hint list for CHECK clause of the ALTER TABLE .. ADD CONSTRAINT construction are missing
• The Check syntax feature reports objects' presence for SQL tables and SQL User Defined Types differently
• The temporary table hint is shown multiple times when processing a script with temporary tables referenced
• A common table expression is shown twice in a hint list for the SELECT statement when it is used after the Common table expression definition
• False positive errors are reported by the Check syntax feature when an analytical or aggregate function is used in the recursive part of a common table expression
• The Check syntax feature reports the false positive error when a convex hull of a geometry instance is used
• The Check syntax feature reports the false positive error when the MERGE INTO clause is used
• The incorrect 'The multi-part identifier <column name> could not be bound' error is displayed for SQL column names from the SQL OUTPUT clause, which applies to INSERT, UPDATE, DELETE, and MERGE statements
• The Check syntax reports the false positive error for an expression used from the hint list when the sub-query is used without EXISTS
• False positive errors are reported when multiple parameters are specified for the CHECKSUM function
• False positive errors are reported when paths for FILESTREAM BLOB fields in a table should be retrieved
• The Check syntax feature doesn't report an error when an invalid name is used for declaring a column inside the CREATE TABLE construction
• The Ctrl+Shift+[ keyboard shortcut for navigating from a value to the corresponding column of INSERT INTO constructions, doesn't work in the opposite direction
• The Check syntax feature doesn't process the new SQL Server 2012 system function CONCAT, which results in incorrect error reporting
• The Check syntax feature cannot determine properly the number of parameters needed to call a User-defined functions, which results in false positive error reports
• Add-in utilizes the Ctrl + Shift + R keyboard shortcut, which is already defined in SSMS for refreshing the local cache
• The false "Invalid object name <table name>" error is reported when tables from Master database are referenced in a query
• The false "The partition scheme or function '[PRIMARY]' doesn't exist." error is reported when processing the script where SQL filegroups are referenced
• The false "Cannot find the user-defined function or the "geometry::Parse" aggregate." error is reported when geometry parameters are used in a SQL script
• The false "A column has been specified more than once in the order by list. Columns in the order by list must be unique." error is reported when a nested SELECT statement is used after the FETCH NEXT clause of the ORDER BY construction
• The Check syntax feature reports false positive errors when objects from a different SQL database on the same SQL Server are referenced in a script
• The Check syntax feature reports false positive errors when a SQL script contains constructions for exploring a physical file structure
• The Check syntax feature reports a false positive error when a common table expression is referenced inside the DELETE FROM statement
• The Check syntax feature doesn't detect when system function parameters aren't separated with the comma sign
• A column alias is reported as an invalid column name when used in the nested SELECT statement of the INSERT INTO construction
• The Error list doesn't report an error when an object to select from is not specified
• Shortcuts for "Disable auto-complete", "Refresh" and "Code structure" menu commands are missing
• A column from a temporary table variable is marked as invalid when used inside the UPDATE .. SET construction after the SET keyword
• The Check syntax feature reports a false positive error when columns from a common table expression are used inside the SELECT construction
• The Check syntax feature doesn't recognize user-defined scalar functions as valid
• The false "The RETURN statements in scalar valued functions must include an argument." error is reported when a scalar-valued function returns result from the SELECT statement
• The Check syntax feature doesn't detect errors in the ALTER FUNCTION construction after the AS EXECUTE clause
• The false "Incorrect syntax near the 'ORDER' keyword." error is reported for the ORDER BY clause when a table-valued function is called from inside a scalar-valued function body
• The false "An aggregate cannot appear in ON clause ..." error is reported when a sub-query is used in the JOIN .. ON construction
• A mouse wheel scrolls query editor and the opened hint list, if it is opened by the Auto-complete feature
• The Check syntax feature reports a false positive referencing column error in a sub-query when it is used as part of the JOIN construction
• The false "The ORDER BY clause is invalid in views, ..." error is reported when the ORDER BY clause in a sub-query is used inside a scalar user-defined function's body
• The Check syntax feature reports false positive errors when hierarchyid methods are used inside the INSERT INTO .. VALUES construction
• The false "Invalid column [geometry::<some method>]" error is reported when the spatial method is used in the VALUES statement of the INSERT INTO .. VALUES construction
• The Check syntax feature doesn't detect syntax error for the CAST .. AS construction of the SELECT statement
• The Auto-complete feature displays tooltip for a wrong system function in a SQL script, when several system functions are used and hovered
• Hints of SQL system functions are listed multiple times in the Auto-complete hint list when system functions are used in the SELECT statement
• SQL Servers are not shown in the Schema Cache Server drop down list
• A false positive error is reported when <xml type>.nodes() method is used after the APPLY clause of the SELECT statement
• The "*Complete: Error in AutocompleteProvider::KeyboardEventsKeyDown" error is encountered when the Ctrl+Space keyboard shortcut is pressed inside the single-line comment
• The SQL database object hints are missing from a hint list for the REVOKE EXECUTE statement
• SQL schema hints are missing from a hint list for the WITH DEFAULT_SCHEMA clause of the CREATE USER .. FOR LOGIN construction
• Using the asterisk from the hint list for outer select from a common table expression adds database reference in front of the column name, which results in a script that cannot be executed
• The Format keywords option does not work when set to "lower"
• The non-existing schema cache is noted in the add-in options schema cache tab when the Auto-complete feature is used in code where Common Table Expression is referenced
• The Auto insert feature from the SSMS grid will overlap the add-in Error list grid
• The false 'Cannot use an aggregate or a sub-query in the expression used in the GROUP BY clause.' error is reported when user-defined function is used after the GROUP BY clause of the SELECT statement
• The false 'The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.' error is reported when the INSERT statement for a temporary table is used
• A snippet doesn't insert '/**' properly
• A snippet list isn't displayed after few matching words
• SQL database hints are not listed in the hint list opened via Ctrl+Space for the BACKUP DATABASE statement
• The Error list does not shows error if the specified schema name is missing
• The Error list does not shows errors in creation script for the existing SQL indexes
• SQL Server Management Studio restarts after working for a couple of hours with add-in installed
• Inserting a snippet via keyboard will insert the snippet code without replacing the snippet shortcut

Changes:

• Deprecated support for SQL Server Management Studio versions prior to 2005 Service Pack 2 (9.00.3042)

Fixes:

• Slow startup time for Visual Studio and SQL Server Management Studio instances

Changes:

• The add-in menu is now under the "ApexSQL" parent menu

Enhancements:

• The "Quick cache refresh" command keeps the in-memory cache synchronized with the database catalog data
• The "Code structure viewer" side pane creates an outline of SQL scripts thus allowing quick navigation through large SQL scripts
• The "Tooltips for identifiers" tooltip provides detailed descriptions for database identifiers
• The add-in supports reusing SQL code fragments by creating snippets and inserting context-specific values as needed
• The "Closing characters auto insertion" feature automatically generates and inserts a closing tag after typing the opening tag for: single quotes, double quotes, parenthesis, comments and square brackets
• Automatically inserted code formatting now uses automatic bracketing for SQL identifiers
• BEGIN/END pairs and parentheses are now highlighted
• The add-in now integrates with Visual Studio 2012
• Reduced the memory usage when using syntax highlighting by up to 50%
• Reduced the overall memory usage when the add-in is installed by up to 2,000%
• Lowered the processor load for the multi-tabbed syntax highlighting by up to 55%

Fixes:

• The "Check syntax" feature does not report a nonexistent column when creating a compressed index
• Selecting a SQL table from the auto-complete hint list for INSERT INTO and UPDATE statements will also insert the names of the corresponding SQL columns
• The add-in doesn't integrate into Visual Studio 2005
• Almost all log file information is inserted into the ApexSQL Version log file when both applications are installed
• The "Check syntax" feature reports the invalid "Incorrect syntax error near the 'ORDER' keyword" error when a FOR XML construction is used as a part of an ORDER BY clause in a SELECT statement
• The "Check syntax" feature reports the invalid error "The multi-part identifier "c" could not be bound" when the "Table Value Constructor" construction is used
• The "No active script window is available" message is displayed when starting the syntax highlighter in Visual Studio 2010
• If two versions coexists on the single system, the new major version of the add-in stores its information in the same log file that was created by the previous add-in version
• Visual Studio 2010 becomes unresponsive when copying from/pasting into a script larger than 100MB
• The "Check syntax" feature reports invalid errors for column names of inserted or deleted SQL tables in the CREATE TRIGGER statement
• The "About ApexSQL Complete" dialog always displays the "About ApexSQL Version" dialog, once the "About ApexSQL Version" dialog has been opened
• The "System.ArgumentException" error is encountered when opening the error message generated after a Visual Studio 2010 project publishing has failed
• The "Check syntax" feature reports the invalid error "The IDENT_CURRENT function requires 0 argument(s)" when using the IDENT_CURRENT data type function in a SELECT statement
• The "Attempt to read or write protected memory" error is encountered when starting the SQL Server Management Studio feature "New Database Diagram"
• The "Check syntax" feature reports invalid errors as it tries to analyze the IF condition in a SQL script
• SQL table columns are missing from the hint list when using the ALTER TABLE statement with a NOCHECK clause and ADD CONSTRAINT
• The auto-complete hints list, where all databases are shown, is displayed after the SET clause of an ALTER DATABASE statement
• The "SSMS - SQL Server Management Studio has stopped working" error is encountered when double-clicking any column header divider in the Error list
• Typing "." anywhere in the grid of the Aliases options tab, will unnecessarily open an auto-complete hints list
• When deleting SQL lines from a query containing over a thousand errors, SQL Server Management Studio can become unresponsive for over 7 minutes
• The "SSMS - SQL Server Management Studio has stopped working" error is encountered when enabling/disabling the "Auto-complete" and "Error list" options with more than one active query tab
• The "SSMS - SQL Server Management Studio has stopped working" error is encountered when opening two empty query tabs while working in one of the three already populated ones
• The add-in doesn't show information about objects included in scripts when hovering over the object name
• The "Check syntax" feature reports the existing SQL triggers as nonexistent
• Scripting of the "Full-Text Stoplist" using the "CREATE To" command is about 15000% slower if the add-in is installed in SQL Server Management Studio 2012
• Auto-complete opens the hints list when typing the IP address in the SQL Server Management Studio "Connect to Server" dialog window
• Initiating and using the incremental search in a query editor via the keyboard shortcut does not work with the "Auto-complete" option enabled
• The "Check syntax" feature reports invalid errors for the CREATE PROCEDURE statements with output parameters in a valid SQL code
• The "Check syntax" feature reports invalid errors for INSERT statements in a valid stored procedure creation code
• The "Check syntax" feature reports the invalid error "Invalid object name" if CTE constructions are used in a JOIN statement
• The "Check syntax" feature reports invalid errors related to object exposed names when multiple CTE constructions are used in the same SELECT statement
• The "Check syntax" feature reports valid SQL view columns as invalid when they are used as system function parameters inside a CTE construction
• The "Check syntax" feature reports the "Correlation name is specified multiple times in the FROM clause" error for a table alias when it is used with a JOIN clause/statement
• The "Check syntax" feature reports the invalid error "The object doesn't exists" when DROP <object type> is used within a condition
• The "Check syntax" feature doesn't recognize the CURRENT_TIMESTAMP SQL Server system function
• The "Check syntax" feature doesn't report an error when the wrong argument is used in a TOP statement
• The "SSMS - SQL Server Management Studio has stopped working" error is encountered when enabling "Auto-complete" after loading multiple 5-50MB queries or when opening more than four 5MB scripts with "Auto-complete" enabled
• The "Check syntax" feature reports invalid errors when a non-declared variable is used in a script
• The "Auto-complete" feature ignores the declared SQL table variable columns after the first closed bracket
• If special SQL trigger tables (INSERTED, DELETED) have aliases in a FROM clause, their utilization in a SELECT statement will not be recognized by the "Check syntax" feature
• If special SQL trigger tables (INSERTED, DELETED) are used in a SELECT statement but are not specified in a FROM clause, the "Check syntax" feature should report an error, since the "delete" alias is not declared in the FROM statement
• The "Auto-complete" feature does not display columns when the "Table Value Constructor" is used
• The highlighted error disappears when a change is made in a different GO block of the current script
• A system procedure is not recognized if it is a part of a "dbo" schema
• The "Check syntax" feature does not report an error for the nonexistent column used in the script when creating a compressed index
• An incorrect qualification is added to temporary SQL table columns when objects are created in a script
• The "Check syntax" feature reports that the SQL search property list doesn't exist when used in a DROP statement
• The "Check syntax" feature cannot recognize columns if an existing synonym is used in the SQL code
• If a COLUMNSTORE INDEX exists in the database when an ALTER/DROP INDEX is used, the add-in gets disabled until an application restart
• The "Qualify object name" feature adds the name of a nonexistent variable to the column
• The "Auto-complete" feature formats object names as keywords when objects are created in a script9325 - The "Check syntax" feature reports the "The multi-part identifier '[.]' could not be bound" error in a valid SQL code
• The "Check syntax" feature ignores the procedure parameters
• The "Check syntax" feature reports invalid errors for SQL table variable columns
• The "Auto-complete" feature does not display SQL table variable columns in the hints list
• The "Auto-complete" feature does not display static methods of CLR data types in the hints list
• The add-in doesn't show information about functions included in scripts when hovering over the function name
• Column names are not embraced with brackets when expanding wildcards when needed while using "Auto-complete"
• The add-in prevents connecting of ApexSQL Version to Vault 5.x servers via MSSCCI
• Scrolling in SQL Objects script dialog window created from auto-complete drop-down menu, scrolls the main script in a query tab
• The "SQL Server Management Studio has stopped working" error is encountered when changing the script if the check syntax processing is in progress
• The "A problem caused this program to stop interacting with Windows" SQL Server Management Studio error is encountered when more than 100 errors are present in Error list
• The "A problem caused this program to stop interacting with Windows" SQL Server Management Studio error is encountered when entering the object name with over 25 characters in the script

Enhancements:

• Auto-complete hints lists are now shown for more SQL constructs and contain more relevant hints
• Logins are now displayed in hints list when triggered after DROP LOGIN or ALTER LOGIN statements
• Users are now displayed in hints list when triggered after ALTER USER statement
• Methods of CLR data type variables are now displayed in hints list when triggered in a SELECT statement
• Columns of table variables are now displayed in hints list when triggered in a SELECT statement
• INDEX keyword is now displayed in hints list when triggered after CREATE COLUMNSTORE statement
• COLUMNSTORE keyword is now displayed in hints list when triggered after CREATE NONCLUSTERED statement
• COUNT system function is now displayed in hints list when triggered after HAVING clause in a SELECT statement
• Script labels are now displayed in hints list when triggered after GOTO statement
• Geometry, Geography, Xml and HierarchyId methods are now displayed in hints list when triggered after corresponding column or variable type
• EVENT NOTIFICATION, COLUMNSTORE INDEX, NONCLUSTERED COLUMNSTORE INDEX, NONCLUSTERED INDEX, CLUSTERED INDEX and XML INDEX composite keywords are now displayed in hints list when triggered after CREATE or ALTER statements
• Table columns are now filtered in the hints list while typing their name
• Error list panel has been improved to find more errors in the code and report them more precisely
• Error is now reported when directly using an aggregate function in a WHERE clause of a SELECT statement
• Inexistent object errors are now reported when incorrect object names are specified after AS OBJECT or AS TYPE clause in EXECUTE WITH RESULT SETS statement
• 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
• Auto-complete hints list appearing time has been improved by up to 50% in subsequent calls

Fixes:

• 'The ORDER BY items must appear in the select list if the SQL statement contains a UNION, INTERSECT or EXCEPT operators' error is reported in Error list panel for statements without UNION, INTERSECT and EXCEPT operators
• Auto-complete hints list doesn't appear automatically following space trigger in MERGE and USING statements
• Error is reported in Error list panel for SELECT DISTINCT statement ORDER BY clause if columns are specified by their ordinal positions
• Invalid object and column names errors are reported in Error list panel for SELECT statement when INNER JOIN clause specifies Tables from a different database than the current one in context
• 'Value cannot be null' error is encountered when Ctrl+C is pressed in an empty Error list panel
• Add-in opens ApexSQL Profile online help whenever help is invoked if ApexSQL Profile is also installed side-by-side and was used first in the SQL Server Management Studio session
• Semantic errors are not displayed in Error list panel for code blocks containing both syntax and semantic errors
• Add-in is not available in SQL Server Management Studio 2012 after applying KB2645410 system update
• Error isn't reported in Error list panel for ORDER BY clause of SELECT statement if the same column is specified both by its name and its ordinal position
• Support Forum menu command opens general instead of add-in specific support forum page
• SQL Server Management Studio Query editor doesn't fill out all available parent window space after it is maximized
• Auto-complete Options | General | Format Keywords setting doesn't affect manually typed DECLARE and SELECT statements
• Encrypted object DDL script is not displayed in auto-complete tooltip when working with SQL Server 2012 database
• Auto-complete hints list doesn't contain newly created Table objects after using Object Explorer Refresh context menu command
• SQL Server Management Studio error is encountered when using space trigger to invoke auto-complete hints list in between CREATE PROCEDURE <Procedure name> AS statement and unfinished Procedure body also containing AS keyword
• Error isn't reported in Error list panel for ORDER BY clause of SELECT statement when Geography or Geometry type columns are specified
• Inexistent object error is reported for a Table specified in SELECT statement FROM clause if the Table was created in the same SQL Server Management Studio session in a different query window
• Auto-complete hints list containing join candidates is displayed after JOIN ON clause when Show Join Candidates setting is OFF
• Object DDL script tooltip isn't displayed after selecting the first hint in auto-complete hints list
• Excess brackets are added to the script when using parenthesis key to select a Function in auto-complete hints list

Enhancements:

• Prompt message is now issued when deleting an alias on Aliases tab in Complete Options dialog
• Errors list contents can now be copied to clipboard

Fixes:

• Error description isn't shown on mouse over in SQL Server 2008 R2 Management Studio query editor
• XML Schema Collections are missing from auto-complete hints list shown after DROP XML SCHEMA COLLECTION statement
• No error is reported for non-existing database specified in USE <database> statement
• Option tooltips shown in Complete Options dialog close too quickly
• Add-in integrates improperly with SQL Server 2008 SP0 Management Studio
• Errors in UPDATE statements aren't removed from errors list after correction in some cases
• Object Count column of schema cache grid shown on Schema Cache tab in Complete Options dialog isn't refreshed while the dialog is open
• "Object reference and Alias should not be empty" error message is shown after deleting an alias
• No error is reported for mistyped system variables inside SELECT statement
• Complete Options dialog size and position are not remembered within a session
• Local *.CHM help file is not used when available
• Object errors aren't removed from errors list after the respective object has been deleted with DROP statement
• Incorrect About dialog may be shown if the add-in is installed together with Refactor 2011.01 or Version 2011.01 alpha add-ins depending on the invocation order
• DATE data type is missing from auto-complete hints list shown after parameter name in Stored Procedure or Function header
• INFORMATION_SCHEMA schema is completely missing from auto-complete hints lists
• Columns are inserted prefixed with schema and object name into INSERT statement in case * (all columns) is selected in auto-complete hints list
• Invalid errors are reported when equally named columns from different Tables are specified in ORDER BY clause at the same time
• Invalid "Incorrect column or user-defined aggregate function" errors may be reported for script-based objects in some cases
• Typing 2 successive dots after an alias in System Function call inside SELECT statement incorrectly opens auto-complete hints list
• Variables are missing from auto-complete hints list shown for Function parameters
• Errors aren't reported for SELECT statements inside ALTER VIEW
• Invalid "Invalid column name" errors are reported for CONTAINSTABLE System Function
• Typing 3 successive dots improperly opens auto-complete hints populated list with Scalar Functions
• Exception is encountered when selecting no longer existing object in auto-complete hints list
• No error is reported if statement preceding Common Table Expression isn't terminated with a semicolon
• Auto-complete hints list shown after removal of the system variable prefix (@@) is incomplete
• Duplicate error is reported for an attempt to use non-existing Stored Procedure in INSERT statement
• Table and Trigger from DISABLE TRIGGER statement are reported as non-existing
• Auto-complete hints list isn't shown after @ typed after copy-pasted SELECT keyword followed by a space
• Invalid error is reported for CREATE CERTIFICATE statement
• Invalid error is reported for RETURN keyword inside Stored Procedure
• Selecting a column in auto-complete hints list shown after schema and object name in SELECT statement adds the object to FROM clause regardless of whether it's already specified there
• Invalid error is reported for CREATE statement followed by DROP issued for the same object
• Auto-complete hints list isn't shown after MERGE and USING keywords
• Invalid error is reported for WITH .. AS statement
• Auto-complete hints list isn't shown after GOTO keyword
• No prompt message is issued when removing an alias on Aliases tab in Complete Options dialog
• Errors list contents can't be copied to clipboard

Changes:

• 'Auto-complete enabled' setting has been renamed to 'Enable/Disable auto-complete'

Enhancements:

• Automatically inserts SQL keywords, database, schema, object, parameter and variable names
• Auto-completes SQL code fragments such as JOIN statements and cross-database queries
• Provides a browsable visual hints list while typing
• Displays hinted object definition and description automatically
• Automatically generates aliases for inserted objects
• Automatically identifies and highlights errors
• Allows quick navigation to all detected errors
• Supports Microsoft SQL Server 2012, 2008 R2, 2008 and 2005

Known issues:

• Incomplete add-in menu in Microsoft SQL Server Management Studio 2008
• Detected error remains in Error List pane even if it is corrected in the code