Toad^® for SQL Server

Version 6.0 (Click here for previous versions)

Release Notes

September 05, 2013

Welcome to Toad	New in This Release	Resolved Issues and Enhancements	Known Issues	Third Party Known Issues
System Requirements	Global Operations	Getting Started	For More Information

Welcome to Toad

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 in This Release

Data Management

Schema Compare

Toad allows to run Schema Compare against multiple targets.

Specify Source and Target Databases page of the wizard was adjusted to allow source and target objects' selection within the same pane. Click Add to start selecting objects for comparison (snapshots or databases). Or you can drag&drop objects from the Object Explorer.

Browse through the list of connections and check the objects you want to include in comparison. You can also assign colors and aliases for selected objects. Assigning aliases and colors is handy as helps easily distinguish targets.

To browse through the list of snapshots, select the Snapshots node and add a new snapshots' folder. Select the snapshots from the list, assign colors and aliases.
After specifying objects for comparison, the first one is automatically set as source. Click Set as source next to any object to make it source.
When reviewing multi-target comparison results, the columns at the right of the Objects pane display comparison status per target (source only, target only, different, etc.). The circle sign indicates that the object exists neither on source nor on selected target (while it is "target only" for another). The Targets pane gives you a tip what databases are compared and how they are ordered as columns in the Objects pane. The colored dots next to database names correspond to the colors selected in the Select Source and Targets page of the wizard.

To review object scripts in the Script pane select an object in the Objects pane and click on required target column (selected target column is highlighted). The colored lines at the left and right side of the Script pane correspond to the colors selected in the Select Source and Targets page of the wizard that make it easier to track what target script is currently being shown.

The Properties tab also provides information per selected source and target pair.
When synchronizing multiple targets, several synchronization scripts are built and you can switch between them using Targets pane in the Schema Synchronization window. To run synchronization for one or several targets click Execute script(s). You will be prompted to explicitly select targets.
The information on databases and snapshots that you selected for comparison, aliases, colors, etc. is saved and stored within Schema Compare. The next time you open Schema Compare the wizard will be populated with your settings.

Data Diff Viewer

Data Diff Viewer incorporated advantages of Data Compare. Right-click two tables in the Object and select Send to | Diff Viewer as Data. Or select Tools | Compare | Data Diff Viewer and drag & drop tables to the pane. Also you can compare results sets from the Editor with right-click | Compare To | Set_number.
Toad automatically suggests column mapping and selects comparison key (primary or unique key), while you can map columns manually (according to their data types), include or exclude columns and add comparison keys.
After comparison, you can easily see the differences per record as Toad allows to organize columns of the source and target tables in pairs, highlights and marks them with "source only", "target only", "different" and etc. The toolbar at the top of the pane allows to filter, group and navigate through the records. The Row Viewer and Cell Viewer at the bottom show details for selected row or cell correspondingly.

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
Selected
Cleared

Data Compare

Foreign keys are now disabled instead of being dropped and recreated when inserting, updating or deleting data with synchronization script.
Text Diff Viewer was integrated into Cell Viewer and allows to see differences clearly.
Schemas are now extracted in parallel that significantly reduces comparison time.

Database Administration

General

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

(SQL Server 2012) Toad allows to view databases configured for AlwaysOn support. Right-click a database in the Object Explorer, select Options | Extra Columns | Synchronization State or/and Availability Role.
Generate SQL submenu was reorganized. Now when you right-click an object and select Generate SQL you are offered to select a type of script to be generated (Create, Alter, Execute, etc.) first followed by To Editor / To Clipboard / To File options. The option you selected last time is remembered (and is marked with bold), so next time you can simply click straight on the type of script without having to select an option from the submenu.

Object Management

WITH NOCHECK / CHECK syntax is available for the foreign keys and check constraints both in the DOE (Database Object Editor) and scripting. You can navigate to the Constraints page in the Table DOE and set a foreign key to "Trusted". Trusted property is also shown for foreign keys in View Details | Constraints tab for Tables.
When generating execution script for the stored procedures to the Editor, SET @<parametername> = statement is added for each declared parameter. This is handy when you have a lot of parameters declared and need to set them all manually. Just input parameter values without having to type SET statement every time.
When renaming a database you can select whether to keep backup and restore information or not. To omit it set Delete backup and restore information to True in the Rename Database DOE.
Toad allows to review generated script for TRUNCATE TABLE.

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.

Security

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:

Microsoft SQL Server Management Studio 2012
Microsoft SQL Server Management Studio 2008 R2 SP2 or later

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:

