Toad^® for SQL Server

Version 5.5

Release Notes

May 27, 2011

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

Few Features in 5.5

General

Toad for Oracle look and feel has been implemented to make database management in Toad for SQL Server 5.5 even more comfortable and user-friendly.
Faster installation time.
Toad now supports Excel 2010.
Script Generation throughout the product has been improved to be more complete, flexible, accurate, and generate faster.
You can set the File History Size option to zero to reduce the amount of time required to load the File menu in Tools | Options | Environment | General.
Toad is adapted to work with large data amounts. Take advantage of extended search possibilities in Schema Compare and Generate DDL functions (see below).
Starting with the present release enhanced SQL Optimizer is shipped within Toad for SQL Server Bundle or can be purchased as stand-alone product.
Toad allows to schedule tasks instead of performing them immediately.

Database Administration

Database Diagram

When adding additional objects to the Database Diagram, the objects are not automatically rearranged in the pane.

Object Explorer

The Index node has been added under the Databases node in the Object Explorer that made most index operating functions easier to access. To create, alter and drop indexes use the icons on Object Explorer pane. Right-clicking required index you can invoke more advanced functions such as index defragmentation, updating statistics, etc.

Schema Compare

The overall performance has been improved. Schema comparison process became more customizable and flexible.

Now you can select the objects to be included into the schema comparison.
Use Advanced Search options to achieve precise search results. The objects can be searched by their type, name, date and content. Add to the comparison just the objects that you are interested in.

