Toad^® for SQL Server

Version 5.7 (Click here for previous versions)

Release Notes

July 18, 2012

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

New Features in 5.7

General

Toad has significantly improved performance and stability. When working with the databases that include a great number of objects, the possibility of getting OutOfMemory exception is minimized. The costly I/O operations are now processed faster.
Now you can disallow Toad from connecting to the Internet if it is prohibited by your company's policy. Select Tools | Options | Environment | Security and check "Do not allow any Internet access from Toad" option.
Toad's interface became more customizable. Dual monitor support is now available. Enjoy! The document windows and panes can be used in the floating mode. For example, you can drag Editor as a separate document to another screen.
You can also arrange the layout so that the tab headers are located one under another. Select Tools | Options | Interface and check "Display document tab headers vertically" option.
You can now customize data filtering in the DOV (Database Object Viewer) to organize columns in ascending or descending order. Select the Filter icon in the Data tab of the DOV and navigate to the Order By page in the Filter Data pane. By default Ascending mode is on, to sort columns in descending order clear the checkbox next to selected columns.
When updating data in the Data Grid the UPDATE statement is issued only for the columns affected. This operation is more time-saving and prevents the loss of partition keys in the converted databases.

Database Administration

Important! Toad provides support for MS SQL Server 2012 objects. Browse objects in the Object Explorer, create and alter them using Database Object Editor (DOE) or manage using Database Object Viewer (DOV) that is enabled with a right-click on the object | View Details.

Object Management

Toad for SQL Server supports partial contained databases that were presented in MS SQL Server 2012. According to the contained databases concept all metadata, connection and configuration settings are stored inside database that provides opportunity to easily move it between SQL Server instances. Partial contained databases are introduced in SQL Server 2012 and provide limited containment functionality, but also support uncontained features available before.

When creating a database with a help of Database Object Editor (DOE) you can select containment of the database - none or partial. You can select containment options for the databases that were set to "Partial".

The contained databases are marked with a special icon in the Object Explorer.
Toad allows to review the information on allocated space. Space Usage chart is displayed at the bottom of the Properties tab in the Database DOV (Database object Viewer).
Toad for SQL Server supports FileTable objects that store FILESTREAM data and data related to the directories and the files. Such data can be accessed from the other Windows applications. FileTables are marked with special icon in the Object Explorer.

To create FileTable right-click a Table node in the Object Explorer and select Create Table. In the Columns page set Table type to "FileTable" and specify required options.
Toad allows to capture statistics on the table columns. The introduced Statistics tab can be easily accessed with a right-click on the table | View Details. Review the statistics information gathered the column specified using Statistics DOE (Database Object Editor).
Columnstore indexes introduced in MS SQL Server 2012 are supported by Toad. To create a columnstore index right-click the Indexes node in the Object Explorer and select Create Index. In the General page select "Columnstore" from the Index Type list.

Columnstore indexes are marked with a special icon in the Object Explorer.
Stored Procedure DOE (Database Object Editor) was improved. Parameters section was updated.
Toad allows to create user-defined server roles. Navigate to the Server Roles node under Server Security, right-click it and select Create Server Role. User-defined server roles are marked with a red icon in the Object Explorer.
Sequences can now be managed in Toad. To create a sequence execute creation script in the Editor. Browse sequences under the Database node in the Object Explorer.

Session Browser

Session Browser now provides more detailed information on the processes, organized in charts. Select Tools | Monitor | Session Browser and navigate to the Charts tab. Select one or more processes from the list above and the metrics below the charts. Toad can build several charts based on the process characteristics (memory usage, physical IO, wait resource, etc.).

Database Snapshot

Creation of database snapshots can be scheduled.

Connection Manager

Toad allows to create connections to MS SQL Server 2012. Create a connection as usual in the Connection Managers pane and select the SQL Server 2012 instance from the list of available server names.

Query Development

Query Builder