Group Execute
Automation
Log Reader
Data Compare
Schema Compare
Importing and Exporting Data
Session Browser
Performance Monitor
Index Fragmentation
and etc.

Query Development

Editor

GO N syntax is supported. Add it to the end of your script to execute it N times.
Script generation has changed - fully qualified database names are now removed from tables, views, procedures and functions. This allows you to run scripts across multiple databases without having to adjust object names for each database. For example, if you have a production and test databases with identical structure and object names you can deploy the same script for both of them with just USE [Database name] statement.
(SQL Server 2012) Values now can be concatenated using CONCAT (value1, value2,..., valueN) syntax.
(SQL Server 2012) The following system functions are now supported:
- Try_Convert
- Parse
- Try_Parse
Note: Review Microsoft documentation for more information on converting data types.
Toad recognizes and parses SQL more carefully and when you press F9 Toad now executes not all the statements in the current batch but exactly the selected statement. Write SQL as you are used to and do not be limited by necessity to use GO and etc. to separate statements. Toad will distinguish them for you.

Script Results

Editor automatically checks syntax when opening a script, executing current statement (F9), checking syntax, changing database in the Editor or refreshing the Script Map. The syntax errors are listed in the Messages tab in the Script Results pane.
You can add XML declaration when saving XML data to file with a right-click in the Result Sets tab.

Automation

Schema Compare and Data Compare Activities

Schema Compare and Data Compare Activities are now available as Database Activities in Automation.
Schema Compare and Data Compare activities allow to reuse comparison projects prepared in advance or run new comparison wizard right from the Automation. The interface for both activities is similar and easy-to-use.

When preparing an activity for automation you simply specify the comparison project, locations for report files and synchronization script. You can also select to execute scripts that will generated during data or schema comparison.
Automation button was added to the Data Compare and Schema Compare toolbar. After clicking this button you will be prompted to save your comparison project. Automation pane is invoked automatically and lists your project in Data or Schema compare file field.

Variables

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.

When you create a new variable in Automation (using the Set Variable activity) you can now specify a variable type (String, Number, DateTime, Boolean, or SQL).
Built-in variables (variables specified by an activity, like the row-count variable) now have the same functionality and behavior as variables you create using the Set Variable activity.
- You can use a built-in variable as a bind variable in a SQL statement.
- You can include a built-in variable in the file name of an output file.
The format of the default name that Toad automatically assigns to all built-in variables has changed.
- The name is composed of the activity’s name (which you can specify) and the variable’s purpose. So if you have an activity named SelectOrders, Toad now names this activity’s row-count variable SelectOrders_RCOUNT.
- You can customize the name of a built-in variable if you don't want to use the default name.
Any bind variables stored in the Bind Variables dialog in Toad are now available to use in Automation. The stored bind variables are now accessible from the Variables list in the expression editors in Automation activities, and also in the Set value field in the Find and Replace activity (if Variable Value is selected).
For activities in which you can add a suffix to the output file, you can now select a variable from a previous activity or a bind variable stored in Toad for SQL Server to include as part of the suffix.
Formatting the value for a Date type variable is now easier.
- The Date Functions list provided by the expression editor (in various activities) now includes more-flexible, easier to use functions.
- You can now use a dash (-) in date/time formats used in Automation variables.
- You can now use a colon (:) or a forward slash (/) in date/time formats used in Automation variables (except when the variable appears in a file name).
In applicable activities, Toad now limits the selection of variables to only those created in activities previous to the current activity.
In the Import Wizard and Export Wizard activities, you can now use a variable in the Import/Export template file name.

Loop Dataset Activity

In the Loop Dataset activity, you can now select any previously created SQL-type variable to use as the dataset variable. For example, you can use the SQL variable from any Execute Script, Set Variable, or even another Loop Dataset activity that precedes the current activity.
The dataset variable in the Loop Dataset activity is now easier to use, and you no longer need to add a Set Variable activity to initialize and use the value stored in the dataset variable.
You can use the following format to filter data from the dataset variable when referencing it:

<dataset variable name>.<filter parameter>

Example: Loop_data_1_SQL.region_id, where region_id is the column name

Set Variable Value Activity

In addition to the many new enhancements to Automation variables, this release includes the new Set Variable Value activity. You can use this activity to easily assign a new value to a previously-defined variable.

Loop Connections Activity

This release includes a new Automation activity called the Loop Connections activity. You can use this activity to loop through multiple connections, executing one or more activities against each connection in the list.

