Toad^® for SQL Server

Version 4.5.0  

Release Notes

August 27, 2009

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, as well as 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.

Quest Software, Inc., a leading enterprise systems management vendor, delivers innovative products that help organizations get more performance and productivity from their applications, databases, Windows infrastructure and virtual environments.

Back to Top

New in This Release

Review the following sections for updates in this release and new features:

• Prerequisites/Installation
• General
• Automation
• Database Administration
• Data Management
• Query Development
• Project Management
• Version Control
• SQL Optimizer (See the SQL Optimizer for SQL Server Release Notes for a list of new features.)

Prerequisites/Installation

• Toad now requires .NET Framework 3.5 (Service Pack 1) or later. You can download the latest .NET Framework at: http://www.microsoft.com/Net/Download.aspx

• Because of the new .Net Framework 3.5 (Service Pack 1) requirement, Toad can no longer be installed on Windows 2000 systems. However, Toad can still connect and manage databases running on Windows 2000 systems.
• On Windows XP and Windows Server 2003 platforms, the default location for settings files has been changed to: C:\Documents and Settings\Username\Application Data\Quest Software\Toad for SQL Server 4.5 to provide an easier installation for Citrix environments and for those customers with support for roaming profiles. On Windows Vista and Windows Server 2008 platforms, the default location for settings files has been changed to: C:\Users\Username\AppData\Roaming\Quest Software\ Toad for SQL Server 4.5 to provide an easier installation for Citrix environments and for those customers with support for roaming profiles.

General

• Toad now provides support for SQL Server 2008, including the following data types: DATE, TIME, DATETIME2, DATETIMEOFFSET, FILESTREAM, HIERARCHYID, GEOMETRY, GEOGRAPHY, and User-Defined Table Types.
• Toad provides a faster connection time when creating new connections.

• Document recovery now works with any ER Diagram or Query Builder files to avoid losing your work. When you restart Toad after an unexpected close, Toad checks the timestamp on the backup file against the original file, and opens the file that has the latest timestamp. The document recovery option is located in Tools | Options | Environment | General.

• Connection information for each Editor, Query Builder, or other document window is now available by selecting the Show connection info on document tabs checkbox under Tools | Options | Environment | General.

• You can close the current tab in a window or all other tabs except the current one from the right-click context menu available on each Editor tab.

• You can use the new File Transfer Protocol (FTP) utility to transfer scripts, reports, or other files to and from an FTP server. Toad supports unsecured (FTP) and secure (SFTP) file transfers. To open this utility, select View | FTP Connections from the menu.

  Right-click one or more files in the local or remote directory to upload, download, delete, or rename the files.

  You can also add an FTP connection in the Project Manager or as an activity in an Automation script.

• Knowledge Xpert has been removed from Toad. Knowledge Xpert resources have been moved to the web at: http://www.sqlserverpedia.com/wiki.

Automation

• Most activities now include support for variables. Variables allow you to change data in your script or use a dataset collected from an activity in the automation script. For example, you can use variables to perform the following tasks:  

• Send an email to a group of people where the list of recipients is automatically selected with a query
• Generate repetitive reports where only the product number, date, region, or any other single element changes
• Customize file names by including a variable in the file name or automatically including the date that the automation script ran

• Find content in a file and replace it with the value of a variable

See "Use Variables in Automation" in the Toad help for more information.

• Support for Find and Replace and FTP file activities.

• Support for new system activities, including running programs, setting variables, if conditions, while, and loop datasets.

• The Select to File activity now supports Excel options.

  
  

Database Administration

General

• The Create menu has been removed because it duplicated functionality in the File menu. To create objects from a menu, select File | New | ObjectType.
• Toad provides improved DDL script generation by reorganizing the order in which objects are scripted.

• Toad now includes a library of 45 Code Snippets designed to help DBAs better understand SQL activity, retrieve server, database, and object information, and perform administration functions like determining fragmentation, estimating data compression savings, and managing traces. You can execute these DBA queries from the DBA Queries folder in the Code Snippets window or search for them using the DBA or DMV keywords.

Object Explorer