This release of Toad for SQL Server has re-implemented the checkbox method of selecting columns in the Query Builder Diagram pane. Click a column name once in the table diagram to add the column to the query. To add the column to the query a second time, right-click the column name in the diagram and select Add to Output.
The elapsed time is now displayed in the lower right corner of the Query Builder window while a query is executing.
In the Query Builder, for the selected columns in the criteria pane, the column widths now fit the column name making it easier to read them.

Code Snippets

You can now import snippets directly into a selected folder in the Code Snippets window.
You can now export your entire code snippet library to a destination folder.

Editor

In the Editor toolbar, all of the execute buttons are now consolidated under one button.
- This main button retains the function of the last action for the active Editor window.
- If you switch to another Editor window, the button will change to reflect the last execute action for that window.
- The other execute buttons are always available beneath the Execute SQL button via a drop-down list, or can be placed back in the toolbar by customizing it.
For all databases, the error log in the Editor and the Query Builder now provides the line and position for syntax errors. Highlighting is also included for syntax errors if the database has a deep parser.
Previously, when the Editor contained multiple statements, and you selected Send To Query Builder, Toad sent the entire contents of the Editor. Now you can highlight one statement, right-click the statement and select Send To Query Builder to send only the one statement.

Editor floating window has it's own file menu. Context menu has been redesigned so that managing SQL became even more convenient as all most likely used options are easily accessible.
Document Recovery Manager allows to recover previously saved Editor documents. Select the document in the Document Recovery Manager pane in the right sight of the program window.

Toad allows to load preset template when you open a new Editor window. It's handy when you want your scripts to be consistent with each other (for example, have the same header with company name). Create a template TOADSQLFILE.sql in the following location:

Platform	Location
Windows XP, Windows 2003	C:\Documents and Settings\All Users\Application Data\Quest Software\<Product_Name>\Templates\Snippets.
Windows Vista, Windows 2008, Windows 7	C:\Users\<user>\AppData\Roaming\Quest Software\<product>\Templates\Snippets\

Tip: Constructions surrounded with $ (for example, $Name$) in TOADSQLFILE.sql are treated as snippets in Toad.

Filestream and FileTable functions are highlighted in the Editor.
Now you can drag and drop column headers right from the Results Sets to the Editor.

Code Completion

Code Completion allows to insert SELECT query results using INSERT INTO (...) SELECT ... syntax. INSERT INTO (...) SELECT ... is handy as you see a list of target columns with their data types. This ensures that target columns will be compatible with the ones inserted using SELECT query.
Code Completion provides enhanced support of data types syntax. When operating on data types (DECLARE, INSERT, etc), Code Completion list is automatically populated with available data type lengths. When selected the attribute is also automatically wrapped in the brackets.
Subqueries support has been significantly improved.
Code Completion provides supports of USE statement. With USE statement in the script Code Completion list is be firstly populated with target database objects irrespective of the database set as default. It is handy because the objects that are most likely to be used in the query are located at the top and you do not need to scroll down a long list in order to find them.
The column data types and functions and procedures parameters are shown with pale color in the Code Completion list.

Script Map

Script Map is easy-to-use tool that makes managing SQL scripts even more convenient and simple. Script Map pane provides fast, structured and clear representation of your script in the Editor and allows to easily manipulate statements and statement groups. By default Script Map is switched on automatically when you open a new Editor window or you can access with Editor | Windows | Script Map.

Note: Script Map has replaced Navigator feature.

Script Map supports most of SQL statements and recognizes nesting levels (code blocks, named regions, etc). For example, nesting is displayed for stored procedures, functions, etc.

You can easily customize what statements to display in the Script Map pane. To do it select the Options button at the top of the pane. Set the colors and include only those types of statements that are relevant for you.
Multi-select allows to manage several items simultaneously. For example you can cut, copy, execute several statements irrespective of their nesting level and location in the script.
The statements that contain syntax errors are underlined red in the Script Map. The parent items that contain such statements are highlighted as well.

Data Management

Data Compare