Copy File and Delete File Activities

You can now use standard wildcard characters in the file name to help you select one or more files to copy or delete. Previously, you could use the only the asterisk (*) in the file name to select multiple files to copy or delete.
You can now use a variable in the file name to select one or more files to copy or delete.

You can now generate and save detailed Object comparison reports created by the Data Compare activity.
You can also generate and run a synchronization script using the Data Compare activity.

Automation Guided Tour

The Automation Guided Tour is a helpful wizard that guides you through the process of creating one of several different simple Automation scripts. Use this new wizard to help you create one of the following basic scripts:
- Export Data and Email
- Execute Script
- Import Wizard
- Exception Reporting
- Loop Dataset
You can send a SQL statement to the Automation Guided Tour from the Editor or the Query Builder by clicking the Send SQL to Automation button in the toolbar.
In addition, the last page of the Import Wizard allows you to send your import template to the Automation Guided Tour.
After completing the wizard, your new script opens in an Automation window where you can further customize and enhance the script, if necessary.

General Automation Enhancements

This release also includes several general enhancements to Automation activities.

In the Automation Toolbox, some activities have switched categories to better reflect their function. The Send Email and the Run Automation Script activities are now in the Systems Activities category.
For activities in which you can add a suffix to the output file, Toad now provides a convenient expression editor to easily build a customized suffix.
In the Select to File activity, selecting the options for your export file is now much simpler. If necessary, you can still specify the more advanced export file options by using the Export Wizard activity instead of the Select to File activity.
In activities that provide a File Collection Editor dialog for selecting files to attach or zip, etc., Toad limits the files to only those created in previous activities. In addition, if a previous activity is disabled, its output files are not available.

Important!

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.

Compatibility

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.

Resolved Issues and Enhancements

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

Feature	Resolved Issue	Defect ID
Code Completion	The columns with ROWVERSION/TIMESTAMP data type is no longer included in the INSERT INTO (...) SELECT (...) code snippet.	ST98595
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.	ST106318
	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.).	ST92437 ST101899 ST101900 ST101901
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).	ST106616 ST103340
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.	ST104499
Object Details (DOV)	Alter Table: Fixed issue with Columns and Data tabs not being refreshed after adding a primary key.	ST106415
Object Details (DOV)	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>".	ST104122
	Windows Server 2000: Fixed issue with not being able to DROP LOGIN.	ST108190
	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".	ST106615
	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".	ST90493
Schema Compare & Sync	Fixed issues with printing schema reports.	ST104282 ST105968
	Fixed issue "Toad fails to open user's Schema Compare snapshot".	ST106632
	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".	ST108300
	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".	ST106314
Script Generation	Fixed issue "Generate Insert Statement contains timestamp columns".	ST107529
	Fixed issue "Extended alter script generates for about 3-5 minutes on complex table".	ST100308
	Restore database syntax was improved.	ST105237
	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.	ST96560
Service Broker	Service Broker now supports SQL Server 2008.	ST60874
Service Broker	Service Broker now supports SQL Server 2012.	ST100053
SQL Editor	Fixed issue with incorrect formatting for identity columns.	ST103025
	Fixed issue with recognizing labels as incorrect syntax.	ST105344
	Improved format style for joined tables.	ST100761
	Improved format style for Drop Index syntax.	ST100763
	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
Version Control	Fixed issue "New active task appears when Commit window opens even if commit is not initialized".	ST104845

Known Issues

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

Feature	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.0 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.0 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.	N/A
	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. Workaround: Select This program installed correctly to continue installation. For more information, see http://windows.microsoft.com/en-PH/windows7/Program-Compatibility-Assistant-frequently-asked-questions	N/A
	The error appears during Toad for SQL Server installation/uninstallation if any Toad has been previously integrated with Microsoft SQL Server Management Studio (via plug-in) and Management Studio is up & running at the moment. Workaround: Stop installation/uninstallation and close Management Studio.	ST109570
	In some environments Toad plug-in installation may cause an exception on Microsoft SQL Server Management Studio 2008 R2 start. Workaround: Contact Support for hotfix.	ST109699