You can search objects not only by date, object type or name (or part of it), but you can also specify a name (or part of it) of the higher level object to which the search object should belong to. To perform complex name search split the object name by dots (higher_level _object's name.object_name) and select Search in Name (split by dots) option.

For example, you may find all columns named col1 belonging to the tables, that have "s" in their names - test.col1, sales.col1, etc.
With a help of the Selected Objects pane you can perform multiple searches without losing objects, checked in previous queries. While the Search Results pane shows your current search, the Selected Objects pane stores all objects selected for the schema comparison during the previous searches.

When viewing schema comparison results you can filter the objects by specific schema.
Toad now allows you to synchronize with earlier server versions, if the newer object types and features are not included in the source system. For example, you can synchronize schemas on SQL Server 2008 R2 and SQL Server 2008. Please note, that you cannot synchronize with SQL Server 2000 as a target system.

Generate DDL Script

Generate DDL tool demonstrates significant improvements in usability.Now it is accessible with Tools | Export | Generate DDL.
Advanced search options and advantages of using Selected Objects pane, described above (see Schema Compare) are also available for script generation with this tool.

Index Fragmentation

Toad introduces the possibility to investigate indexes and perform defragmentation that sufficiently increases query processing speed. You can access this feature by selecting Tools | Administer | Index Fragmentation.

With a help of the Index Fragmentation pane you can create the list of indexes, group them according to the customizable threshold values and issue warning and critical statuses. For defragmentation you can automatically select indexes with critical and warning or with only critical statuses without having to check each index manually.

Storage Management

Shrink database function is now also accessible from Tools | Administer | Storage Management. You can manage files, alter and shrink databases within the same pane.

Restore Database

Toad provides improved usability and performance.

The number of steps required to complete the Restore Database wizard has reduced twice.
Toad provides additional functionality, that makes restoration process more flexible and matching our customers demands. For example, to create a new database from the backup you can just right-click the Databases node and select Restore.

Session Browser

You can monitor sessions and track your application's activity, manage processes and view locks within the same Session Browser pane, accessible from Tools | Monitor | Session Browser.

Query Development

Code Completion

Internal logic has been significantly reviewed to make the Code Completion results appear faster. Now the Code Completion provides better performance, improved style and wider functionality.

Performance and usability enhancements:

Now you can call for the Code Completion just after inputting a keyword.
Code Completion does not wait for the whole list of objects to be generated, but appears immediately, starting with tables and continues to add objects while you can already navigate inside it.
Toad introduced ability to enable or disable data preview feature. When Exclude column sample data enabled working with huge tables is much faster.
Code Completion inserts columns in order that they were selected.
You can navigate and select objects in the Code Completion window using keyboard. Use CTRL+RIGHT (LEFT) arrows to expand (collapse) the nodes in the list, CTRL+SPACE to select objects without closing code completion list.
Datatypes are displayed next to the column names.
Toad allows to refresh the contents of Code Completion list with a standard shortcut key or using button at the bottom of the Code Completion panel.

Functionality improvements:

Now Toad supports “::” syntax that enables displaying list of functions.
Code Completion supports "insert into table" syntax.
Besides the objects names and table structure the Code Completion provides T-SQL context help.
Code Completion supports primary keys join and join of the same named columns.
Code Completion generates columns datatypes for "insert" and "update" statements.
Now Code Completion allows to work with the following temporary variables: @tmp, #tmp.
When using WHERE clause, Code Completion automatically offers to join the columns with the same names and data types.

Query Builder

When specifying date ranges in a Where condition, the following enhancements are available:
- You can now modify a pre-defined calendar, including quarters, periods, etc., or can create a custom calendar.
- You can click the date range link in the Query tab of the Query Builder to open a window that displays the actual syntax, and copy that syntax to use in other queries.
You can now add a Group By clause to all selected columns in each table/view, by right-clicking the Diagram pane and selecting Add Group By. An indicator displays to the right of each selected column.
After executing a query using the Create Table As Statement option, the new table now displays in the Object Explorer.

Editor

Now it is possible to rename Result tabs. It is convenient when you pin one of the tabs and use it as main or example for tracking other tabs.
You can now select a date using a calendar in the Bind Variables window.
Toad enhanced multiple drag and drop functionality. You can select multiple objects in the Object Explorer and drag them into the Editor, where they will be separated with commas. It is convenient as no editing is required afterwards.
You can customize Editor's appearance. Set Editor's background color in Options | Editor | General and highlighting in Options | Editor | Highlighting Styles.
Now end-of-line glyphs are shown for word wrapped lines when Show end-of-line glyphs and Word Wrapoptions are enabled in Options | Editor | General.

Code Snippets

You can send a code snippet to a shared folder, zip file, email address, or other locations from the right-click menu.

Data Management

Export Wizard

Toad allows to export multiple object types within the same Export Wizard.
You can now open Export Template Files (.txp) from the File | Open menu.
Exporting synonyms is now supported.
Toad allows to add SQL statements to the export. Select Include SQL statement in output file feature in the Export Wizard.
When exporting data to an Excel file, the following enhancements are available:
- Numerical columns display as Number formats.
- Date columns display as Custom formats, and use the format you specify in the DateTime tab in Tools | Options | Environment | Grid.
- Export to existing Excel Macro Enabled files (.xlsm) is now supported. If macros are enabled, you can select which ones to execute before and after the export.
  
  You can also use xlsm files in Automation scripts.
You can enable Use current regional settings function to use your locale decimal separator instead of default dot.

Import Wizard

You can now open Import Template Files (.tim) from the File | Open menu.
The Import wizard UI has been rewritten, and includes the following enhancements:
- In addition to a single file, you can now import all files of the same type from a directory folder.
- You can import a SQL query by selecting an existing SQL file or by entering the query. You can also preview the result to ensure that your SQL is valid.
- You can add a new column to include in the import, or can remove an existing column.
- Toad automatically and intelligently maps data types to a default type. You can also manually map the data type.
- When importing an Excel file, you can click a new Excel icon on the File Preview window to open Excel and manually select a range of data (even a single cell!). This is useful if you have a file with multiple reports.
  On the same wizard page you can alter and reorganize importing table. Select Transpose All option to transpose all columns into lines and vice versa. To group several column headers as values under other header and to put their values in the next column use Normalize columns . Press to specify the required columns. See the example how the table can be reorganized.
  You can also filter individual columns by clicking the filter icon beside the column name or by clicking Edit Filter.
You are now prompted to enter a password if you select an Excel file that is password protected.

Data Compare

When selecting the source and target databases in the Data Compare Wizard, you can name the comparison project, select whether to display system objects.
If you opened the wizard from the Tools menu, you can copy or switch the source and target database.
You can now multi-select rows of objects in the Select Objects page and click Map Selected to map multiple objects at a time.

SQL Server Discovery

Formerly stand-alone SQL Server Discovery tool was implemented into Toad for SQL Server as a plug-in. SQL Server Discovery makes it simple to detect all the SQL Server instances in your organization and monitor your network for changes. It even helps you find SQL Server instances that native tools cannot detect. You can access this feature by selecting Tools | SQL Server Discovery.

Learn server, instance, and operating system names as well as which versions of SQL Server and service packs are deployed.
You can monitor a network for changes and perform discovery with multifaceted approach that includes domain and IP range discovery techniques.

You set a single IP address or a range, that makes discovery process more precise.

SQL Server Discovery provides full range of discovery methods.

The following methods are available for discovery by domains:
- New SQL Server Enum
- AD Search
The following methods are available for discovery by IP addresses:
- Network Registry Connection
- WMI Connection
- Login Attempt
- TCP Connect
It is possible to run several discoveries and store statistics within one document. You can change discovery settings or rerun discovery without changing them. The information on discoveries is accessible from the History pane and you can easily switch between discoveries and view list of detected SQL Server instances.

The History pane provides statistics on new, missing, changed and unchanged servers, calculated relative to the previous discovery.
Gain a better understanding of your SQL Server environment by setting a baseline and using it as an indicator of future change when new servers or instances are added.

Set a baseline as a etalon network state and compare results of other discoveries with a baseline.
You can check network's vulnerability and ensure strong password selection. Use Check Passwords Vulnerability function to find unsafe server passwords. You can search for blank passwords or provide your own list of vulnerable passwords.

Resolved Issues and Enhancements

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

Feature	Resolved Issue	Defect ID
Connection Manager	Connections window now reflects the changes for connection Category.	ST81655
Data Grid	Data filter feature has been rolled back instead of datetime picker, implemented in Toad for SQL Server 5.0.	ST79756
Editor	Find & Replace: User can undo last command (with CTRL+Z).	ST81691
ER Diagram	User can change the dependency depth to control the related tables added to diagram.	ST81789
ER Diagram	Toad allows to print ER Diagram.	ST81712
Export Wizard/ One Click Export	(Windows 7 only) When exporting data to an Excel instance using the Export wizard, Toad stops responding.	ST67980
	You can export connections from nested folders.	ST81247
	Exporting huge amounts of data from the Result Sets is now not so time consuming and do not lead to out-of-memory exception.	ST83310
	Toad allows to set file encoding.	ST82726
General	(Windows 7) Toad does not disappear from ALT+TAB list after invoking modal dialogs.	ST80486
General	List of Recent Files displays both: the files opened via File \| Open and with drag & drop.	ST81980
Generate Data Script	Now exception occurs when generating data scripts with the line's size exceeding 32 MB.	ST83661
Job Manager	It's possible to view details of the jobs running for more than 32 hours.	ST82839
Installation/ Upgrade	(Windows Vista and 7 only) If you double-clicked Toad.exe to install the product, UAC might have been disabled during the installation, a message displayed in the Action Center stating that “you must restart your computer to turn on UAC,” and UAC may not be re-enabled when the installation completed.	ST68492
Migration	Toad allows to migrate auto-replace and code snippets.	ST80092
Migration	Provides better migration with Toad for SQL Server 5.0 trial version.	ST80937
Object Explorer	Logins: Changing role membership is disabled for dbo.	ST82941
Object Explorer	No empty values are displayed in the columns.	ST83854
Query Builder	No exception occurs when closing a query after you deleted subquery.	ST82836
Schema Compare	The synchronization script for CREATE LOGIN is correct.	ST79640
	Toad does not hangs when connecting to remote server via OpenVPN.	ST83105
	The script is generated correctly on ALTER TABLE with some specific local settings.	ST80905
	Toad keeps permissions when synchronizing source and target systems.	ST80803
Results	It is possible to highlight and copy part of the Message.	ST81755

Known Issues

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

Feature	Known Issue	Defect ID
Startup	(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.5 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 Server5.5 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
Startup	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
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
Editor	Starting with the 4.6 release of Toad, any files that you save as Toad Editor Files (.tef) cannot be opened in a previous version of Toad. Attempting to open a newly saved .tef file in a previous version of Toad results in unreadable data. However, you can open any .tef files created in a previous version of Toad with the Toad for SQL Server 4.6 or later release, and everything displays properly.	N/A
Editor	Toad may hang after applying Short Format Uppercase Keywords or Short formats to large scripts.	ST83268 ST83638
Execution Plan	You cannot generate an estimated execution plan for a local temporary table 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
Import Wizard	Attempting to import data with a query from a table that has Null value cells in non-text columns into a new table results in an import error, and rows with such Null value are rejected if the discard file is selected. Workaround: Export the table with Null values in non-text columns to a Comma Separated Values (CSV) file before you import it to the new table.	ST85881
Job Manager	Currently, you cannot export the job list to Excel 2007 or later (xlsx) formats.	ST74004
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	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. Workaround: Download and install the Microsoft Visual C++ 2005 SP1 Redistributable Package (x86) on the client from: http://www.microsoft.com/downloads/details.aspx?FamilyID=200B2FD9-AE1A-4A14-984D-389C36F85647&displaylang=en	N/A
	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
	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	Databases: Currently, if you select the Enable database backup checking checkbox in Tools \| Options \| Database \| SQL Server, the list of databases in the Object Explorer do not indicate the backup status until you press F5 to refresh the list.	ST63855
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
Query Builder	If you execute a query and create a pivot grid in the Pivot & Chart tab, and then re-execute the query and attempt to create a pivot grid with the second result set, a "Selected result cannot be analyzed in a pivot grid. Either the result is empty or the query is still active" message displays.	ST71065
Query Builder	Currently, you cannot reverse engineer a query that contains a WHERE EXIST clause.	ST75090
Service Broker	Currently, Service Broker does not support SQL Server 2008.	ST60874
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 VersionControl 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	In previous releases, the method Toad used to generate the script was different than the current method. After upgrading Toad, a message may display stating that objects or files in version control are different than the local version. If your local version is current, you should check the objects and files into version control.	N/A

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.	ST49799
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 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
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 and Windows Server 2008. 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, the .NET security policy must be set to unrestricted.
Additional Requirements	Web Browser Microsoft Internet Explorer 6.0 or later Spatial Data Types To work with spatial data types used in SQL Server 2008, you must install SQL Server 2008 Client Tools or SQL Server Management Studio 2008. Copy/Move Database Wizard The SQL Server Backward Compatibility package is required to use the Copy/Move Database wizard.

Server Requirements

Before installing Toad, ensure your system 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) SQL Server 2008 SQL Server 2008 R2 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. SQL Server databases running on Amazon EC2
.NET Framework	Microsoft .NET Framework 3.5 (Service Pack 1)
Additional Requirements	Maintenance Plans To take advantage of Integration Services (SSIS) in maintenance plans, you must install the following: Integration Services that may be a part of the Client Tools 2005/2008 or a part of SQL Server (For SQL Server 2008 only) Management Tools - Basic

Virtualization Support

Application Virtualization	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.

Getting Started

Contents of the Release Package

The Toad release package contains the following products:

Toad for SQL Server 5.5
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 SupportLink, our self-service portal. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

Retrieve thousands of solutions from our online Knowledgebase
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: http://support.quest.com.

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

www.quest.com
email: legal@quest.com

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

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, LiteSpeed, SQL LiteSpeed, Toad, T.O.A.D., Toad World, and vToad are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. For a complete list of Quest Software’s trademarks, please see http://www.quest.com/legal/trademark-information.aspx. Other trademarks and registered trademarks used in this guide are property of their respective owners.