• Double-clicking an object in the Object Explorer now opens an Alter window by default. To display the Object Viewer window, right-click an object and select View Details. You can switch the default double-click behavior by selecting Open details in Tools | Options | Explorer | General.
• Code completion is now available when using object editors.

• You can now send the script for a user, role, schema, or login to the Editor by selecting Send To | Editor as Script in the Object Explorer.

• You can now send the script for a MERGE statement for tables (SQL Server 2008) to the Editor by selecting Generate SQL | To Editor | Merge Statement in the Object Explorer.
• You can now send the script for an EXECUTE statement for a stored procedure to the Editor by selecting Generate SQL | To Editor | Execution Script in the Object Explorer.
• When editing objects in the Alter window or sending ALTER statements to the Editor, Toad now uses data directly from the database instead of using the cache.

• You can start or stop the SQL Server agent by right-clicking the agent node in the Object Explorer.

• Stored procedures and functions can now be altered in the Editor by right-clicking the object and selecting Alter <object> in Editor in the Object Explorer.
  

• You can now send the script for indexes and triggers to the Editor by selecting Send To | Editor as Script from the Object Viewer pane.

• Index details are now available from the Indexes tab in the Object Viewer pane.

• You can now partition tables and indexes. For tables, you can also create a Sliding Window scenario.

• The Job Manager component has been upgraded to provide more job-level information. You can access the Job Manager by selecting Tools | Administer | Job Manager from the menu or from the Jobs context menu in the Object Explorer.

• The Log Reader component can now be accessed by right-clicking a database in the Object Explorer and selecting Log Reader.

• LiteSpeed integration has improved in the Backup Database window with the addition of LiteSpeed Advanced Options and Attached Files/Directories support.
• Toad now supports SQL Server 2008 native backup compression from the Backup Database window.
• Database backup checks are now disabled by default. You can enable them in Tools | Options | Database | SQL Server.
• Toad now supports a “Create Like” option for Maintenance Plans.

Master Detail Browser

• When sending tables or views to the Master Detail Browser, Toad now automatically selects all columns.

Data Management

General

• Toad is now Federal Desktop Core Configuration (FDCC) Compliant; however changes to the architecture to ensure compliance will result in a loss of existing data filters when upgrading to this release.

• The grid style now defaults to Office Silver. You can modify this setting in Tools | Options | Environment | Interface.
• The TAB key now navigates from cell to cell by default. You can modify this setting in Tools | Options | Environment | Grid.
• Hexadecimal values of up to 255 bytes for binary data now display in the grid.

• You can now create pivot grids and charts directly from the results by selecting the Pivot & Chart tab.

• You can now format XML data.

• You can add a total value to a column of data or can add a subtotal value to grouped data if the Summary Footer Panel is displayed (right-click the data and select Show | Summary Footer Panel). To add a total value, right-click the data and select one of the options.

  If you have grouped columns using the Grouping panel (right-click and select Show | Grouping Panel), you can add a subtotal value to grouped records.

Export Wizard

• You can now export data to Microsoft Access files.

• When exporting to an Excel Instance only, columns are automatically resized to the width of the data.

• You can now create a new table within a database when exporting data.

Data Compare 

• Data compare supports CLR data types in this release. CLR data types are converted to strings so you can compare them to other database providers.

• You can right-click tables or views in the Object Explorer and select Compare Data to compare data within the context of the current connection and database.

• When comparing data, you can now auto-map target columns for selected source tables.

• When selecting a record, Data Compare automatically displays a side-by-side comparison of the values of the source and target row in the Row Viewer tab.

• When synchronizing a script, Data Compare now opens a script in Toad using an existing connection.

Query Development

Query Builder

• You can now sort columns alphabetically in the Diagram pane by selecting an option from the Sort columns in diagram by name drop-down list in Tools | Options | Database | Query Builder.
  

• You can now create a view in the Query Builder.

• When saving a Query Builder file, Toad prompts you to save query results with that file.

• Toad now includes synonym support when reverse engineering a query.

• You can now add a UNIONor UNION ALL operator to queries.