Installation	When installing Toad into a Citrix virtualization environment, you might encounter the following Toad error message: “CryptographicException. The profile for the user is a temporary profile.” Then, when attempting to launch Toad after installation, you encounter a similar error message and Toad fails to open. Issue: This release of Toad for SQL Server does not support temporary or mandatory profiles on Citrix. This issue involves Microsoft .Net Framework 4.0. See the following for more information: http://devnet.superoffice.com/Developer/Blog/verifying-licenses-on-temporary-profiles/. Workaround: In a Citrix deployment that requires the use of temporary or mandatory profiles, use Toad for SQL Server 5.7 (or earlier).	QAT-580
Code Completion	User functions are not displayed in CC list.	ST91806
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. Workaround: Clear "Poll service status in connection list" checkbox on the Tools \| Options \| Database \| General page.	ST86603
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
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.	ST83268
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. Workaround: Use the actual execution plan button to generate execution plans for SQL that contains a temp table.	N/A
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.	N/A
Export Wizard/ One Click Export	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.	N/A
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.	ST37112
Log Reader	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.	ST59194 ST68131
Object Explorer/ Database Explorer	FDCC: User cannot start/stop SQL Agent running Toad with Regular or Admin User account on the client side in some limited environments. Workaround: Start the SQL Agent on the server side.	ST91618

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
Automation	If you are running Windows XP with Service Pack 2 in strong security mode, Windows blocks you from opening zip files sent by Automation if they were created using the Windows Compression wizard. This is a security feature in Windows. Workaround: Save the zip file to your computer. Right-click the saved zip file and select Properties. Select the Unblock checkbox.	N/A
Automation	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. Workaround: Install Microsoft Framework .Net 4.5.	N/A
Excel	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: http://support.microsoft.com/kb/304662.	ST42486
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: http://www.microsoft.com/en-us/download/details.aspx?id=20923 2007 PIAs: http://www.microsoft.com/en-us/download/details.aspx?id=18346	N/A
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. Workaround: Adjust screen resolution.	N/A

System Requirements

Client Requirements

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

Platform	600 MHz minimum, 1 GHz recommended
Memory	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 XP Professional (32-bit or 64-bit) Windows Vista (32-bit or 64-bit) Windows Server 2008 (32-bit or 64-bit) Windows Server 2008 R2 (64-bit) Windows 7 (32-bit or 64-bit) Windows 8 (32-bit and 64-bit) 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 http://technet.microsoft.com/en-us/library/cc753510(WS.10).aspx for more information about enabling DTC access.
.NET Framework	Microsoft .NET Framework 4.0 Note: The .NET Framework Client Profile is not supported.
Additional Requirements	Web Browser Microsoft Internet Explorer 6.0 or later 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. http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en

Server Requirements

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

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
Project Lucy 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

Notes:

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 majority of Toad functionality please grant VIEW DEFINITION on the SQL Azure databases you want to work with.

Virtualization Support

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 Quest 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:

Associate file extensions.
View the Toad shortcut icon on the desktop or the Toad menu options in the Windows Start menu. As a workaround, Restricted Users can create a shortcut to Toad from the install directory and place the shortcut on their desktop.

User Requirements and Restrictions for Running Toad

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

To create or modify the QuestSoftware.ToadSecurity table to enable Toad Security, the user who maintains this table must have privileges to create, insert, update, and delete it. All other users need only the ability to read the QuestSoftware.ToadSecurity table to use Toad Security features.

Global Operations

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.

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

Toad for SQL Server 6.0
Product Documentation, including:
- Installation Guide
- Online Help
- Release Notes

Installation Instructions

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

For More Information

Contact Quest Software

info@quest.com

Mail

Quest Software, Inc.

World Headquarters

5 Polaris Way

Aliso Viejo, CA 92656

USA

Web site

www.quest.com

See our web site for regional and international office information.

Contact Quest Support

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to our Support Portal at www.quest.com/support.

From our Support Portal, you can do the following:

Retrieve thousands of solutions from our online Knowledge Base
Download the latest releases and service packs
Create, update and review Support cases

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, policies and procedures. The guide is available at: www.quest.com/support.

Toad Community

Get the latest product information, find helpful resources, and join a discussion with the Toad for SQL Server Quest team and other community members. Join the Toad community a http://toadforsqlserver.com/index.jspa.

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 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 products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST 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 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 HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest 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 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 World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656
email: legal@quest.com

Refer to our Web site (www.quest.com) for regional and international office information.

Trademarks

Quest, Quest Software, the Quest Software logo, LiteSpeed, Simplicity at Work, Toad, TOAD, T.O.A.D., and TOAD WORLD are trademarks and registered trademarks of Quest Software, Inc. For a complete list of Quest Software’s trademarks, see http://www.quest.com/legal/trademark-information.aspx. Other trademarks and registered trademarks used in this guide are property of their respective owners.