ApexSQL Complete release notes

Release: 2012.01.0002
Date: March 01, 2012
Description: Beta release

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’
Release: 2011.01.0001
Date: January 12, 2012
Description: Alpha release