• You can compare results from a Query Builder query to data from the Data tab or Editor results using the right-click menu.

Editor

• Toad now includes support for actual execution plans as well as the existing estimated plans. Click to view the actual plan when you execute the query or click to view the estimated plan.
• You can now press SHIFT+F1 in the Editor to launch a custom search page on SQLServerPedia.com for command-help. Either highlight the search text in the Editor or move the cursor to a particular command and press SHIFT+F1 to open the custom search web page.
• Messages and Script Results are automatically cleared each time you execute a script. You can change this option by clearing the "Clear before executing script" checkbox in Tools | Options | Editor | Tools.

• If Quest SQL Optimizer is installed, you can open it from the Editor context menu.

• (SQL Server 2005 and 2008) You can now open the Microsoft Database Engine Tuning Advisor from the Editor context menu.

• Toad now includes four pre-defined SQL Formats. You can select a pre-defined format or create your own custom formats from Tools | Options | Editor | Formatter.

• You can share Formatter settings for your team in a network share folder in Tools | Options | Editor | Formatter to ensure consistent coding standards. 

Group Execute

Group Execute now generates a single result set that contains the data from the query run on each connection. Toad automatically adds a Connection column to the results to show which connection the data came from.

SQL Recall

Toad supports deleting multiple statements in the SQL Recall window.

Debugger

• You can debug stored procedures with binary, varbinary, bit, timestamp, and image input parameters.
• You can right-click a breakpoint in the Editor to edit its properties.

Project Management

Support for FTP connections, SQL Recall named SQL statements, and Database connections has been added to the Project Manager via the right-click menu. For Database connections, only databases that are currently connected can be added to the Project Manager.

Version Control

• Support for Team Foundation Server (TFS) 2008.
• When configuring TFS, you can now specify a user name and password to log into TFS instead of using your Windows credentials.
• Improved handling of working directory initialization and handling of root folder and working directory.
• Support for multiple version control configurations that are active simultaneously.
   

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 the 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

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:

Citrix Requirements

Toad has been tested 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. See "Install Toad on Citrix Systems" in the Installation Guide for more information.

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

  • 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.
• 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.0Configuration.
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.

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 3.5 (Service Pack 1) or later

For information about installing Toad silently, see "Install Toad Silently" in the Installation Guide.

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 (Service Pack 2) includes an embedded Windows firewall that should be disabled or ports opened as well. Specifically, the TCP 135 port must be opened and Toad.exe must be added to the Exceptions list. The same is true for the remote (SQL Server) computer--TCP 135 port must be opened and sqlservr.exe must be added to the Exceptions list.
• 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: The security policy can be applied to the domain or local computer.
   

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

Configure Debugging for SQL Server 2008 

To debug locally, perform the following on the Toad client

1. Install the SQL Server 2008 Client Tools on the Toad client.

2. If autocommit is disabled, commit or rollback the connection in Toad before starting the debugging session.

To debug remotely, perform the following

1. Install the SQL Server 2008 Client Tools on the Toad client.
2. Make sure the following permissions are set:
   • Your Windows account that Toad is running under must be a member of sysadmin server role in the SQL Server being debugged.

   • Your server login must also be a member of the sysadmin role. This login can be your Windows user account (Windows authentication), or a SQL Server login (SQL Server authentication).

     To create a server login from your Windows account and add it to the sysadmin role, a user who already has sysadmin privileges must execute the following:

     sp_addsrvrolemember 'Domain\Name', 'sysadmin'

     where Domain\Name is your Windows login.

3. If autocommit is disabled, commit or rollback the connection in Toad before starting the debugging session.

Configure Debugging for SQL Server 2005

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

1. Install the SQL Server 2005 Workstation Component option of the SQL Server 2005 installation.

2. If autocommit is disabled, commit or rollback the connection in Toad before starting the debugging session.

To debug remotely, perform the following:

1. On the Toad client, do one of the following:

   • Install the SQL Server 2005 Workstation Components option of the SQL Server 2005 installation.

   • 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: regsvr32 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

