Toad® for SQL Server

Version 3.0.0

Release Notes

June 2007

Contents

Welcome to Toad for SQL Server

Toad for SQL Server is a database development and administration solution that provides productivity features for rapidly creating and executing queries, automating database object management, developing SQL code, and instant access to SQL Server expertise.

Developers and administrators have access to a community of users, peers, and experts to help solve development and administration issues and assist in developing applications and feedback for improving Quests products.

All of this comes with the backing of Quest Software, a healthy and growing corporate entity that can provide the necessary training, support, and superior customer service demanded by IT management.
 

Back to Top

New in This Release

Updates to Toad for SQL Server 3.0

• General:

  • Tab Renaming - Ability to rename tabs in document windows by pressing F2 or by right-clicking the tab and selecting Rename Document.

• Connections:

  • Connection Organizing - Reorganize connections and groups in the Connection Manager using drag-and-drop. View screencast.
  • Connection Renaming - Rename connections and groups in the Connection Manager by pressing F2 or by right-clicking an item and selecting Rename.
  • Service Management - Start, stop, or pause database services in the Connection Manager by right-clicking a connection.
• Data Grid:
  • Side-by-Side Grid Views - The Card View now displays beside the current Grid View when selected.
  • Row Copy Support - Copy multiple cells of data by pressing CTRL+click on each cell, and then right-click and select Copy Rows.  
  • Preview Data - Add a preview line to each row in the grid to view detailed data under Tools | Options | Environment | Grid.
  • Line Numbers for Data - Add a line number to the margin in the data grid to quickly locate or reference a row when working with colleagues. This feature is available under Tools | Options | Environment | Grid.
  • Merge Results - Display results in a single, stacked data grid if a query returns multiple results under Tools | Options | Environment | Grid.
• Database Browser/Object Palette:
  • SQL Server 2005 Objects - Additional support for SQL Server 2005 types, including Assemblies and Security object-types (Asymmetric Keys, Symmetric Keys, Credentials, etc.).
  • Primary Key and Not Null Indicators - Easily identify primary key columns and columns that do not allow null values using new indicators in the Data tab. A key icon beside a column represents a primary key; and a column name that displays as blue text represents a "not null" column. The "Not nulls" indicator is also available for query result sets in the Editor, but the   primary key indicator is not available.
  • Filtering - Support for server-side filtering with the ability to name a filter.
  • Permissions - Separate Permissions editor for databases, tables, views, stored procedures, and functions that is easily accessed from the object toolbar.
• Editor:

  • Query Execution - Increased performance with regard to query execution time.

  • Query Result Enhancements - Automatically expand collapsed query results when executing scripts. If the splitter for the embedded results pane is collapsed, you can execute a script (F5), SQL statement (F9), or verify SQL to automatically expand the results. View screencast.

  • Intellisense - Add an asterisk as the first entry in the auto-completion list for columns. If you
    select the asterisk, all columns for the table are added to the list. This feature is available in Tools | Options | Editor | Toad Insight.

• ER Diagrammer:

  • Manual Relationships - Ability to create manual relationships.

  • Diagram Schema - Quickly diagram all tables in a schema.

  • Query Builder Integration - Send a diagram to the Query Builder

• Project Manager:

  • New Toolbar - A new toolbar lets you quickly create a new project or navigate to other projects.

  • To-Do Items - Keep up with project or daily tasks using new To-Do Items. If you give the item a due date and the item is past due, the item's text turns red. You can also add extensive notes to the item, which display in a tool tip when you hover the cursor over the item in the Project Manager.

• Options Pages:

  • Tree View - Options pages now use a standard tree view so you can quickly navigate between pages.

  • Modeling - Options from the Modeling page have been broken into two new pages: Diagramming and Query Builder.

  • Network Share - You can now specify a location where you can share reports from the Report Manager or files and directories from the Project Manager with your colleagues.

• SQL Tuning - 2005 schemas are now supported.

• Version Control: 

  • Object and SQL Script Support - In addition to files, you can now archive revisions to database objects and SQL Scripts from the Database Browser.

  • Version Control Setup Wizard - A new, user-friendly wizard now helps you configure version control to work with Toad.

  • Robust Integration with VCS Vendors - Toad is providing a more in-depth integration with popular VCS vendors. Currently, Toad has integrated version control with Visual Source Safe.

New Features in Toad for SQL Server 3.0

• General:
  • Add Notes to Objects - Quickly add notes to objects in the Database Browser, Object Palette, ER Diagram, and Query Builder.
• Data Grid:
  • One-Click Export - Easily export data using default settings from the Editor, Query Builder, and Database Browser.
• Database Browser/Object Palette:
  • Object Lists - Group different types of objects in the across a server instance. This is useful if you frequently work with a few database objects on a server and want to quickly access them in the Database Browser.
  • Duplicate Data Editor - Ability to edit or delete duplicate rows of data for tables. To access this feature, right-click a table and select Edit Duplicate Data.
• Microsoft Excel Integration - Open existing reports or spreadsheets without leaving Toad.
• Diff Viewer - Compare differences between DDL, data, or other types of files using the new Diff Viewer.
• Job Management - Manage your SQL Server jobs across multiple servers in an Outlook-type view.

