Solutions
Products
By category
Value bundles
Save when you purchase multiple tools in a discounted bundle
Database administration
Tools for DBAs including auditing and recovery
SQL development
Productivity tools for SQL developers and DBAs
Add-ins
Productivity add-ins for SQL Server Management Studio and Visual Studio
Programmable APIs
Programmable application interfaces for our most popular engines
All ApexSQL tools
A full listing of all of our tools, add-ins and APIs
Popular
ApexSQL Log
Read SQL Server transaction log. Audit and undo changes
ApexSQL Recover
Recover deleted or dropped data and objects
ApexSQL Diff
Compare SQL database schema
ApexSQL Data Diff
Compare SQL database data
ApexSQL Doc
Document SQL databases and SSIS packages
ApexSQL Audit
Audit and undo SQL database changes
ApexSQL Complete
Auto-complete and coding productivity features
Download
Purchase
Support
Support center
Get started with ApexSQL support
Support forum
Get help directly from staff and peers
Support FAQs
Answers to common questions
Troubleshooting
Known issues and workarounds
Knowledgebase
How-to articles, tips and suggestions
Documentation
Online and downloadable help files
Product videos
Videos for intro, what's new and special topics
News
Blog
Get the latest on new releases, updates, promotions
What's new
Information on all new product releases and updates
What's next
A roadmap of upcoming releases and updates
Newsletter
The latest news via email
Press releases
Newsworthy company and product release information
Product updates
Alerts on all product releases including subscription
Company
Why ApexSQL?
Find out what makes us different and better
Jobs
Become a part of the ApexSQL team
Gear
Merchandise for user groups and promotions
Contact us
Contact sales or support by email or phone
Home
Add-ins
ApexSQL Complete
Release notes
What's next
Blog
What's new
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