Toad® for SQL Server® 6.8

Beta Release Notes

May 2017

Version 6.8 (Click here for previous versions)

These release notes provide information about the Toad for SQL Server release.


New Features

Resolved Issues and Enhancements

Known Issues

Third Party Known Issues

System Requirements

Product Licensing


Getting Started

About Us

About this release

With Toad, developers and database administrators can use a familiar, proven tool to manage databases. Toad empowers developers and administrators, of varying skill levels, to rapidly create and execute queries, automate database object management and develop SQL more efficiently.

Toad also provides utilities to compare, extract and search for objects, manage projects, import/export data and administer the database, while increasing your productivity and delivering access to an active user community.

New Features

New Features in 6.7

Health Checks and Spotlight Developer

Monitoring of your SQL Server instances and health check analysis has moved from Toad for SQL Server to Spotlight Developer. Spotlight Developer is a free tool which you can download from the Spotlight Essentials web site. To open Spotlight Developer from within Toad for SQL Server, click Tools | Monitor | Spotlight Developer.

Query Development

Populate Where Clause with Values from File

If you are using IN or NOT IN in a WHERE clause, you can now load multiple values from a .txt, Excel, or .csv file.

Display Multiple Results in a Single Grid

Background Processes Icon

Database Management

Data Compare


Send Email Activity - Authentication in Non-SSL Connection

Send Email Activity - Use Wildcard Characters to Select Attachments

Data Compare Activity

Run Program Activity


Passive Mode is Available for FTP Connections

Import and Export

Export Wizard


Page Setup

The Library

This release includes a new interface for organizing and accessing your Toad files—the Library.

Version Control for Files

This release has re-implemented version control for Toad files. Toad can integrate with your existing version control system allowing you to manage multiple versions of Toad files.

New Features in 6.6

Test Data Generator

Use the Test Data Generator to generate realistic test data to load into your databases.

  1. To open the test data generator click File | New | Data Generator

  2. Create a Test Data Generator project.

  3. Set the scope of the project by setting the Toad for SQL Server connection and database schema.
  4. In the test data generator window:
    1. Test data is generated for ticked tables and columns,
    2. Select a table or column,
    3. Set the settings for that selected table or column,
    4. Preview and edit test data,
    5. Generate test data,
    6. Further configure and export.

Query Development

Background Processes

Analyze Joins

Sort Columns

View PDF Files in LOB Viewer


Throw Error Activity

Automation Reports and Container Activities

New Features in 6.5

Health Checks, Spotlight® Essentials and the Diagnostic Server

Health Checks

Show health check results. Click Tools | Health Check.

Toad connections from the Connection Manager with health check results available are listed.

Connections needing the most attention are listed first. Click on the connection to open the System Health check page on the Spotlight Essentials web site. This provides a detailed analysis of the health checks performed.


Spotlight Essentials

A Spotlight Essentials account is required to check the health of your Toad connections. Registration is free.

Click Tools | Options | Spotlight Essentials | Setup Account

Spotlight Essentials is an online service: Visit the web sit for a thorough analysis of all your connections.


Diagnostic Server

The Diagnostic Server enables performance data from your Toad connections to be sent to your Spotlight Essentials account for analysis. The Diagnostic Server needs to be installed and configured.

Click Tools | Options | Spotlight Essentials | Configure Diagnostic Server

Performance data is uploaded hourly to Spotlight Essentials - providing the Diagnostic Server is operational. You can check the current status of the Diagnostic Server from the Toad Status bar. Select Show Details on the status bar for the current status of the Diagnostic Server and possible solutions to any issues.


Spotlight Essentials - Configure Connections

Manage the connections that upload data to Spotlight Essentials.

Click Tools | Options | Spotlight Essentials | Configure Connections

This screen lists all the connections that are uploading performance data to Spotlight Essentials Add, remove and modify the connections on this screen. Note that this list of connections is stored with the Diagnostic Server. It is available only while the Diagnostic Server is connected and running. If you change the Diagnostic Server host then this list of connections will also change.

There is a simple way to add Toad connections from the Connection Manager to this list. In the Connection Manager, right click the Toad connection and select Add to Spotlight Essentials.

SQL Server 2014 Support

SQL Server 2014 is supported for all existing functionality of Toad.

New Look User Interface

Toad for SQL Server has a new look. This release includes a sleek new design for the main toolbar, as well as a few user interface enhancements designed to simplify your Toad workflow.

Database Administration

Object Explorer

Filtering database objects has several new enhancements.

Connection/Navigation Manager


Zip/Unzip Activity: You can now unzip existing zip files using the Zip/Unzip activity (formerly the Zip activity).

New Features in 6.1

Database Administration

Object Explorer

Object Management

Connection Manager

Query Development



New Features in 6.0

Data Management

Schema Compare