• Reports Manager - Quickly manage reports or use canned reports provided by Toad.

• Spotlight Integration - Monitor your SQL Server databases from Toad if Spotlight for SQL Server is installed.
• Troubleshooting:
  • SQL Trace Support - Log information for all executed SQL to a file or the Output window by enabling SQL Trace. You can store trace information in a log file or display it in the Output window.
  • Troubleshooting Help - Use Troubleshooting topics in the online help to resolve connection, debugging, and other issues you might encounter.
• Web Search - Google without leaving Toad using the new Web Search feature! Customize your searches by adding your own search engines or web sites under Tools | Options | Environment | Quick Search.

Back to Top

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release of Toad for SQL Server.

Back to Top

Known Issues

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

Back to Top

Third Party Known Issues

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

Back to Top

Upgrade and Compatibility

For information about upgrading refer to the Getting Started Guide available from the Windows Start menu under Program Files | Quest Software | Toad for SQL Server install_type 3.0  | Documentation.
 

Back to Top

System Requirements

Client Requirements

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

Server Requirements

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

User Privilege Requirements

The following user privileges are required for installing and running Toad for SQL Server:

• Only Power users and Administrators can install Toad.
• If a Power user installs Toad, a Restricted user can run the application but cannot
  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.
• In order to run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

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

2. Double-click Administrative Tools.
3. Double-click Microsoft .NET Framework 2.0 Configuration.
4. 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.
5. Click Evaluate Assembly from the list of tasks in the right panel. An Evaluate an Assembly window displays.
6. Browse to the location of Toad.exe in the File field.
7. Click Next to view permissions for Toad.exe.
8. 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.
   

Debugging Requirements

Verify the following general requirements to ensure that the Debugger operates properly for all SQL Server installations:

• Disable all firewalls or open corresponding ports. Windows XP SP2 includes an embedded Windows firewall that should be disabled or ports opened as well.
• Stop any antivirus software that can lock the corresponding components, settings, etc.
• Check your security policy because it may include an access lock to the remote server. Note that the security policy can be applied to the domain or local computer.

Note: Currently, you cannot debug SQL/CLR code.
 

SQL Server 2005 Prerequisites

To debug locally, perform the following on the client machine:

1. Install the SQL Server 2005 Workstation Component option of the SQL Server 2005 installation.
2. In Toad, commit or rollback the connection before starting the debugging session.

To debug remotely, perform the following:

1. On the client machine, install the SQL Server 2005 Workstation Component option of the SQL Server 2005 installation.
2. Copy and register the ssdebugps.dll (debugging host component) on both the client and server. This file is located by default in the following directory on the server where SQL Server 2005 is installed:

C:\Program Files\ Common Files\Microsoft Shared\SQL Debugging

To register this file, open a command prompt and enter the following command: regsrv32 ssdebugps.dll

Note: If you are unable to locate this file, you can run the remote debugging setup component (rdbgsetup.exe). This file is located by default in the following directory on the server where SQL Server 2005 is installed: C:\Program Files\Microsoft SQL Server\90\Shared\1033

3. Make sure the following permissions are set:

• Your Windows login must be a member of the SQL Server sysadmin group on the computer where Toad is installed and the computer where SQL Server 2005 is installed.

• Your Database login (Windows or SQL Server Authentication used when connecting to SQL Server 2005) must be a member of the sysadmin role. To add your Windows login to the sysadmin role, execute the following:

sp_addsrvrolemember 'Domain\Name', 'sysadmin'

where Domain\Name is your Windows login

4. In Toad, commit or rollback the connection before starting the debugging session.

Platforms Tested for Debugging Support

The following platforms have been tested for debugging support.

Note: The Service Pack on the client must match the Service Pack on the server unless specified otherwise.

Back to Top

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. In this release,
all product components should be configured to use the same or compatible character
encodings and should be installed to use the same locale and regional options. This
release is targeted to support operations in the following regions: North America,
Western Europe and Latin America, Far-East Asia, Japan.

This release has the following known capabilities or limitations:

• Toad for SQL Server Xpert Edition ONLY -- other versions of Toad for SQL Server  are fine.
  The SQL Tuning feature does not support non-ASCII characters properly: display, processing, and editing of scripts in SQL Tuning may result in improper display of data and in some cases, unintentional data degradation. Support for Western European or other single-byte Windows code pages and/or configurations may work appropriately, but these configurations have not been thoroughly tested and this portion of the product should be used with caution in these environments. SQL Tuning does not support multi-byte processing or display and should not be used with multi-byte scripts or data.

• Toad Editions that contain Knowledge Xpert.
  The Knowledge Xpert feature is available with English language content only.

Back to Top

Getting Started

Contents of the Release Package

The Toad for SQL Server release package contains the following products:

• Toad for SQL Server version 3.0.0
• Product Documentation, including:
  • Getting Started Guide
  • Online Help

Installation Instructions

For important installation information, refer to the Getting Started Guide available
from the Windows Start menu under Program Files | Quest Software | Toad for SQL Server install_type 3.0 | Documentation.
 

Back to Top

For More Information

Contacting Quest Software:

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

Contacting 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.

Back to Top

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.

© 2007 Quest Software, Inc. ALL RIGHTS RESERVED.

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:

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.

Back to Top