Data Compare wizard has been significantly improved and demonstrates fast performance.
- Map Source Objects to Target page of the Comparison Wizards has been redesigned to make column mapping easier, more convenient and user-friendly. The objects are mapped automatically, even large databases are processed almost instantly. Columns Mapped column displays how many columns are mapped and mapping status, while the information pane at the bottom shows more detailed information.
- It is handy to use Search when you have a lot of objects included in the comparison. Instant search is also available in the Target Object drop-down list. When search is activated mapping commands (Map All, Map Selected, Clear Selected, etc.) are applied to the objects that match selected criteria only.
- Now mapping activities are organized in the toolbar and are also available from the context menu.
- When altering your comparison (without changing source or target connection properties) schema extraction is no longer performed in Change Compare wizard, this saves much time especially when comparing large databases. To extract schema select Refresh in the Map Source Objects to Target page of the Comparison Wizard.
- Now there is Save Comparison option in both New Comparison and Change Comparison wizards. It allows to save the comparison file without actually comparing data.
Now reviewing the comparison results and navigating between the differences in the records became more flexible and easy-to-use:
- When refreshing comparison schema extraction is no longer performed. To refresh both schema and data select Refresh Schema and Data from the Refresh button pop-up in the Result pane toolbar.
- Data is listed in the comparison key order. It is very helpful if you need to not just synchronize source with target but to understand the nature of the differences.
- Source and target columns are shown in pairs in the Details pane. So that you can see the differences in values right in front of you. At the same time you can use Separate source and target columns to list the source columns first and all target columns after them.
- You can navigate between the differences in the records (jump to the previous or next) within the selected column (vertical arrows) or across the whole comparison (horizontal arrows).
- The exclamation marks in Result (top) pane and Details (middle) pane indicate that the records contain duplicated values in comparison key and require changing of comparison key (previously such records were shown as conflicts). Hover the mouse over the exclamation mark to see the tooltip with detailed information.
- The rows in the Details pane are highlighted green, red and blue to indicate source only, target only and different records correspondingly.
- When searching for the data in the Details pane you can select Search currently selected column only to search within the single column in addition to other options.
- Data Compare improved working with large objects (for example tables where each record is very large, e.g. 10 or 20 MB). Entire data contained in the record is no longer loaded into RAM, that prevents interface freezing and running out of memory. Now only small piece of the data is loaded when displaying the record contents in the Details pane. Cell Viewer shows more data but also not all (approximately 4 KB), total and shown data size is also provided. To see the entire data select Show All considering that it will be loaded into RAM.
  Note: If trying to view the image that is very large (more than 5 MB), only small part of it will be shown in text form.
The statements in the synchronization script are listed and processed in the following order: DELETE – UPDATE – INSERT. This order reduces the risk of constraint violations or prevents data conflicts.

Import

Now you can import data into identity columns. When trying to import data in the table containing identity columns you will be prompted to turn on "Identity inserts" option in the Select Target page of the Data Import wizard to enable import.

Utilities

Toad for SQL Server now provides proxy support for FTP connections. Toad for SQL Server allows you to set up an HTTP or Socks proxy for an FTP connection.

Automation

Information sharing between activities is improved. For example, if you delete an activity that creates a file, that file is also deleted from any tasks later in the script where it is used as an attachment or other input.
A Cancel button has been added to the Attachment Editor so you can cancel out of the operation, even after making some modifications.
Right-click an activity in the script design window and select Enabled to easily enable/disable the activity.
In Toad for SQL Server, properties and script settings now display only when the activity or settings icon is selected in the design window, making it more difficult for the user to accidentally change script settings and activity properties.
You now have the option to choose whether or not to truncate the script’s log file each time the script runs. Make the selection in the script settings pane.
You can now perform a Find and Replace task on multiple files at one time by using standard wildcard symbols in the source file name in order to select multiple files. And you can still add multiple find and replace tasks to one activity.
You can now use drag and drop or up/down arrows to change the order of find and replace tasks in the Find and Replace activity.
In the Email activity, you can now select multiple files at one time using Ctrl+click.
In the Delete File activity, when you click Add Files, the File Collection Editor correctly displays and allows you to select from the files that are created earlier in the script.

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.

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
Backup/Recovery	Fixed issue with destination paths not being saved after opening Script tab in Restore DOE.	ST98891
	Improved RESTORE database performance and UI.	ST95476 ST78948
	Fixed issue "Toad doesn’t apply user-defined file specification on Destination page – it gets original data from backup".	ST92716