Toad allows to run Schema Compare against multiple targets.

Data Diff Viewer

Data Grid, Result Sets

Toad allows to view multi-line text as one-line separated by spaces so that you can see all information contained in the grid right in front of you. Right-click a data grid and select Show | Multi-line text as one-line. When this option is cleared, to view multi-line text you have to hover a mouse over a data grid cell or expand it.

Multi-Line as One-line Example



Data Compare

Database Administration


Toad now allows to search through the script not only in the Editor window but also in SQL Script page of object's DOE (Database Object Editor) and Script tab in the object's DOV (Database Object Viewer). This feature can be handy when reviewing large automatically created DDL scripts. Press F3 or CTRL+F to invoke a search pane.

Object Explorer

Object Management

Connection Manager

Toad provides possibility to import connections from Central Management Server. Now to add CMS connections to the Connection Manager pane you click Import Connections in the Connection Manager toolbar, select Central Management Server as import origin and specify connection from the list. Select Connections and Groups page of the Import Wizard displays a list of available connections, including CMS. You can either import the entire CMS Connections group or single connection.


Toad provides more security options when creating users in Contained databases (SQL Server 2012 only).

Service Broker

Service Broker has been completely redesigned and now can be configured for MS SQL Server 2005, 2008, 2008 R2, 2012. Service Broker allows to set up communication between databases on the same SQL Server instance or between SQL Server instances. Take advantage of secure, reliable messaging with Service Broker in Toad. Invoke Service Broker with Tools | Administer | Service Broker, select a database from the list and click Configure to enable Service Broker.

In the Endpoints tab you can either configure an endpoint for the current SQL Server instance or configure both source and target endpoints using the Transport Security Wizard.

To create Service Broker objects (e.g. message types, queues, notifications, etc.) select a corresponding tab in the lower part of the Service Broker window.

Storage Management

Storage Management has been significantly improved to become more user-friendly and easy-to-use. Select Tools | Administer | Storage Management to invoke it. In the Drives tab you can review information on free disk space and database parameters (size, total writes, total reads, etc). Click on the drive icon to see the list of databases located there. To move a database to another drive just drag it to drive's icon, specify new location on disk drive and follow the instruction in the pane below.

Toad Plug-in for Microsoft SQL Server Management Studio

Toad provides a plug-in that integrates Toad features in Microsoft SQL Server Management Studio. Enjoy advantages of both products and ease of communication. Toad Plug-in is installed as a part of Toad for SQL Server installation process and supports the following versions of Management Studio:

Toad Plug-in allows to invoke key Toad features right from the Management Studio context menu and send data directly into Toad. Connection information and security settings are transferred automatically and Toad functionality is already up&running.

According to the Toad Edition you run the following Toad features can be invoked from the Management Studio:

Query Development


Script Results


Schema Compare and Data Compare Activities


This release of Toad for SQL Server includes many new enhancements to Automation variables. Automation variables are now more flexible and easier to use. Toad for SQL Server has expanded the number of places you can use variables in an Automation script.

Loop Dataset Activity

Set Variable Value Activity

Loop Connections Activity

Copy File and Delete File Activities

Automation Guided Tour

General Automation Enhancements

This release also includes several general enhancements to Automation activities.


Toad includes significant enhancements to Automation that affect attributes in the actual automation script. If you open an automation script from a previous version, a message informs you that the script will be upgraded so it will work in the current version of Toad.

Caution: If you upgrade this script, it will no longer be compatible with previous versions of Toad. However, a backup copy of your script will be saved in the Automation\bak folder in the Application Data Directory under Help | About.


Validation Error Icon

If you choose to upgrade an Automation script created in a previous version of Toad for SQL Server, after opening the script, look for the validation errors icon.

Expressions Used in Automation

