Feature

Resolved Issue

Change Request

General

Customized keyboard shortcuts are now assigned correctly (Tools | Options | Environment | Keyboard).

CR#188620

Code Snippets

When creating a new snippets folder, an error no longer occurs if you do not rename the folder.

CR#164885

Connections

When creating a new connection, the Display Name field is now editable by default.

CR#192389

You can now specify the amount of time to wait before a connection attempt times-out under Tools | Options | Database | Timeouts.

CR#206962

If the status bar is hidden, attempting to connect to a database using Toad no longer results in an error.

CR#189787

Data Grid

An error no longer displays if you press CTRL+C or CTRL+A after grouping a column in the grid.

CR#194958

Currently, the Sum and Average mathematical functions cannot be applied to a column.

CR#217319

Database Browser/ Object Palette

You can now generate a creation script for most objects from the right-click menu (Send To | Editor as Script) or the Script tab in the Database Browser.

CR#155222

CR#155224

You can send the SQL script generated when creating, altering, or dropping an object in an object editor to the SQL Editor for execution.

CR#162373

You can now generate an SQL script for altering views, stored procedures, and UDFs by right-clicking an object and selecting Generate SQL | To location | Alter Script.

CR#201033

For most objects, you can only open one object editor at a time.

CR#186004

Tables

When adding a column with a uniqueidentifier as the data type, and setting IS RowGUID to TRUE, newid() is no longer quoted in the generated script.

CR#192388

When adding a column, you can now specify precision, scale, and length values in the parenthesis for the Type column in the Table Column List.

CR#194767

Occasionally, the focus in the Table Column List changes to the previous row; and you may change properties for the previous row rather than the current one.

CR#194772

Tables that have the same name as a keyword, such as CASE or GROUP no longer display an error when browsing data from the Data tab. 

CR#195851

You can now unbind a column from a rule when the table owner is not "dbo."

CR#142201

Indexes with Included Columns are now supported

CR#200635

Setting a data filter for multiple tables, and then selecting the data tab on those tables repeatedly no longer results in an error.

CR#192550

Programmability -UDDTs

CLR user-defined data types are now supported.

CR#171053s

Databases

(Database Browser Only) The correct database size now displays in the Properties tab.

CR#179229

Activity

You can now view a complete list of processes; and can sort, filter, or group those processes under the Activity category. You can also view the Last T-SQL Command Batch and any locks from this category.

CR#180355

Debugger

In SQL Server 2000, if the code contains a blank line or comment before the CREATE PROCEDURE block, the Debugger now indicates breakpoints correctly.

CR#216036

Editor

Loading a script in some environments no longer results in an argument was out of range error.

CR#188451

CR#194961

Using the shortcut key (CTRL+SHIFT+MINUS) to uncomment a comment line no longer results in an error.

CR#192545

If you copy data to the clipboard and then paste it into the editor, a blank line is added after each line.

CR#193046

Formatting 100+ lines of code that have been copied and pasted into the Editor no longer causes Toad to hang.

CR#194963

You can now use the same parameter name more than once for multiple tables in a query.

CR#163853

You can now query tables that contain decimal data types with a precision or 29 or greater.

CR#195496

Dragging-and-dropping objects from the Database Browser/Object Palette into an editor window now places the objects in the order they were selected.

CR#211702

ER Diagrammer

You can now save ER diagrams without causing an error.

CR#195495

Export Data

When exporting data that contains more rows than set to fetch initially (default is 1000 rows), you are now prompted to read all rows before exporting.

CR#189392

Filtered data is now exported correctly.

CR#193542

When exporting data as INSERT statements, the name you specify in the Object field under Script Options now persists.

CR#192874

Import Data

When importing data, Toad now verifies that the end of a field is followed by a delimiter, a carriage return or linefeed, or an end of file.

CR#197128

When importing data, the wizard now defaults to the current database.

CR#210436

Log Reader

You can now read more than one log file at a time.

CR#206238

When reading the online transaction log, clicking Refresh no longer results in an error.

CR#189933

If a database was backed up with the Overwrite option set to Append to media, the Log Reader can now read any appended changes.

CR#192659

When filtering entries using the Show only selected option, clicking Clear now clears all selected entries.

CR#203097

Master Detail Browser

You can now specify an alias for a table or view by double-clicking the name of the table/view in the Diagram panel at the top of the window.

CR#203102

Options

An unauthorized access error no longer displays when using the Search feature on Options pages (Tools | Options).

CR#211202

Query Builder
(SQL Modeler)

The drop-down menu in the Form tab of the Where Condition window now includes "IS NULL" and "IS NOT NULL".

CR#185054

Schema Compare

Users with different names that share the same login are now synchronized correctly.

CR#103387

Schema Reports

When generating a report, an error no longer occurs if “Include Properties” is selected in the Default Settings panel.

CR#186238

SQL Tuning

For a list of resolved issues and enhancements, see the SQL Tuning release notes.
 

N/A

Feature

Known Issue

Change Request

General

Customized options selected in the Configuration wizard are not applied if you are running Toad as a Restricted user.

Workaround:
Customize these settings in the Options pages in Toad (Tools | Options from the menu).

CR#216699

Installation/ Upgrades

If a power user upgrades Toad, installation "Error 1406. Could not write value DisplayIcon to key..." displays. This issue occurs because the user does not have enough privileges to update the DisplayIcon entry in registry. You can safely Ignore this error; however, an incorrect icon may display for Toad in the Add/Remove Programs window.