Code Completion	Fixed issue when current time was displayed in Code Completion in SELECT query with NOLOCK parameter.	ST85142
	Code Completion is now invoked for "distinct" and "top N" operands.	ST90838
	Fixed issue with not displaying variables with underscore characters in name (e.g. @Var_modify_date) in Code Completion.	ST87653
	Fixed issue with comma in aggregate function leading to Code Completion error.	ST99603
	Fixed issue "Toad replaces default schema name on '..' when type object name as [database].[schema].[object]".	ST100097
Code Snippets	Fixed issue "Parameter is not automatically prefixed/suffixed when the highlighted text that we want to make into a parameter is touching "_" characters."	ST98170
	No exception occurs on code snippet shortcut when snippet title is changed.	ST95988
	Fixed issue "Script from code snippet works incorrectly if default value in Parameter is empty". Now if the default value is empty then it's equal to the identifier name.	ST92951
	Fixed various issues with renaming snippets.	ST98172 ST85988
Data Grid	No concurrency violations occur when trying to edit data in the grid.	ST98948
Explain Plan	Now only real queries are displayed in Explain plan.	ST87350
	Fixed issue with Access Violation exception.	ST96428
	The graphic plans of script execution does not blink when opening "Execution Plan" tab on Script Results panel.	ST98677
Import/Export Wizard	Fixed issue with a static column not shown in the template.	ST94090
Job Management	Fixed issue when user could not manually input dates in the Schedule tab.	ST91836
Job Management	Toad now provides ability to select SSIS Package Execution proxies in the Create Job Step dialog.	ST94304
Object Details (DOV)	Fixed issue with getting lookup error when trying to rename some triggers (on table).	ST95141
	Fixed issue with not being able to read Server log.	ST98635
	Fixed issue with Send To New Window and Object Details options not working for DML triggers on Dependencies Tab.	ST96557
	Fixed issue with System.NullReferenceException that occurred when refreshing Triggers tab on RHS after altering table trigger.	ST92491
	Fixed issue with dropping indexes on SQL Server 2000 database.	ST90664
Object Editor (DOE)	Fixed issue with exception appeared when reading Server log.	ST91924
	Fixed issue with being unable to attach database to case insensitive server.	ST92618
	Fixed issue with collation conflict on contained database.	ST93599
	Alter Table: Fixed issue with Toad crashing on large tables with several FKey relationships.	ST93361
	Fixed issue " When altering database it is impossible to change file size of model database because up\down arrows are blocked".	ST86145
	Fixed UI issue in the Constraint page of the Table DOE.	ST91493
	Jobs: Fixed issue with incorrect scripting of carriage returns.	ST99636
Object Explorer	Fixed issue with "The server principal "<User>" error that occurred on double-click on unavailable database.	ST86093
Object Explorer	Fixed issue with Object Explorer not refreshing the table columns list correctly after a table column name was changed.	ST84070
Printing	Fixed issue "[Print Preview]: Getting Error when attempting Print Preview of Schema Compare results".	ST92084
Project Manager	Fixed issue with subfolders being automatically expanded after adding new objects to Project Manager. Now the collapsed subfolders remain collapsed.	ST78966
Report Designer	Fixed issue "System.NullReferenceException occurs when Data Report Wizard try to generate a result set for the query".	ST99955
Schema Compare & Sync	Fixed issue with not loading user schema on 64bit OS.	ST89192
	Fixed issue with additional blank spaces that appeared after resizing window when reviewing differences. Fixed other UI issues	ST75631 ST78830
	Fixed issue with " System.ApplicationException. Can't run operation. Engine is busy " after canceling schema comparison.	ST92581
	Fixed issue with not being able to get schema snapshot from the database with a huge amount of objects.	ST97286
	Fixed issue "Schema Synchronization error - More than one column DEFAULT constraint is specified for column 'LockSupervisor', table 'dbo.Employee' ".	ST96881
