Version 1.1.1

Release Notes

February 2008

Welcome to Toad for Data Analysis	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 for Data Analysis

Toad for Data Analysis is a multi-platform database tool designed for IT and Businesses that need to investigate and analyze their data. It empowers effective decision making by providing insight into business data, allows users to access and understand their data from any source, and streamlines the process of data collection ensuring the right information is delivered on time.

Toad for Data Analysis provides a full featured ER Diagrammer, Database Browser, Query Builder, and Editor for the following databases:

Oracle
SQL Server
DB2 (LUW and z/OS)
MySQL

Most companies have additional databases that they need to connect to and query. To help achieve this, Toad provides basic connectivity, querying, and reporting functionality using the Microsoft Excel, Microsoft Access, and ODBC providers. The inclusion of these additional providers should address the reporting requirements for most companies.

The purpose of the ODBC provider is to offer basic connection and querying capabilities to any database that supports an ODBC 3.0 or later driver. For a list of databases tested with the ODBC provider, see the System Requirements. This form of connectivity allows connections to databases such as Sybase, Teradata, IBM iSeries, and Ingres. Because this form of connectivity is generic, it is not full-featured and may not be as robust as the fully exploited providers for the other databases.

Key Features in This Release

Toad for Data Analysis provides tools that help you succeed in your query and reporting goals. Many of these tools are considered Best Practices and are beneficial for individual users as well as managers. Key features can be grouped into the following categories.

Review the following:

Updates to Toad for Data Analysis 1.1.0
Features in Toad for Data Analysis 1.0.0

Updates to Toad for Data Analysis 1.1.0

General

Performance Improvements―We are excited to announce major memory improvements for queries that return large result sets in the Editor result sets and the Database Browser Data tab! The memory only increases by a couple of megabytes initially regardless of the size of the result set. Subsequent scrolling of the result set only reads into memory what is needed to display.
Default window to open when connecting—A separate window no longer prompts you to associate a default window to open when initially connecting to Toad. You now specify the default window to open in the Configuration wizard.

Understand

Generate SQL drop script―You can now select Drop Script from the Generate SQL right-click menu in the Database Browser or Object Palette.
Generate SQL retains Formatter settings―When using the right-click menu to generate SQL in the Database Browser or Object Palette, the settings specified in the Formatter Options pages are now retained.

Query

Query Builder:
- Heterogeneous query support―You can now add tables and views from multiple databases to create a query that combines the generated results.
- From clause subquery support―You can now add a subquery to a From Clause using the Query Builder toolbar or the right-click menu. A Queries panel displays on the left side of the window with the From Clause subquery. You can add tables and views and create joins the same way you normally use the Query Builder.
  
  After creating the subquery, click the parent query in the Queries panel to return to the original query. A From Clause Subquery table now displays in the Diagram panel with all the columns in the subquery. Use this new table as you would any other database object.
- Date ranges―When you add a Where condition for a column that uses a DateTime data type, a new Date Range tab displays in the Where Condition window. The Date Range tab allows you to select a plain text tag such as, “Today,” “Last week,” “Last 30 days,” and “Current year.” The tag you select is added to the Where condition of your query and when executed, is substituted with a BETWEEN command using the appropriate date range. Date Range tags can also be used in the Editor so you can create queries manually.
  
  Date Range tags are also useful when executing SQL statements from Automation. You no longer have to edit regularly executed queries to change a date range when you need to retrieve data every month for the previous month.