Some expressions might break in this release of Toad for SQL Server. For example, if you used a variable in an expression, you must now surround the variable name with the hash (#) symbol (#MyVariable#).

Idea Pond

Idea Pond is a site where you can submit your ideas to improve Toad and vote or comment on other people's ideas. Toad's development has always been driven by our customers, and now it is even easier for you to tell us what changes are most important. This site is free for all customers.

Back to Top

Resolved Beta Issues and Enhancements

Resolved Issues and Enhancements in 6.7

The following is a list of issues addressed and enhancements implemented in this release.


Resolved Issue

Defect ID

Object Explorer

Corrected a problem where in Object Explorer, clicking Refresh from a parent node in the tree failed to display newly created child objects to that parent. (databases for example)

Fixed an issue showing the connection category color in Object Explorer. 1144
Database script

Corrected a problem where the file name of a data file added to a database from the Files tab was incorrectly named in the database script.

SQL Server 2012 / 2014 Importing connections from the SQL Server Management Studio is now supported for SQL Server 2012 and later. 757

The SQL Debugger Setup Wizard is now supported for local and remote SQL Server 2012 and 2014 SQL instances.


Permissions are now corrected for SQL Server 2012 and SQL Server 2014 connections.


Corrected a problem where securables were not shown on a database role.

Build DDL Script

Corrected Build DDL Script Connection Error.

Import Wizard Corrected a problem where the text was difficult to read on the Import Finished > Import data summary results dialog from the Tools ->Import ->Import wizard. 1075
Toad Editor

On typing the Use command in the Toad Editor, code completion now wraps database names in brackets by default.

Schema Compare Schema Compare summary no longer reports differences in the constraint name when the ignore option is selected. 1057
Corrected a problem comparing two databases where one database included a procedure with a server link. The problem caused a Script Execution Error 1208

Corrected a problem comparing two tables where the script failed on adding multiple defaults to a column.


Corrected a problem comparing two tables where the script failed on adding a foreign key constraint twice.


Corrected a problem where the instruction to print from the Server Compare Tab caused an exception.


Enhanced Schema Compare reports with the checked / unchecked state of each object.


Enhanced Schema Compare with a Schema Report that is viewable outside of Toad for SQL Server.

View Details of Jobs

Exception on View Details of Jobs is now corrected.



Exception - Specified cast is not valid - on opening View Detail | Script of a SQL Agent Job is now corrected.

Exception on opening the storage tool is now corrected. 1167
View Details for database user

Corrected Collation conflict for a database user on View Details | Securables: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "French_CI_AS" in the equal to operation.

Tables Corrected a problem where View Details on a user-defined table type showed an exception. 1129

Corrected a problem entering data into a table (data grid), on entering a number into a column in time format the column value showed in date time format.


Corrected a problem where the generated scripts on the Script tab failed to detect changes following Alter a column data type or Table Properties.


Exception corrected on Profiling tab for a table that contained string values that were numeric except for values that contained nothing but spaces.

Corrected a problem when creating indexes from the details view of a table where the index creating dialog hung. 144
Query Result set

As an enhancement, you can now use Toad to display results from more than one query at the same time when multiple queries are selected and run. This makes for easy comparison between results from two different queries / tables.

Excel Import / Export

The Multiple Excel Instances Available dialog is re sizable to cater for long filenames. To open this dialog when multiple Excel spreadsheets are open: Select a table in Object Explorer -> right click ->View Detail ->Data Tab page > right-click a result set in Toad and choose: Quick Export > Excel Instance > Excel Instance At Active Cell.


Corrected a problem where Import text from Excel (column type nvarchar(50) or text) failed and showed null in data grid.


Resolved Issues and Enhancements in 6.6.1

The following is a list of issues addressed and enhancements implemented in this release.


Resolved Issue

Defect ID

Schema compare Corrected an issue comparing tables where the column sort order setting was ignored. 245
Corrected problems in the order in which objects were created on synchronizing databases that resulted in execution errors. 271
Corrected problems in the order in which objects were dropped and created to remove the risk of name conflicts when Make target like source. 932
Corrected an error in the script generated when comparing tables - if the tables differed only in that one had more indexes than the other, then the tables would incorrectly be reported as the same. 834
New Refresh Compare (F5) button to refresh the schema comparison result. 1012
Corrected an issue where the selection of objects in the Schema Compare project was not always remembered. 1010
General Fixed an issue where Toad shutdown on canceling a running script. 985
Code Completion Corrected a problem where in a multi screen environment the correct operation of Code Completion depended on the monitor in use. 717
Corrected a problem when using Code Completion on an inner join. 913
DDL Script Corrected the generated DDL - Now added the schema name to the foreign keys clause. 925
Database The script generated when restoring a database in single user mode has been corrected to include scenarios where the database does not exist or was previously dropped. 1006
Discovery Wizard Discovery wizard now shows the product version and SP number for SQL Server 2012 and above. 1009
Service Manager Fixed an issue where Toad shutdown on starting a database service on the localhost. 947
SQL Azure Connection On executing SQL the Execution Plan is now visible through SQL Server Azure. 1050
Object Explorer Corrected a problem where on removing a Filter on a View in Object Explorer the filter continued to be applied. 830
Alter Table Fixed an issue where on altering a table through the user interface, foreign keys were dropped but not recreated. 986
Corrected a problem where on using a third party version control system and requesting Get Latest Version on a table with status unknown, a script was generated to drop and create the table. 938
Corrected a problem where a foreign key\check constraint was incorrectly enabled on generating a script for the table. 1015
SQL Editor Corrected a problem where on generating an INSERT statement and adding it to the SQL Editor, an error in the syntax was incorrectly reported. 738

Resolved Issues and Enhancements in 6.6

The following is a list of issues addressed and enhancements implemented in this release.


Resolved Issue

Defect ID

Data Type

Added the bit data type to Tools | Options | Environment | Grid | Data Type Formatting. Bit data type values are displayed as 0 or 1 in the grid and exported as 0 or 1.

Log Reader Corrected a problem where for backup online transaction logs in the Log Reader the user information associated with the transaction was blank. 769
Schema Compare Corrected an exception where On database | Get Schema Compare Snapshots, in the Schema Snapshot Wizard "run background tasks for snapshots" was selected. 761
Editor Corrected a problem that gave rise to an exception error when the editor was closed when group execute was enabled. 735 / 719
Verify SQL Corrected the case where lookup errors were raised on Editor | Verify SQL containing the CREATE PROCEDURE statement. 703
Alter Table Corrected a problem where altering the column data type of a table also altered the constraint name. 622
Table Viewer Corrected a problem where on selecting to view details of a table, then in the table viewer selecting the Script tab, gave rise to a SQL Server Database Error. 616
Corrected a problem in the table viewer when rows were added / removed and the Rowcount did not change on refresh. 705
Options Corrected a problem with the Environment | Keyboard | Editor | Clipboard option CycleClipboardRing where unnecessary style information was added. 24
Database Details

Added the "Encryption" setting to the view of database details.

Code Completion Added code completion to automatically alias for a table. 601
SQL Corrected a problem in the SQL generated by Toad when a constraint was removed and that constraint had "." in the name. 645

Corrected a problem in the SQL generated by Toad on adding a field description to a table with the MS_Description extended property. The field's MS_Description property was listed twice.


Resolved Issues and Enhancements in 6.5

The following is a list of issues addressed and enhancements implemented in this release.


Resolved Issue

Defect ID

Options Fixed a problem where Options | Extensions | SQL selected and .sql files still opened in SQL Server Management Studio. 288

Fixed a problem where for Generate SQL | Data Script options "Generate use <database> and Use Transactions were synched.

Script Generation Fixed problem where generate DDL script fails "Object reference not set to an instance of an object" and script permissions are set in Export DDL Options. 282
Have separated the "Disable constraints" option into two options: "Disable foreign key constraints" and "Disable indexes". 155
On Generate SQL | Data Script when constraints are disabled, fixed a problem where Foreign key constraints were not dropped. 140
On Generate SQL | Data Script, multiple scripts, fixed a problem where an incorrect message was displayed at end of data creation. 139

On Generate SQL | Data Script, fixed an error with options "Script Tables" combined with "Schema Qualify", and "Use Transactions".

Database | Security | Users | Script - Fixed a problem where 'G' for "Windows Group" was missing. 289
Pivot Grid Windows 8: Fixed a problem with "Show Field List" on the Pivot & Chart page. 440
SQL Editor

Fixed "Quest.FastData.FastDataException" on SELECT * FROM table

Object Explorer

Fixed the problem that caused the SQL Server Database Error: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_CI_AS_KS_WS" in the UNION operation.


Fixed a problem when on "Tasks | Attach a database" the files associated with the database do not show.


Fixed a problem where refresh of Object Explorer did not show a newly created database.


Fixed a problem of slow loading tables in Toad 6.1.

Fixed a problem setting VarChar/Nchar Input Parameter Size Changes. 157
Fixed a problem where "The user does not have permission to perform this action" shows for tables where the user does have view server state permission. 199
Fixed a problem where on altering a table and the table needed to be rebuilt some extended properties were lost. 146
Connection Manager Resolved Toad Exception error on Import Connections Wizard | Central Management Server for connections in a group. 221

Resolved Toad Exception error on Import Connections Wizard | Central Management Server while connected to an instance.

Job Management Fixed a problem where Toad sometimes crashed on Alter Job, Send to | Editor or Open DOV | Schedules. 195
Version Control Password to Version Control now hidden on Output window. 274

When using TFS: Fixed Access Denied error on Get Latest Version of scripts; fixed a problem where new scripts are now saved in the TFS working folder.

When using SVN: Fixed a problem where object has "merge status" when no changes have been made. 202

Resolved "Working directory mismatch" error on migrate from 6.0 settings and commit.

Code Completion

SELECT CASE...(WHEN...THEN) now supported by Code Completion.

Export Wizard On exporting from SQL Query | Result Sets, format SQL script, fixed a problem entering/selecting Script Options. 383

On exporting from Stored Procedure | Result window, fixed the problem that resulted in the error "Incorrect syntax near the keyword 'Declare'".

Schema Compare and Sync Fixed the issue that resulted in the error "Object reference not set to an instance of an object" on running Schema Compare. 124
Fixed a problem with the "ignore fill factor" option in Schema Compare. 52
Session Browser

Fixed a problem where on upgrade the Session Trace facility became disabled.

Fixed a problem where in a multi user environment the Session Browser failed to show a reconnected session. 208
Schema Reports In the Schema Compare Report the Target / Target name now displays correctly. 201

Fixed Toad Exception error on closing the Filter Databases window.

SQL Editor Fixed a problem where dependent on the cursor location, F9 executes all SELECT statements. 173
Object Editor (DOE)

Fixed a problem when formatting the script with a custom formatter, set comma to trailing.

Data Compare & Sync Fixed a problem with the Disable Triggers option during Data Compare. 126
Data Grid Fixed a problem where for a table that has a PK which generates its own unique # an inserted row sometimes does not save. 122
Fixed a problem where the CTRL+F short key was not working in the data grid of the Table viewer. 55
General Resolved the problem behind the error: "Cannot drop the user because it does not exist or you do not have permission." 56

Fixed the link to Cloud Computing | SQL Azure Portal.

Compare Object Fixed a problem on the toolbar where Server Compare was missing when no connection. 213

Resolved Issues and Enhancements in 6.1

The following is a list of issues addressed and enhancements implemented in this release.


Resolved Issue

Defect ID

Connections You can now add parameters to a SQL Server Connection in the Connection Properties dialog. ST109376
Database Explorer When viewed in the Database Explorer, Partition Functions now include a Dependencies tab. TSS-34
Debugger Resolved various Debugger issues. TSS-4, ST110043, ST109824
Editor You can now execute only a region (between "region name" and "end region") of your script by right-clicking within the region and selecting Select Current Region. Then press F5. ST110144, TSS-21
Editor If you select to include the actual execution plan when executing SQL, the tab in the Execution Plan window now reads "Actual Plan." TSS-26
Editor Null values now display in a consistent format in the Results tab. ST96379
Editor An issue that caused a "System.ArgumentException" error when selecting the Execution Plan tab in the Results pane of the Editor has been resolved. ST108504
Editor You can now easily add the generated SQL statement or script to the Editor at the location of your cursor within the Editor pane by using the Generate SQL menu item. ST109599
Editor Code completion now correctly displays the items list after a "SELECT TOP N | FROM [schema].[object_name]" query. ST110127
Editor Syntax highlighting now works as expected with scientific notation using the character "E" ST110376
Explain Plan Toad now shows missing indexes in the Execution Plan. ST72511
Export During Quick Export to Excel, data with TinyInt data type is exported as expected (not as a null value). ST86688
General Enhancements to the Document Recovery Manager. ST109848
General The generate DDL Script menu item (Tools | Export | DDL Script) is now disabled when there is no active connection. ST100759
General An issue that caused an error on start-up when running multiple remote sessions with different domain users has been resolved. ST111532
Installation Toad now supports the use of temporary or mandatory profiles in a Citrix deployment. QAT-580
Installation You no longer encounter an error during installation if the SSMS plug-in that was installed with a previous version is currently open. ST109570, ST110045, ST110046
Job Manager The "Auto refresh tasks window every" option (Tools | Options | Job Manager | Advanced) now remains selected after closing and re-starting Toad. ST86083
Object Details In a Toad for SQL Server Beta release, an issue that caused an error when attempting to edit a Login has been resolved. TSS-15
Object Details The Constraints tab of Object Details (Viewer) now correctly displays the property "Trusted." ST107824
Object Explorer When an object node other than a Database node is selected, filtering now works as expected. TSS-5
Object Explorer The following issue has been resolved: The Alter Table dialog does not close and apply specified changes as expected after clicking OK. TSS-35
Object Explorer Alter Table dialog now includes multi-select on columns. ST107528
Object Explorer The Table tab in the Object Explorer now includes a "Last Updated" column. ST101348
Report Toad saves the user's previously-specified print settings and applies them automatically the next time the user prints a report. ST103581
Schema Compare and Sync An issue that caused a "System.ApplicationException" error when attempting to generate a sync script has been resolved. ST110275
Script Generation In a script to restore database with transaction logs, the STOPAT statement is now included. ST110181
Script Generation The restore log statements are now in the correct sequence in a script to restore database with transaction logs. ST110182
Version Control Toad now supports Subversion 1.8. ST110531
Version Control An issue that caused an "Out of memory" error when attempting to refresh version control states with a database of more than 2500 objects has been resolved. ST110138


Resolved Issues and Enhancements in 6.0

The following is a list of issues addressed and enhancements implemented in this release.


Resolved Issue

Defect ID

Code Completion The columns with ROWVERSION/TIMESTAMP data type is no longer included in the INSERT INTO (...) SELECT (...) code snippet.


Data Grid "Use locale-independent format" option now works for DateTime, Number data types. ST106316
Fixed issue with not being able to clear data filter.


Fixed issue "Applying a column filter on a Bit data type generates exception". ST104886
Fixed issue "Unable to cancel pending update in case of locked table". ST104287
Fixed issue "Cannot copy&paste data from one DATETIME column to another". ST105542
Diff Viewer Various fixes and updates (including fixing misaligned comparison, case sensitive comparison, scrolling synchronization, etc.).





ER Diagrammer Fixed issue "Exception occurs on establishing new connection after "Object Annotation Cache" folder was moved". ST98395
Filtering Fixed various issues with filtering (filtering by owner, multi column filtering).



Fixed issue with object count changes when switching between the tabs provided the regular expressions are used. ST103359
Import Wizard Fixed issue with not being able to import data from text delimited file on SQL Azure. ST108806
Job Management Fixed issue with incorrectly displaying 31 month jobs in Calendar.


Object Details (DOV) Alter Table: Fixed issue with Columns and Data tabs not being refreshed after adding a primary key.


Fixed issue "Cannot see the database properties for the specific database more than 1TB because Arithmetic overflow error". ST108052
Object Editor (DOE) Alter Table: Changes can be applied to more than one constraint. ST104230

Fixed issue "Incorrect script is generated when editing permissions for not master database. USE MASTER statement is generated instead of USE <current database>".

Windows Server 2000: Fixed issue with not being able to DROP LOGIN.


Alter Table, extended alter: Fixed issue "FK recreation is missing in the generated script". ST107576
Object Explorer Fixed issue "Unable to Drop Synonyms from the Object Explorer". ST105807
Fixed issue "Row Count extra column doesn't disappear after being unchecked".


Fixed issue "Switching between the tabs in Tabbed Multiline mode leads to System.NullReferenceException". ST106057
Fixed issue "Create Object action is disabled if Object Explorer toolbar is disabled". ST101731
Query Builder Fixed issue "Incorrect script is generated for queries containing aliases with more than one word".


Schema Compare & Sync

Fixed issues with printing schema reports.



Fixed issue "Toad fails to open user's Schema Compare snapshot".


Additional logging is implemented. ST107318
Fixed issue "System.ApplicationException appears when comparing databases with keys". ST107093
Fixed issue "Schema Compare fails on Windows Server 2012 with particular permissions settings".


Fixed issue with some items disabled in the pop-up menu when viewing snapshots. ST83639
Fixed issue with opening synchronization script in the Editor for the wrong connection. ST91542
Fixed issue "No differences are marked when comparing long stored procedures". ST98597
Fixed various issues with Snapshot Viewer. ST102813
SQL Azure: Fixed issue "Schema Compare doesn't work if user has only connect database grant". ST106376
Fixed issue "Incorrect status of progress bar during sync script generation". ST108500
Schema Reports Fixed issue "Schema Report: System.NullReferenceException occurs when generating the report".


Script Generation Fixed issue "Generate Insert Statement contains timestamp columns".


Fixed issue "Extended alter script generates for about 3-5 minutes on complex table".


Restore database syntax was improved.


Fixed issue "Generate Data Script saves file with doubled BOM that leads to inconsistency of data". ST107816
Script Results GO with count statement is supported in Toad.


Service Broker Service Broker now supports SQL Server 2008. ST60874
Service Broker now supports SQL Server 2012.


SQL Editor Fixed issue with incorrect formatting for identity columns.


Fixed issue with recognizing labels as incorrect syntax.


Improved format style for joined tables.


Improved format style for Drop Index syntax.


Fixed issue with exception occurred when trying to open customer's script. ST103259
Version Control Fixed issue with not being able to commit functions with inline table-valued syntax. ST107889
Fixed issue "New active task appears when Commit window opens even if commit is not initialized".


Known Beta Issues

The following is a list of issues known to exist at the time of this release.


Known Issue

Defect ID

Startup/ Installation

(Windows Vista on Toad client only) If you initially start Toad when logged in as a standard user and enter a license key, the license key should be saved to:

C:\Program Files\Quest Software\Toad for SQL Server 6.8

However, a standard user does not have write privileges in Vista to C:\Program Files so the key is saved to the following directory instead: C:\Users\username\AppData\Local\VirtualStore\Program Files\Quest Software\Toad for SQL Server 6.8

If you later start Toad as an administrator, you are prompted to enter the key again because it is not in the C:\Program Files directory.


If intending to hibernate the machine with the open connections to the servers that might be unavailable at the next startup, it is recommended to disconnect first due to risk of data loss. N/A

When installing Toad using Quest Installer on Windows 7 64-bit, Program Compatibility Assistant may appear with “This program might not have installed correctly” message.


Select This program installed correctly to continue installation. For more information, see


Code Completion Code Completion provides limited syntax support of SELECT * INTO clause. ST87112
Connection Manager

Cannot establish Named Pipes connection if "Poll service status in connection list" option is selected.


Clear "Poll service status in connection list" checkbox on the Tools | Options | Database | General page.

Data For some queries, attempting to right-click a row and select Row Count results in a message stating that the row count could not be determined. N/A
Performance Monitor You may encounter an exception in the Performance Monitor during recording: in the Object explorer expand and collapse a tables list. 930
You may encounter an exception when using the Performance Monitor and Session Browser at the same time. 948
Schema Compare When the Ignore column order option is not selected two tables are incorrectly reported to be equal. 245
The script comparing two databases where one database is empty has execution errors. 271
The script synchronizing two databases that have the same table with different index is incorrect. 834
Debugger You may encounter some issues when debugging remotely. ST82044
Editor Toad may hang after applying Short Format Uppercase Keywords or Short formats to large scripts.


Execution Plan

You cannot generate an estimated execution plan for queries containing local temporary tables because the execution plan uses a different connection to generate the plan and does not know about the temp table.

Use the actual execution plan button to generate execution plans for SQL that contains a temp table.

Export Wizard/ One Click Export

Limitations when exporting fractional seconds:

  • When exporting to an Access Database File, exports do not support fractional seconds, so the additional data is not exported.

  • When exporting to an Excel instance, exports support only 3-digits for fractional seconds. However, if you export to an Excel file, it supports all fractional seconds.


Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit.


Job Manager SQL Azure connections currently display in the Job Manager even though the Job Manager is not available for SQL Azure. ST75721
Log Reader User information only displays for operations in the sessions that are currently open. Backups do not contain this information because only the SPID information is available to them.


SQL Azure connections currently display in the Read Log wizard even though the Log Reader is not available for SQL Azure. ST75720
Object Explorer/ Database Explorer

Table and Index Partitioning:

  • Currently, you cannot create or manage a partition on a table or index that includes a FileStream column.
  • Currently, estimating index compression savings runs a full table compression savings query, so the estimation may be slow on large tables.



FDCC: User cannot start/stop SQL Agent running Toad with Regular or Admin User account on the client side in some limited environments.


Start the SQL Agent on the server side.


Third Party Known Issues

The following is a list of third party issues known to exist at the time of this release.

Feature Known Issue Defect ID

In the following environment, Microsoft .Net Framework 4 installed on Windows 7 or Windows Server 2008 R2, some users may experience that Toad unexpectedly closes while running certain Automation scripts. After the application closes, a "Toad has stopped working" message displays. You may also encounter this issue if you close Toad immediately after the successful execution of certain Automation scripts.


Install Microsoft .Net Framework 4.5.



If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at:


Export Wizard/
One Click Export

To export to an Office 2003 or 2007 Excel instance, the Office Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from one of the following locations:  

2003 PIAs:    

2007 PIAs:  


Import Wizard Importing large data sets from Excel (approximately 650,000 rows) is not recommended because of the amount of time it may take. This issue occurs because the Excel import component maintains the output in memory until the import completes. This can cause performance issues depending on the available system resources. CR#219754
Screen Resolution

Some users may experience an exception when the screen is set to certain resolutions.


Adjust screen resolution.


System Requirements

Client Requirements

Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements:

Requirement Details


600 MHz minimum, 1 GHz recommended


512 MB of RAM minimum, 1 GB recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system when using Toad for SQL Server
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

Hard Disk Space

104 MB to run Toad for SQL Server

Note: The disk space required may vary based on the edition of Toad selected for installation.

Operating System

Windows Server® 2003

Windows Vista® (32-bit or 64-bit)

Windows Server® 2008 (32-bit or 64-bit)

Windows Server® 2008 R2 (64-bit)

Windows Server® 2012

Windows® 7 (32-bit or 64-bit)

Windows® 8 (32-bit and 64-bit)

Windows® 8.1 (32-bit and 64-bit)

Windows® 10

Important: Toad uses the Microsoft® Distributed Transaction Coordinator (DTC) when opening a SQL file to get Full-Text Search status, but DTC is disabled by default on Windows Vista, Windows Server 2008 and Windows 7. If you are using either operating system, ensure that Network DTC access is enabled on the Toad client. See for more information about enabling DTC access.

.NET Framework

The Microsoft® .NET Framework is required. The version is dependent on the operating system.

.NET 4.5.1 or later Windows 10
.NET 4.5.1

Windows Vista SP2, Windows 7, Windows 8, Windows Server 2008 (SP2 or earlier), Windows Server 2008 R2, Windows Server 2012

.NET 4.0

Windows Vista (SP1 or earlier), Windows Server 2003

Note: The .NET Framework 4 Client Profile is not supported.

Additional Requirements

Web Browser

Microsoft® Internet Explorer® 6.0 or later


Toad supports screen resolutions up to 3200 x 1800 and display DPI settings up to 150%.

Copy/Move Database Wizard

The SQL Server Backward Compatibility package is required to use the Copy/Move Database wizard.

Log Reader

The Log Reader requires version 8.0 DLL files in the Microsoft Visual C++ 2005 SP1 Redistributable Package. If these files do not exist on the client, you will need to install them to use some functionality in the Log Reader.

Server Requirements

Before installing Toad, ensure that your server meets the following minimum hardware and software requirements:

Requirement Details

Database Server

Limited support of SQL Server® 2000 (Service Pack 3 or later)

Note: The following features are not available:

  • Index Defragmentation
  • Storage Management
  • Performance Monitor
  • Spotlight Essentials Performance Analytics
  • Altering procedures, functions, views in the Editor
  • Version Control

SQL Server 2005 (Service Pack 2 or later) and SQL Server 2005 Express

SQL Server 2008 and SQL Server 2008 Express

SQL Server 2008 R2 and SQL Server 2008 R2 Express

SQL Server 2012 and SQL Server 2012 Express

SQL Server 2014 Enterprise and SQL Server 2014 Express


  • SQL Server Compact Edition is not supported.
  • Storage Management is not available on SQL Server Express.

Cloud Database Service

SQL Azure

Note:  To be able to utilize a majority of Toad functionality, please grant VIEW DEFINITION on the SQL Azure databases you want to work with.

Virtualization Support

Requirement Details
Application Virtualization

Limited testing has been performed for Citrix® XenApp™ 5.0 on Windows Server 2003 and Citrix XenApp 6.5 on Windows Server 2008 R2.

Limited testing has been performed for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

Desktop Virtualization (VDI)

Toad has been tested with vWorkspace™ 7.6 running on Windows Server 2008 R2 64-bit.

Note: Toad may work in virtualization environments other than the ones in which it was tested.

User Requirements

User Requirements to Install Toad

Only Windows Administrators and Power Users can install Toad.

If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and menu items with any user—a Power User, Restricted User, Vista standard user—on the computer.

If a Power User installs Toad, a Restricted User cannot do the following:

User Requirements and Restrictions for Running Toad

The following describes the requirements and restrictions for users who launch and run Toad:

Product Licensing

The commercial version of Toad for SQL Server comes pre-installed with a trial license key for your convenience. This allows you to use the application while waiting for your commercial key to be delivered.

The trial license key remains active for the designated trial period, even after you enter your commercial license key (the splash screen may continue to indicate your application is a trial version). This is helpful if you are previewing an upgrade or an advanced module.

To enter a license key

  1. Select Help | Licensing from the menu (ALT+H+L).
  2. Review the following for additional information:

Authorization key

Enter the license key for Toad.

Site message

Enter the site message included with the license key.

Note: Your license key determines the edition of Toad (Freeware, Base, Xpert, etc.) and will enable the functionality accordingly. In many cases, if functionality is disabled within Toad, you may not have an appropriate license to use it.

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

  1. Toad for SQL Server 6.8
  2. Product Documentation, including:

Upgrade and installation instructions

See "Toad for SQL Server Installation Guide" for more information.

Note: The Diagnostic Server is no longer used by Toad for SQL Server. If the Diagnostic Server was installed with a previous release of Toad for SQL Server then uninstall that program. Use Control Panel | Programs and Features | Uninstall or change a program and select to uninstall the Toad for SQL Server Diagnostic Server.


This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

This release has the following known capabilities or limitations: No known limitations

About us

We are more than just a name

We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation.

Our brand, our vision. Together.

Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece — you — to the community, to the new Quest.

Contacting Quest

For sales or other inquiries, visit or call +1 949 754-8000.

Technical support resources

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

© 2017 Quest Software Inc.

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software Inc.

The information in this document is provided in connection with Quest Software products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST SOFTWARE ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST SOFTWARE BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest Software makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest Software does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact:

Quest Software Inc.
Attn: LEGAL Dept
4 Polaris Way
Aliso Viejo, CA 92656

Refer to our web site ( for regional and international office information.


Quest Software is proud of our advanced technology. Patents and pending patents may apply to this product. For the most current information about applicable patents for this product, please visit our website at


Quest, Quest Software, Spotlight, LiteSpeed, SQL Navigator, vWorkspace, Toad, and the Quest logo are trademarks of Quest Software Inc. in the U.S.A. and other countries. For a complete list of Quest Software trademarks, please visit our website at Microsoft, Windows, Windows Server, Windows Vista, Visual Studio, SQL Server, SharePoint, Access and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Oracle is a trademark or registered trademark of Oracle and/or its affiliates in the United States and other countries. Citrix® and XenApp™ are trademarks of Citrix Systems, Inc. and/or one or more of its subsidiaries, and may be registered in the United States Patent and Trademark Office and in other countries. Subversion is a trademark of the Apache Software Foundation. All other trademarks, servicemarks, registered trademarks, and registered servicemarks are property of their respective owners.