Service Broker	Fixed issue with Service Broker crush on fresh machine without previous DevXpress.	ST98759
SQL Editor	Computed column is not included into automatically generated INSERT statement.	ST89038
	Fixed issue with Format SQL not working on "exec @my_var=my_procedure".	ST96824
	Load factor is now between 0.1 and 1.0 when executing query in the Editor.	ST90675
	Fixed issue with Code formatter not working with the scripts that include OUTPUT (INPUT) parameters.	ST96134
	Fixed issue with Toad hanging after drag&drop some .sql files in the Editor.	ST100055
	Fixed issue "Formatter: parentheses options do not apply to Select, Group By and Order By".	ST98828
	Fixed issue "ExceptionTrace.log file extremely grows up during work in Editor".	ST100125
	Fixed issue with API Guard.	ST93779
Script Generation	Fixed issue with the wrong script generated for ATTACH database if mdf/ldf files were moved.	ST90434
UI	Fixed scrolling in the Data Grid.	ST89592

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 Server5.7 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 5.7 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
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
Query Builder	Incorrect script is generated for queries containing aliases with more than one word.	ST90493
Script Generation	Toad is unable to generate ALTER to Column on Complex tables.	ST100308
Service Broker	Service Broker does not support SQL Server 2008.	ST60874
Service Broker	Service Broker does not support SQL Server 2012.	ST100053
Version Control	If you migrate settings when upgrading Toad, you may have to reconfigure the repository setting in version control if a "Failed to open the settings for module Version Control reverting to defaults" error displays. Workaround: To reconfigure the repository, select Tools \| Options \| Version Control \| Defaults and select the previous repository in the Version control folder field. Your previous project settings are applied.	N/A
Version Control	TFS 2010: Script is missing when trying to get the latest version of the object.	ST89135

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
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/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en 2007 PIAs: http://www.microsoft.com/downloads/details.aspx?familyid=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en	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

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) 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 3.5 (Service Pack 1) Note: The following conditions apply: If you have the .NET Framework 4.0 installed, you must still install the .NET Framework 3.5 (Service Pack 1). The .NET Framework Client Profile is not supported. To run Toad for SQL Server, the .NET security policy must be set to unrestricted.
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:

Operating System	Windows Server 2000 Service Pack 4 or later Windows 2000 Professional Edition Service Pack 4 or later Windows XP (32-bit with Service Pack 2 or later and 64-bit) Windows Server 2003 (32-bit or 64-bit) Service Pack 1 or later 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)
Database Server	SQL Server 2000 (Service Pack 3 or later) 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 Note: SQL Server Compact Edition is not supported.
Cloud Database Service	SQL Azure Note: To connect to SQL Azure, you must have read access to the master database and VIEW DEFINITION grant on the databases you want to work with.
.NET Framework	Microsoft .NET Framework 3.5 (Service Pack 1)

Virtualization Support

Application Virtualization

Limited testing has been performed for Citrix XenApp 5.0 support on Windows Server 2003.

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.0 running Windows 7 Enterprise 32 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 run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:
1. Select Control Panel from the Windows Start menu.
2. Double-click Administrative Tools.
3. Double-click Microsoft .NET Framework version Configuration.
4. Select My Computer, and then select the Runtime Security Policy node.
5. Select Evaluate Assembly from the list of tasks in the right panel, and locate and select Toad.exe in the File field.
6. Click Next and set the permission to Unrestricted.
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 5.7
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.