Editor:
- View scripts in a full size window―Use docking controls to auto-hide or group the Editor panel, Code Navigator, and result sets. To display the Editor and Results panels in a separate, full size window, drag-and-drop the Results tab into the Editor window. Press F6 to switch between the two panels.
- Error line highlighting―Ability to highlight the line in the Editor that caused an execution error. To do this, double-click the error message in the Script Output tab.
- Change case and add comments―You can now change the case of text or comment or uncomment a line by selecting Editor | Advanced or from the Editor's right-click menu.
Query Results:
- Grid customization―You can now customize the grid style when a skin is applied to Toad. You can modify this setting in the Configuration wizard (Tools | Configuration Wizard) or in Interface Options (Tools | Options | Environment | Interface).
- Read-only data―You can now set an option to make all data grids read-only by default.
- Search data―Ability to search data grids for word or phrase matches by pressing CTRL+F. Clicking Mark All in the Find window highlights all cells in the grid that match the find criteria.
Version Control―Added support for the following additional version control providers:
- Subversion
- CVS

Features in Toad for Data Analysis 1.0

Define

One tool to query all databases―Connect to any database type for basic query needs. Using one tool for all platforms makes it easier to learn and train others. Create common connections, reports, and files that can be shared by all users. This ensures consistency throughout your organization.
Customized look and feel―Customize the look and feel of Toad for Data Analysis to fit your workflow or to match existing applications like Toad for Oracle, SQL Navigator, or native database tools using the Configuration wizard.

Organize related information for easy access―Add ER Diagrams, queries, and reports to the Project Manager to provide significant time savings. The Project Manager also provides the following time-saving features:
- Create multiple projects to manage and track related tasks for each customer request.
- Double-click files in the project to quickly load them for review or execution. You can also add favorite web sites and directories.
- Use the To-Do list to track items you need to complete and set reminders.

Understand

Visualize database relationships―Database schemas can be difficult for new users to understand. The ER Diagram displays the database relationships between tables to reduce the learning curve.

The ER Diagram also provides the following useful features:
- Hide columns that are rarely used so users can focus on critical information.
- Add manual relationships to commonly used joins in queries.
- Save, share, or use ER Diagrams as a template for building queries.

View master detail relationships―Analyze data in parent tables and drill-down to data in related child tables with the Master Detail Browser.
Browse and edit database tables and objects―Quickly locate objects of interest by setting a filter in the Object Palette. Once located, use the Database Browser to view details such as indexes and constraints, and to edit data.
Add notes to objects―Create notes in the ER Diagrammer, Master Detail Browser, Object Palette, or Query Builder to help users learn more about specific tables and columns. Any notes added from one feature are available in the other features that support notes.

Query

Build complex queries visually―Build complex queries and subqueries visually with the Query Builder. The Query Builder includes the following beneficial features:
- Add Lookup tables to a column for easy filtering.
- Use bind variables to optimize a query.
- Annotate tables, relationships, or the actual diagram with notes.
- Save or share the query for future use.
Utilize a full-featured SQL Editor―Create, test, and execute scripts from the SQL Editor. The following features increase productivity and ensure consistency in your organization:
- Look up an object while typing using Code Completion.
- Insert snippets of code included with Toad or create your own.
- Format code to company standards.
Compare and synchronize data―Compare data between Oracle, SQL Server, and MySQL databases. If differences between two values exists, use the Viewer to display the values side-by-side. After comparing the data, you can synchronize it.

Report

Export data in one click―Export data to a file, an Excel instance, a pivot table, or a linked query with a single click. Linked query reports are ideal for distribution to users who need to see changes to data without waiting for scheduled updates or for new reports to be distributed.
Export data from a wizard―Use the Export Wizard when you need more control over the output format, column delimiters, or want to generate INSERT statements.

Automate

Automate and schedule tasks―Automate and schedule frequent tasks by dragging-and-dropping them into a visual script designer. You can schedule long running queries to execute during off-hours and can automatically export the results to Excel. You can also add these tasks to the Project Manager, and then double-click them to execute them. Automation offers an extension to your work day without you having to be there.
Publish files and reports―Publish and share files and reports via email, network share, or web site with your business community.

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad for Data Analysis:

Resolved issues and enhancements in 1.1.1
Resolved issues and enhancements in 1.1.0

Resolved Issues and Enhancements in 1.1.1

