Enhancements:

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

Fixes:

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

Changes:

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