2. Make sure the following permissions are set:

   • Your Windows account that Toad is running under must be a member of sysadmin server role in the SQL Server being debugged.

   • Your server login must also be a member of the sysadmin role. This login can be your Windows user account (Windows authentication), or a SQL Server login (SQL Server authentication).

     To create a Server login from your Windows login and add it to the sysadmin role, a user who already has sysadmin privileges must execute the following:

     sp_addsrvrolemember 'Domain\Name', 'sysadmin'

     where Domain\Name is your Windows login

     Note: By default, Windows administrators on a machine running SQL Server are SQL Server sysadmins on that machine.

3. If autocommit is disabled, commit or rollback the connection in Toad before starting the debugging session.

Configure Debugging for SQL Server 2000

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

1. Make sure that SQL Server 2000 with Service Pack 3 or Service Pack 4 is installed.

2. If autocommit is disabled, commit or rollback the connection in Toad before starting the debugging session.

To debug remotely, perform the following:

1. On the Toad client, do one of the following:

   • Make sure that SQL Server 2000 with Service Pack 3 or Service Pack 4 is installed.

   • Copy and register the sqldbg.dll and sqldbreg2.exe (debugging host components) on both the Toad client and server. These files are located by default in the following directory on the server where SQL Server 2000 is installed:

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

     To register these files, open a command prompt and enter the following commands:

     regsvr32 sqldbg.dll

     sqldbreg2.exe /RegServer

   Note: The Remote Procedure Call (RPC) service should be started on both the Toad client and server.

2. Make sure the following permissions are set:
   • Your Windows account that Toad is running under must be a member of the sysadmin server role for the instance you are debugging.

   • Your server login must also be a member of the sysadmin role. This login can be your Windows user account (Windows authentication), or a SQL Server login (SQL Server authentication).

     To create a server login from your Windows account and add it to the sysadmin role, a user who already has sysadmin privileges must execute the following:

     sp_addsrvrolemember 'Domain\Name', 'sysadmin'

     where Domain\Name is your Windows login.

   • DCOM Access permissions must be granted for the system account and the group or user who needs access.

     To verify permissions:

     1. Open a command prompt and run dcomcnfg.exe.
     2. Expand Component Services, Computers.
     3. Right-click My Computer and select Properties.
     4. Select the COM Security tab.
     5. Under Access Permissions, click Edit Default, and verify permissions.

   Note: By default, Windows administrators on a computer running SQL Server are SQL Server sysadmins on that computer.

3. If autocommit is disabled, commit or rollback the connection in Toad 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:

Quest SQL Optimizer for SQL Server—This release supports any single-byte character set. Double-byte or multi-byte character sets are not supported. In this release, all product components should be configured to use the same or compatible character encoding 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.

Back to Top

Installation

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

• Toad for SQL Server version 4.5.0
• Product Documentation, including:
  • Installation Guide
  • Online Help
  • Release Notes

Installation Instructions

For general installation information, see the Installation Guide available from the Windows Start menu under Program Files | Quest Software | Toad for SQL Server | Documentation.

Back to Top

For More Information

Contact Quest Software

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

Note: This document is only available in English. 

Back to Top

© 2009 Quest Software, Inc.

ALL RIGHTS RESERVED.

This document contains proprietary information protected by copyright. The software described in this document 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.

If you have any questions regarding your potential use of this material, contact:

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

Trademarks

Quest, Quest Software, the Quest Software logo, Benchmark Factory, DataFactory, DeployDirector, ERDisk, Foglight, Funnel Web, GPOAdmin, I/Watch, Imceda, InLook, IntelliProfile, InTrust, Invertus, IT Dad, I/Watch, JClass, Jint, JProbe, LeccoTech, LiteSpeed, LiveReorg, MessageStats, NBSpool, NetBase, Npulse, NetPro, PassGo, PerformaSure, Quest Central, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL LiteSpeed, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Tag and Follow, Toad, T.O.A.D., Toad World, vAnalyzer, vAutomator, vControl, vConverter, vEssentials, vFoglight, vMigrator, vOptimizer Pro, vPackager, vRanger, vRanger Pro, vReplicator, vSpotlight, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, 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.

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