Feature	Platform	Resolved Issue	Change Request
Automation
	All	You can now send email to SMTP servers that require authentication before an email can be sent. To do so, specify the username and password for your email account in either the Send Email window or property grid when adding the SendEmail activity.	CR#44731
	All	Adding a Toad Report activity and attempting to browse to the report no longer results in an error.	CR#43465 Case#581000
Connection	Sybase	You can now connect to a Sybase ASE server from Toad. Quest has tested the connection on a Sybase ASE 12.5.4 server.	CR#43400 Case#586270
Editor	Oracle	Queries that contain an invalid date, such as a negative date out of range, no longer return a System.ArgumentOutOfRangeException error. They now display as null values and an error message displays in the Output window.	CR#42651 Case#562071 Case#573179
Editor	ODBC	When dragging a table from the Object Palette and dropping it in the Editor, you can now include the schema name. To do so, select the Use fully qualified object names checkbox under Tools \| Options \| Editor \| Drag and Drop.	CR#43022
Export Wizard/ One Click Export	All	When exporting data to Excel, numeric data now includes a comma when using the German regional setting.	CR#43763
Export Wizard/ One Click Export	Oracle	You can now export data that contains bind variables to Excel using One Click Export.	CR#43337 Case#582822
Query Builder	All	You can now add Left and Right Outer joins in heterogeneous queries. Full Outer joins are not supported.	CR#42975
	Excel	You can now create a heterogeneous query using Excel.	CR#43464
	Oracle SQL Server	Attempting to create a join between Oracle and SQL Server no longer results in the following error: "ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Invalid use of Null."	CR#44592 Case#594334
	ODBC - Informix	Saving a Query Builder file and then re-opening it no longer results in an "Index was outside the bounds of the array" error.	CR#45787 Case#596747

Resolved Issues and Enhancements in 1.1.0

Feature	Platform	Resolved Issue	Change Request
Automation
	All	Attempting to switch to another connection when testing an Automation script no longer results in an error.	CR#219209
	All	When scheduling an automation script to execute, Job Management no longer appends a "1" to the end of the task and filename.	CR#220005
Data Diff Viewer	All	Comparing a script results grid with an XSD file is now supported.	CR#219662
Database Browser/ Object Palette	All	Attempting to edit duplicate data on a large table no longer results in Toad hanging.	CR#214782
Database Browser/ Object Palette	All	A Microsoft .NET Framework issue no longer causes an exception error when you attempt to browse the Data tab for a table containing a decimal value with a precision greater than 28 or 29.	CR#220590
Editor	ODBC	Creating a table in the Editor, and then selecting View \| Refresh All no longer causes Toad to hang.	CR#215341
	All	If you have a transaction in the Editor that has not been committed, and then attempt to insert data in the Database Browser for the same table used in the Editor's transaction, Toad no longer hangs.	CR#221778
	Oracle	If a statement contains a semicolon before the end of the statement, attempting to execute a block of code in that statement no longer results in an "ORA-06550...PLS-00103: Encountered the symbol 'end-of-file' when expecting one of the following..." error.	CR#213350
Export Wizard/ One Click Export	Oracle	Exporting data using Fixed Column Width as the output format no longer results in a System.OutOfMemory error.	CR#221833
Export Wizard/ One Click Export	All	Exporting data to a linked query no longer results in an "Old format or invalid type library" error.	CR#220866
Import Wizard	Oracle	Toad no longer hangs and shuts down when attempting to import an Excel file into an Oracle table from the Object Palette.	CR#222565
Master Detail Browser	Oracle	You can now create a manual relationship between a parent and child column that have a different data type.	CR#222769
Object Search	Oracle	When searching the source code of procedures, Toad no longer hangs for some Oracle schemas.	CR#222542
Query Builder	DB2 Oracle	In the Result Sets tab, you can now right-click the data grid and select Row Count without an error displaying.	CR#223701
Query Builder	Oracle	When using the Oracle Direct Connection method (Direct tab in the Create New Connection window) adding a table to the Query Builder and executing a query no longer generates a "System.Exception: NET: Unknown error 1".	CR#223454