CR#222728

Connections

If you are connecting to a local database, using "(local), <port #>" in the Server name field results in an error.

Workaround:
Use one of the following methods for the server name:

"localhost"

"localhost, <port #>"

"., <port #>"

CR0218603

Data Compare

Quest recommends limiting compares to 20000 rows in tables. When using Data Compare on large databases, Quest recommends excluding tables with large data sets from the comparison

CR#142208

You can compare views, but you cannot synchronize them.

CR#166497

Data Grid

When adding data to a column that has an Identity Increment value, Toad cannot determine the increment value on the client side and an error occurs if you do not enter a value for the column.

Workaround:
Enter any valid value in the identity column, and then press F5 to query the server for the correct value. This replaces the placeholder value you entered with the correctly incremented one.

CR#117786

Data Reports

Currently, you cannot create a Label Report in the Toad Data Report wizard.

CR#215945

Database Browser/ Object Palette

(Database Browser only) The Deps (Uses) & Deps (Used by) tabs display as empty if an extended stored procedure is used.  

CR#117189

Tables

If you alter a table and rename a Primary Key column that is referenced by a Foreign Key, the Foreign Key still references the original column name.

Workaround:
Manually update the column name for the Foreign Key in the SQL Script page of the Alter Table window.

CR#212357

If an existing table includes a column with a bind default, attempting to use Create Like to create a table on a database that does not already include the default results in an incorrect script being generated.

Workaround:
Manually edit the script on the SQL Script page before clicking OK.

CR#215934

(Database Browser only) You cannot unbind a column from a rule using the Unbind Column from Rule toolbar button.

Workaround:

1. Alter the table.

2. Select the bound column in the Columns page

3. Remove the bound rule from the Rule Binding field.

CR#216532

Databases

When generating a DDL script for databases, the following objects are not included in the script:

• Application roles

• Schemas

• Synonyms

CR#216490

Currently, you cannot drop a database if you are connected to it.

CR#211896

After backing up a database, you must press F5 to update the icon/status.

CR#213716

(Database Browser only) You cannot drop a database if you:

• First select any tab in the right-hand side of the Database Browser other than the Properties tab, and then attempt to drop that database.

• Click Cancel while altering the database, and then attempt to drop that database. 

Workaround:
Disconnect and then reconnect your connection and drop the database.

CR#211896

Debugger

You cannot debug stored procedures with the following input parameters in this release:

• Binary

• Varbinary

• Bit

• Timestamp

• Image

CR#133602

CR#133634

CR#133636

In some environments, the result set returned by a stored procedure called by another stored procedure is inserted into a table; however the table definition has varchar columns that are not long enough. This results in an error message stating, "String or binary data would be truncated" and data is not inserted into the temporary table.

Workaround:
Increase the size of the varchar columns in the temporary table.

CR#211704

Editor

The following object types are not found when using the View Object at Cursor (F4) feature:

• Triggers

• Procedures

• Functions

• Users

• Hosts

CR#164917

Export Wizard/ One Click Export

Binary data types cannot be exported in this release.

CR#170430

When exporting large results sets (approximately 500K), you may run out of memory before the operation completes.

Workaround:
Create a view for the query and export using that view.

CR#203483

Exporting more than 65,536 rows to an Excel 2007 instance causes an error.

Note: This issue does not affect Excel 2000 or 2003.

CR#211832

Import Wizard

Currently, you cannot import Excel 2007 files because they are saved using an xlsx format.

Workaround:
Save the Excel 2007 file as a 2003 compatible file before importing it.

CR#221667

Currently, selecting more than one file to import causes Toad to hang.

Workaround:

Import each file individually.  

CR0220341

Log Reader

EXEC sp_addextendedproc 'xp_qlr_loginfo', 'xp_QuestLogReader.dll'

CR#216499

Schema Compare

Default constraints, check constraints, foreign keys, and case differences display in schema compares even though you select options to ignore them on the Compare Options page (Tools | Options | Schema Compare | SQL Server | Compare).

CR#215192

CR#212297

CR#212301

Schema Report

On SQL Server 2005 only, generating a Schema Report when the Include System Objects and Include Source options are selected results in an error.

CR#223188

Server Compare

When running MSDE 2000, attempting to retrieve information from DTS Packages may result in a "General Repository Error: 80041035."

CR#142205

If the target server is configured with Use Windows NT Fibers, you cannot synchronize Meta Data Service Packages.

CR#142206

If the Meta Data Service DTS Packages contain a COM object that is not registered on the target server, you may receive an exception error during synchronization.

CR#142207

Currently, you cannot rollback Meta Data Service DTS Packages.

CR#122712

SQL Tuning

For a list of known issues, see the SQL Tuning release notes.

N/A

Version Control

Toad is providing a more in-depth integration with popular VCS vendors. Currently, Toad has integrated version control with Visual Source Safe. If you are using CVS or SCC as the provider from the previous release of Toad, you currently cannot use those providers in Toad at this time. Also, you may not want to migrate settings to the current release.

N/A

The Update Database function for version control often requires that objects be dropped and recreated. If tables are referenced by Foreign Key constraints, the following error occurs when executing the script:

"Could not drop object N because it is referenced by a FOREIGN KEY constraint."

CR#214601