Known Issues

The following is a list of issues known to exist at the time of Toad for Data Analysis release.

Feature	Platform	Known Issue	Change Request
Installation/ Upgrade	DB2	If you have multiple versions of Toad for DB2 or Toad for Data Analysis installed and you uninstall the product that was installed first, you might encounter errors when you start up the other Toad products. The error contains a call stack trace: "System.NullReferenceException Object reference not set to an instance of an object. Stack Trace: at Quest.Toad.DB2.Common.DB2Utils.EnumerateClients (ClientInfo&defaultClient) at Quest.Toad.DB.DB2Provider..ctor()" Workaround: If you encounter this error when you start up a remaining Toad product, do the following: Close Toad. Open *Start \| Programs \| IBM DB2 \| Toad_DB2_copy* \| Setup Tools \| Default DB2 Selection Wizard*, where Toad_DB2_copy* is the DB2-installed copy of the Toad product (for example, TOADC31). Run the Default DB2 Selection wizard, specifying the Toad product as the default DB2 copy. Restart Toad.	CR#228164
Automation	All	Currently, reports that require bind variable inputs are not supported.	CR#218790
Data Compare	Oracle	On an Oracle 9.2 client with NLS_LANG set to UTF8 only, Unicode characters are not supported. All other Unicode settings on an Oracle 9.2 client function properly.	CR#218641
Data Compare	Oracle	Attempting to synchronize data that contains a LONG RAW data type results in a "System.OutOfMemoryException" error. Workaround: Alter the table that contains the LONG RAW data type and replace it with a LOB data type.	CR#223458
Data Reports	All	Currently, you cannot crate a Label Report in the Toad Data Report wizard.	CR#215945
Export Wizard/ One Click Export	All	Binary data types cannot be exported in this release.	CR#170430
Import Wizard	All	Currently, you cannot import Excel 2007 files because they are saved using an xlsx format. Workaround: Save the Excel 2007 file as a 2003 compatible file before importing it.	CR#221667
Query Builder	ODBC Access	Currently, you cannot create a heterogeneous query between an Access database and an ODBC connection to a SQL Server database that is case-sensitive. Workaround: Connect to the case-sensitive SQL Server database using the SQL Server provider in Toad and then create the heterogeneous query to the Access database.	CR#227341
	Oracle Access	Currently, you cannot create a heterogeneous query between and Access database and an Oracle database that uses non-standard table names.	CR#226759
	DB2	Currently, you cannot create a heterogeneous query from a DB2 client connection. Workaround: Connect to the DB2 database using an ODBC connection.	CR#224965

Third Party Known Issues

The following is a list of third party issues known to exist at the time of Toad for Data Analysis release.

Feature	Platform	Known Issue	Change Request
Connections	Oracle	(Oracle 10.2.0.1 client only) Attempting to connect to an Oracle database From Toad using the 10.2.0.1 Oracle client results in the following error: “ORA-24909: call in progress. Current operation cancelled”. This is a known issue with this Oracle client (http://www.dbmotive.com/oracle_error_codes.php?errcode=24909). Workaround: Upgrade your Oracle client to a later version and connect to the Oracle database.	N/A
Connections	Oracle 11 only	When connecting to Oracle 11, you must enter the password in the proper case because passwords are case-sensitive.	CR#224546
Database Browser/ Object Palette	Oracle 11 only	When creating or altering a user you must enter the password in the proper case. You do not need to surround the password with double quotes.	CR#224546
Excel	All	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.	CR#222833
Export Wizard/ One Click Export	All	In order 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	CR#138239
Export Wizard/ One Click Export	All	Exporting large datasets to Excel (approximately 650,000 rows) is not recommended because of the amount of time it may take. This issue occurs because the Excel export component maintains the output in memory until the export completes. This can cause performance issues depending on the available system resources.	CR#219754
Import Wizard	All	Importing large datasets 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 for Data Analysis, ensure your client system meets the following minimum hardware and software requirements:

Platform	600 MHZ minimum
Memory	512 MB of RAM minimum, 768 MB 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	345 MB of disk space to run Toad.
Operating System	Windows^® 2000 Note: The Automation feature requires the .NET Framework 3.0, which is not supported on Windows 2000. Windows 2003 Windows XP Professional (32-bit or x64) Windows Vista (32-bit or x64)
Additional Software	.NET Framework Microsoft .NET Framework 2.0 or 3.0 Notes: Consider the following: In order to run Toad, the .NET security policy must be set to unrestricted. For more information, see User Privilege Requirements. In order to use the Automation feature, the .NET Framework 3.0 must be installed. The .NET Framework 3.5 is currently not supported. Web Browser Microsoft Internet Explorer 6.0 or later PDF Viewer Adobe^® Acrobat^® Reader 5.0 or later (for viewing the Getting Started Guide) Microsoft SQL-DMO 8.0 (SQL Server native provider only) This component is included if client connectivity is installed. Existing DB2 client support (DB2 native provider only) Toad installs a DB2 9 client as part of the installation process. The DB2 9 client can co-exist with an existing DB2 8 client; however, it is incompatible with a DB2 7 client. If a DB2 7 client is already installed on the system where you are installing Toad, you must upgrade to the DB2 8 client before installing Toad to avoid losing functionality in some DB2 native tools.

Server Requirements

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

Database Operating System

Oracle Native Provider

IBM AIX 5.1, 5.2, 5.3
HP-UX 11i 1.5, 2 (32- and 64-bit)
Red Hat Enterprise Linux AS release 3 and 4 (32 and 64-bit)
Solaris 7, 8, 9, 10 (32- and 64-bit)
SuSE 7, 8, 9
Windows 2003 (including 64-bit)
Windows XP

SQL Server Native Provider

Windows 2000 Server with SP4 or later
Windows 2000 Professional Edition with SP4 or later
Windows 2003 Server (32-bit or x64 with SP1 or later)
Windows XP (32-bit with SP2 or later; x64)

DB2 UDB for z/OS Native Provider

z/OS (V1R6 Base Services [5694-A01] or later)

DB2 UDB for LUW Native Provider

IBM AIX 5.1, 5.2, 5.3
HP-UX 11i 1.5, 2 (32- and 64-bit)
Red Hat Enterprise Linux AS release 3 and 4 (32 and 64-bit)
Solaris 7, 8, 9, 10 (32- and 64-bit)
SuSE 7, 8, 9
Windows 2000, 2003 (including 64-bit), XP

MySQL Native Provider

Windows 2000 with SP4 or later
Windows 2003
Windows XP

Supported Databases

The following databases have been tested in this release.

Important Note: Toad supports ODBC database connections that use ODBC 3.0 driver specifications.

Oracle Native Provider

Oracle 9i
Oracle 10G
Oracle 11

SQL Server Native Provider

SQL Server 2000 with SP3
SQL Server 2005 with SP2

Note: Microsoft SQL Server Compact Edition is not supported.

DB2 UDB for z/OS Native Provider

DB2 UDB for z/OS 8.1 or later

Note: Toad supports DB2 for z/OS running in Full Function mode, but does not support DB2 running in Compatibility mode at this time.

DB2 UDB for LUW Native Provider

DB2 UDB for LUW 8.1.5 or later
DB2 UDB for LUW 9.0

MySQL Native Provider

MySQL 4.1.22
MySQL 5.0.41

Access ODBC

Access 2003
Access 2007 (limited testing)

Excel ODBC

Excel 2003
Excel 2007 (limited testing)

DB2 for i5/OS ODBC

V5R3
V5R4

Informix ODBC

Informix Dynamic 10.00 (limited testing)

Sybase ODBC

ASE 12.5.4 (limited testing)

Teradata ODBC

V2R6.1 (limited testing)

User Privilege Requirements

The following user privileges are required for installing and running Toad for Data Analysis:

Only Power users and Administrators can install Toad.
If a Power user installs Toad, a Restricted user can run the application but cannot
- Associate file extensions.
- See the Toad shortcut icon on the desktop or the Toad menu option in the Windows Start menu. As a workaround, Restricted users can create a shortcut to the application and place it on their desktop from the install directory.
If an Administrator installs Toad, the Administrator can share the Toad shortcut icon on the desktop and the Toad menu option in the Windows Start menu with any user on the computer.
A Power User or Restricted User must belong to the DB2ADMNS or DB2USERS group. To add the user to one of these groups, select Start | Control Panel | Administrative Tools | Computer Management | System Tools | Local Users and Groups | Groups | DB2ADMNS or DB2USERS.
In order to use Toad with DB2 for z/OS, any user who does not have SYSADM privileges must be granted SELECT permissions on the DB2 catalog tables.
In order to run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

From the Windows Start menu, select Settings | Control Panel.

Double-click Administrative Tools.

Double-click Microsoft .NET Framework 2.0 Configuration.

Click + to expand My Computer, and then select the Runtime Security Policy node. A list of tasks for the node display in the right panel.

Click Evaluate Assembly from the list of tasks in the right panel. An Evaluate an Assembly window displays.

Browse to the location of Toad.exe in the File field.

Click Next to view permissions for Toad.exe.

Set the permission to Unrestricted.

In order to set or modify Toad Security settings, users must have privileges to create the QuestSoftware.ToadSecurity table if it does not exist. If the table does exist, users must have privileges to insert, update, and delete the QuestSoftware.ToadSecurity table.
Power users and Restricted users do not have the authority to add or remove DB2 catalog entries using the Toad Client Configuration wizard. However, these users can use the Import Profile function to import catalog entries to Toad.

Citrix Requirements

Toad has been tested for Citrix support on Windows Server 2003 Enterprise Server Service Pack 2 using the Metaframe Access Suite 3.0 and Citrix Presentation Server Clients 10.0. For information about installing Toad in a Citrix environment, see Install Toad on Citrix Systems in the Toad for Data Analysis Getting Started Guide.

Silent Install Requirements

Before you perform a silent installation, the following software must be installed on every system on which you are installing Toad:

Microsoft .NET Framework 2.0 or later
(SQL Server native provider only) Microsoft SQL-DMO
(DB2 native provider only) Toad installs a DB2 9 client as part of the installation process. The DB2 9 client can co-exist with an existing DB2 8 client; however, it is incompatible with a DB2 7 client. If a DB2 7 client is already installed on the system where you are installing Toad, you must upgrade to the DB2 8 client before installing Toad to avoid losing functionality in some DB2 native tools.

For information about installing Toad silently, see Install Toad Silently in the Toad for Data Analysis Getting Started Guide.

Global Operations

For more information, see http://tda.inside.quest.com/shares/tda/sbin/docs/GlobalOps.htm

Getting Started

Contents of the Release Package

The Toad for Data Analysis release package contains the following products:

Toad for Data Analysis 1.1.1
Product Documentation, including:
- Getting Started Guide
- Online Help
- Release Notes

Installation Instructions

For important installation information, see the Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for Data Analysis 1.1 | Documentation.

For More Information

Get the latest product information, find helpful resources, and join a discussion with the Toad for Data Analysis team and other community members. Join the Toad for Data Analysis community at http://tda.inside.quest.com/forumindex.jspa?categoryID=144.

Contact Quest Software:

Email	info@quest.com
Mail	Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA
Web	http://www.quest.com

Refer to 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 commercial version and have a valid maintenance contract. Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

Quickly find thousands of solutions (Knowledgebase articles/documents).
Download patches and upgrades.
Seek help from a Support engineer.
Log and update your case, and check its status.

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

This document 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.

Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

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

Disclaimer

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.