Toadฎ for SQL Server
Version 3.2.0 (Click here for previous versions)
Release Notes
March 2008
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.
Review the following:
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 connectingA
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.
Press F6 to switch between the two panels.
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.
Log Reader―Log Reader server components are now supported on x64 servers and Windows Vista.
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.
Added support for the following additional version control providers:
Subversion
CVS
Connection toolbar―Previously, the Connection toolbar was at the bottom of the window and took
up an entire toolbar row, regardless of the number of connections. This has
been replaced with a new Connection toolbar. The new toolbar is located at
the top of the window and lets you switch connections from a drop-down
list. You can also right-click the current connection in the list to select
functionality such as disconnect, disconnect all, etc.
Connections window
(previously the New Connections window)―You can now save
connection information without having to connect by clicking Save.
The right side of the window is now used to modify an existing connection.
In the previous version, clicking Connect would create a separate
connection and connect to it. Now, it connects to the existing connection
saves any changes you have made for that connection.
Editor:
Comment/uncomment lines―You can now comment and uncomment lines of selected text from the Edit menu or via a right-click menu.
Improved Query Performance―Performance
of queries has been increased by up to 10 times (based on internal testing). To
test this enhancement for yourself, select the Unlimited checkbox
beside the Number of rows to initially fetch from a query field under
Tools | Options | Database | General.
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.
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
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.
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.
2005 schemas
are now supported. Refer to the
SQL Tuning Release
Notes for additional features and enhancements.
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.
Reports management―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. You can launch Spotlight using the following methods:
From the Tools menu or the toolbar:
By right-clicking a database in the Database Browser
and selecting Monitor Database Performance:
Graphically create a flow of activities to run or schedule the activities to run at a later time. For example, a single script can run reports, queries, and scripts; save results in Excel spreadsheets and other files; and distribute results to the business community via email or shared file locations. You can also add the automation activities to the Project Manager and double-click them to run them automatically.
Note: Toad Automation requires Microsoft .NET Framework 3.0. If .NET Framework 3.0 is not installed on your system, you are prompted to install it when you try to open the Automation Script Designer.
Automation Activities let you automatically:
Execute Query Builder queries and SQL scripts, then export the results to Excel spreadsheets.
Run Toad reports, then save the results in PDF, RTF, or MHT files.
Create zipped archives for saving or emailing files such as scripts, queries, reports, and ER diagrams.
Place files in a folder such as the Toad Shared folder.
Connect to a database for the SelectToExcel and ToadReport activities. Both require a database connection.
Email the business community and automatically publish results for scripts, queries, and reports. The files generated by an automated script can be emailed by the script.
To access this feature, select Tools | Automation Script Designer from the menu.
The following is a list of issues addressed and enhancements implemented in this release of Toad for SQL Server.
Feature |
Resolved Issue |
Change Request |
Installation/
|
The About Toad for SQL Server window that displays when selecting Help | About now indicates the correct number of licenses for the installation. |
CR#228003 Case#567933 |
If a power user upgrades Toad, installation "Error 1406. Could not write value DisplayIcon to key..." no longer displays. |
CR#222728 | |
Database Browser/ Object Palette |
In some environments, selecting the Object Palette no longer results in an error. |
CR#225295 Case#557571 |
(Database Browser only) The Deps (Uses) & Deps (Used by) tabs no longer display as empty if an extended stored procedure is used. |
CR#117189 | |
Tables |
If you alter a table and rename a Primary Key column that is referenced by a Foreign Key, the Foreign Key now references the updated column name. |
CR#215934 |
|
If an existing table includes a column with a bind default, attempting to use Create Like to create a table on a database that does not already include the default now generate the correct script. |
CR#215934 |
|
(Database Browser only) You can now unbind a column from a rule using the Unbind Column from Rule toolbar button. |
CR#216532 |
Databases |
You can now drop a database you are connected to when:
|
CR#211896 |
Stored Procedures |
Refreshing the Object Palette after compiling a stored procedure no longer results in an "Object reference not set to an instance of an object" error message. |
CR#226690 Case#560779 |
Triggers |
Duplicate entries for a trigger no longer displays in the Database Browser or Object Palette. |
CR#224638 Case#553061 |
Data Grid |
You can display data as read-only when returned for the Editor, Database Browser, or Query Builder by selecting the Show data as read-only checkbox in Tools | Options | Environment | Grid |
CR#207522 Case#499215 |
Debugger |
When connecting to a server that has a date format other than Day-Month-Year, debugging or running a stored procedure with a day greater then 12 no longer results in an error. |
CR#227513 Case#569266 |
Editor
|
An error no longer occurs when executing a script that includes a colon in a label line. |
CR#223788 CR#226358 Case#549976 Case#560696 |
Attempting to tune SQL from the SQL Server Profiler no longer results in a syntax error due to a timestamp. |
CR#220738 Case#538371 | |
Help |
Help windows no longer stay on top of Toad. |
CR#217170 |
Import Wizard |
Selecting more than one file to import no longer causes Toad to hang. |
CR#220341 |
Log Reader |
A timeout no longer occurs when reading large online transaction logs. |
CR#227627 Case#561164 Case#570477 |
You can now select which backup files to read and parse in the Select Backup Files page of the Read Log wizard. |
CR#227627 Case#561164 | |
Menus |
An error no longer occurs when selecting Send to from a menu when the Windows system folder is located on a drive other than C. |
CR#227154 Case#565743 |
Object Search |
A sort error no longer occurs when searching for an object. |
CR#221712
Case#534143 |
Feature |
Resolved Issue |
Change Request |
Connections
|
Toad no longer displays an error when you attempt to browse the list of servers in the Create New Connection window. |
CR#207091 Case#490520 |
When connected to a database, Toad now disconnects the current connection before starting, stopping, or pausing the database service for that connection. |
CR#215675 | |
Data Grid
|
You can now view the full contents of a cell by clicking the arrow beside the cell. Previously, cell contents were truncated after 200 characters. |
CR#193198 Case#464540 |
After grouping a column in the data grid, pressing CTRL+C to copy a row no longer results in an error. |
CR#194958 Case#468517 | |
Database Browser/ Object Palette |
Attempting to connect to a database with a name longer than 32 characters no longer results in an error. |
CR#178372 |
|
Attempting to view the error log in SQL Agent Properties on SQL Server 2005 no longer results in an error. |
CR#167581 |
|
An error no longer occurs when you alter a job, select the Alerts page, then select an alert and click Delete. |
CR#217177 |
|
You can now take a database offline if you previously attempted to alter the database and canceled the alteration in the current session. |
CR#217297 |
You can now copy or move a database using the Copy/Move Wizard without having to install the .NET Framework 1.1. |
CR#216408 | |
Users |
An error no longer occurs when creating a user with extended properties. |
CR#217159 |
Diff Viewer |
When sending a table to the Diff Viewer from the Database Browser/Object Palette, you can now select whether to send the table or the data for that table. |
N/A |
Editor |
Verify SQL now executes the statement against database selected in the Editor toolbar. |
CR#218351 |
Export Data
|
Toad no longer prompts for bind variable values when exporting string literals that contain a backslash followed by a question mark. |
CR#219004 Case#484142 |
Toad now inserts the correct rtf value for NTEXT data types when you generate INSERT statements from the right-click menu. |
CR#204159 Case#484142 | |
The One-Click Export feature now supports the following options:
|
CR#214846 | |
Schema Compare |
Objects with differences in body text formatting (whitespace or gap line) display as different even though the objects are the same. |
CR#214606 Case#519931 |
Schema Report |
You can now use links to navigate a Schema Report saved as an HTML file outside of Toad by selecting the checkbox for the sqlserver:// (URL scheme protocol sqlserver extension in Tools | Options | Environment | Extensions. |
CR#211323 Case#511955 |
Feature |
Resolved Issue |
Change Request |
General |
Customized keyboard shortcuts are now assigned correctly (Tools | Options | Environment | Keyboard). |
CR#188620 |
Code Snippets |
When creating a new snippets folder, an error no longer occurs if you do not rename the folder. |
CR#164885 |
Connections |
When creating a new connection, the Display Name field is now editable by default. |
CR#192389 |
You can now specify the amount of time to wait before a connection attempt times-out under Tools | Options | Database | Timeouts. |
CR#206962 | |
If the status bar is hidden, attempting to connect to a database using Toad no longer results in an error. |
CR#189787 | |
Data Grid |
An error no longer displays if you press CTRL+C or CTRL+A after grouping a column in the grid. |
CR#194958 |
Currently, the Sum and Average mathematical functions cannot be applied to a column. |
CR#217319 | |
Database Browser/ Object Palette |
You can now generate a creation script for most objects from the right-click menu (Send To | Editor as Script) or the Script tab in the Database Browser. |
CR#155222 CR#155224 |
You can send the SQL script generated when creating, altering, or dropping an object in an object editor to the SQL Editor for execution. |
CR#162373 | |
You can now generate a SQL script for altering views, stored procedures, and UDFs by right-clicking an object and selecting Generate SQL | To location | Alter Script. |
CR#201033 | |
For most objects, you can only open one object editor at a time. |
CR#186004 | |
|
When adding a column with a uniqueidentifier as the data type, and setting IS RowGUID to TRUE, newid() is no longer quoted in the generated script. |
CR#192388 |
When adding a column, you can now specify precision, scale, and length values in the parenthesis for the Type column in the Table Column List. |
CR#194767 | |
Occasionally, the focus in the Table Column List changes to the previous row; and you may change properties for the previous row rather than the current one. |
CR#194772 | |
Tables that have the same name as a keyword, such as CASE or GROUP no longer display an error when browsing data from the Data tab. |
CR#195851 | |
You can now unbind a column from a rule when the table owner is not "dbo." |
CR#142201 | |
Indexes with Included Columns are now supported |
CR#200635 | |
Setting a data filter for multiple tables, and then selecting the data tab on those tables repeatedly no longer results in an error. |
CR#192550 | |
Programmability -UDDTs |
CLR user-defined data types are now supported. |
CR#171053s |
Databases |
(Database Browser Only) The correct database size now displays in the Properties tab. |
CR#179229 |
Activity |
You can now view a complete list of processes; and can sort, filter, or group those processes under the Activity category. You can also view the Last T-SQL Command Batch and any locks from this category. |
CR#180355 |
Debugger |
In SQL Server 2000, if the code contains a blank line or comment before the CREATE PROCEDURE block, the Debugger now indicates breakpoints correctly. |
CR#216036 |
Editor |
Loading a script in some environments no longer results in an argument was out of range error. |
CR#188451 CR#194961 |
Using the shortcut key (CTRL+SHIFT+MINUS) to uncomment a comment line no longer results in an error. |
CR#192545 | |
If you copy data to the clipboard and then paste it into the editor, a blank line is added after each line. |
CR#193046 | |
Formatting 100+ lines of code that have been copied and pasted into the Editor no longer causes Toad to hang. |
CR#194963 | |
You can now use the same parameter name more than once for multiple tables in a query. |
CR#163853 | |
You can now query tables that contain decimal data types with a precision or 29 or greater. |
CR#195496 | |
Dragging-and-dropping objects from the Database Browser/Object Palette into an editor window now places the objects in the order they were selected. |
CR#211702 | |
ER Diagrammer |
You can now save ER diagrams without causing an error. |
CR#195495 |
Export Data |
When exporting data that contains more rows than set to fetch initially (default
is 1000 rows), you are now prompted to read all rows before exporting.
|
CR#189392 |
Filtered data is now exported correctly. |
CR#193542 | |
When exporting data as INSERT statements, the name you specify in the Object field under Script Options now persists. |
CR#192874 | |
Import Data |
When importing data, Toad now verifies that the end of a field is followed by a delimiter, a carriage return or linefeed, or an end of file. |
CR#197128 |
When importing data, the wizard now defaults to the current database. |
CR#210436 | |
Log Reader |
You can now read more than one log file at a time. |
CR#206238 |
When reading the online transaction log, clicking Refresh no longer results in an error. |
CR#189933 | |
If a database was backed up with the Overwrite option set to Append to media, the Log Reader can now read any appended changes. |
CR#192659 | |
When filtering entries using the Show only selected option, clicking Clear now clears all selected entries. |
CR#203097 | |
Master Detail Browser |
You can now specify an alias for a table or view by double-clicking the name of the table/view in the Diagram panel at the top of the window. |
CR#203102 |
Options |
An unauthorized access error no longer displays when using the Search feature on Options pages (Tools | Options). |
CR#211202 |
Query Builder |
The drop-down menu in the Form tab of the Where Condition window now includes "IS NULL" and "IS NOT NULL". |
CR#185054 |
Schema Compare |
Users with different names that share the same login are now synchronized
correctly. |
CR#103387 |
Schema Reports |
When generating a report, an error no longer occurs if Include Properties is selected in the Default Settings panel.
|
CR#186238 |
SQL Tuning |
For a list of resolved issues and enhancements, see the SQL Tuning Release Notes.
|
N/A |
The following is a list of issues known to exist at the time of Toad for SQL Server release.
Feature |
Known Issue |
Change Request |
General |
Customized options selected in the Configuration wizard are not applied if you are running Toad as a Restricted user. Workaround: |
CR#216699 |
Connections |
If you are connecting to a local database, using "(local), <port #>" in the Server name field results in an error. Workaround: "localhost" "localhost, <port #>" "., <port #>" |
CR#218603 |
Data Compare |
Quest recommends limiting compares to 100,000 records for each table. You can limit the records for large source or target tables using the Source Custom Filter and Target Custom Filter fields at the bottom of the Select Columns window in the Data Compare wizard. |
CR#158211 |
You can compare views, but you cannot synchronize them. |
CR#166497 | |
Data Grid |
||
When adding data to a column that has an Identity Increment value, Toad cannot determine the increment value on the client side and an error occurs if you do not enter a value for the column. Workaround: |
CR#117786 | |
Data Reports |
Currently, you cannot create a Label Report in the Toad Data Report wizard. |
CR#215945 |
Database Browser/
|
The following issues have been identified. |
N/A |
Tables |
||
If you add a column with a data type that uses MAX as the reserved word, the script displays correctly in the SQL Script page of the Create/Alter Table window, but MAX is replaced by either a "0" or "-1" in the generated script (available on the Script tab of the Database Browser, or when right-clicking to generate a Creation script). |
CR#227920 | |
If you are connected to a SQL Server 2000 database and a 2005 database, enabling/disabling a foreign key on one database; and then switching to the other database and attempting to enable/disable a foreign key on it results in the following error: "[SQL-DMO]The name was not found in the Tables collection. If the name is a qualified name, use [] to separate various parts of the name, and try again." |
CR#228532 | |
Databases |
When generating a DDL script for databases, the following objects are not included in the script:
|
CR#216490 |
After backing up a database, you must press F5 to update the icon/status. |
CR#213716 | |
Schedules |
(VMWare only) Selecting the Script tab for schedules results in Toad hanging. |
CR#227477 |
Stored Procedures |
(SQL Server 2005 only) Attempting to view the Script tab for a system stored procedure in a database other than the master database results in the following error: "[SQL-DMO]The name was not found in the StoredProcedures collection. If the name is a qualified name, use [] to separate various parts of the name, and try again." Workaround: |
CR#225049 |
Debugger |
You cannot debug stored procedures with the following input parameters in this release:
|
CR#133602 CR#133634 CR#133636 |
Debugging and then executing a user-defined function that contains a scalar function when invoked from the Editor generates an incorrect SQL statement.
Workaround: |
CR#227747 | |
In some environments, the result set returned by a stored procedure called by another stored procedure is inserted into a table; however the table definition has varchar columns that are not long enough. This results in an error message stating, "String or binary data would be truncated" and data is not inserted into the temporary table. Workaround: |
CR#211704 | |
Editor |
The following object types are not found when using the View Object at Cursor (F4) feature:
|
CR#164917 |
Export Wizard/ One Click Export |
Binary data types cannot be exported in this release. |
CR#170430 |
When exporting large results sets (approximately 500K), you may run out of memory before the operation completes. Workaround: |
CR#203483 | |
Exporting more than 65,536 rows to an Excel 2007 instance causes an error. Note: This issue does not affect Excel 2000 or 2003. |
CR#211832 | |
Import Wizard
|
Currently, you
cannot import Excel 2007 files because they are saved using an xlsx format. Workaround: |
CR#221667 |
Log Reader |
Sometimes when installing Log Reader Server Components to a remote host, a "Write to file failed" error occurs. Workaround:
|
CR#216499 |
Schema Compare |
Default constraints, check constraints, foreign keys, and case differences display in schema compares even though you select options to ignore them on the Compare Options page (Tools | Options | Schema Compare | SQL Server | Compare). |
CR#215192 CR#212297 CR#212301 |
Schema Report |
On SQL Server 2005 only, generating a Schema Report when the Include System Objects and Include Source options are selected results in an error. |
CR#223188 |
Server Compare |
When running MSDE 2000, attempting to retrieve information from DTS Packages may result in a "General Repository Error: 80041035." |
CR#142205 |
If the target server is configured with Use Windows NT Fibers, you cannot synchronize Meta Data Service Packages. |
CR#142206 | |
If the Meta Data Service DTS Packages contain a COM object that is not registered on the target server, you may receive an exception error during synchronization. |
CR#142207 | |
Currently, you cannot rollback Meta Data Service DTS Packages. |
CR#122712 | |
SQL Tuning |
For a list of known issues, see the SQL Tuning release notes. |
N/A |
Version Control |
The Update Database function for version control often requires that objects be dropped and recreated. If tables are referenced by Foreign Key constraints, the following error occurs when executing the script: "Could not drop object N because it is referenced by a FOREIGN KEY constraint." |
CR#214601 |
(CVS only) Currently, the following versions of CVS have been tested with Toad. Server: CVS 1.11.22 CVSNT 2.5.03 Client: CVSNT 2.5.03 |
N/A | |
(CVS only) Each version control configuration should point to a unique Root Folder location on the Source Repository to avoid conflicting file usage. |
CR#228422 | |
(CVS only) When configuring version control for CVS, you must include "user@" in the Provider Information Server field or an "Unknown error" message displays. Information in the Server field should use the following format: |
CR#226256 | |
(CVS only) When configuring version control, you must specify only the path in the BinaryPath field of the Command Based Version Control Properties window. Including the executable in this field will result in the following error: "The system cannot find the path specified." |
N/A | |
(Visual SourceSafe only) If Toad is not installed on the domain where SourceSafe resides, attempting to log into SourceSafe results in the following error message: "File does not exist. Please verify that this computer has access to the server share location." Workaround:
|
CR#227455 | |
(Visual SourceSafe only) If you add an object, alter the object, remove the object from Toad, and then re-add the same object from Toad, an incorrect script for the object may display in the History panel of Toad even though the correct script was checked in. Workaround:
|
CR#228348 |
The following is a list of third party issues known to exist at the time of Toad for SQL Server release.
Feature |
Known Issue |
Change Request |
Data Compare
|
Currently, the synchronization script for each table displays
using the SyntaxEditor component. This component has a storage limit of 5 MB,
and should be disabled for large scripts. |
CR#142210 |
Export Wizard |
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 2007 PIAs
|
CR#138239 |
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.2
| Documentation.
Before installing Toad for SQL Server, 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
|
Hard Disk Space | 130 MB of disk space for installation.
|
Operating System |
Windowsฎ 2000 Windows 2003 Windows XP Professional (32-bit or x64) Windows Vista (32-bit or x64) Note: SQL Tuning is not supported on Windows Vista (any edition). |
Additional Software | .NET Framework Notes: Consider the following:
(Optional) Spotlight on SQL Server Spotlight on SQL Server 4.5 or later
|
Before installing Toad for SQL Server, ensure your server meets the following minimum hardware and software requirements:
Operating System |
Windows 2000 Server with SP4 or later Windows 2000 Professional Edition with SP4 or later Windows XP (32-bit with SP2 or later; x64) Windows 2003 Server (32-bit or x64 with SP1 or later) Windows Vista (32-bit or x64) |
Supported Databases |
Microsoft SQL Server 2000 with SP3, 2005 with SP2
|
The following user privileges are required for installing and running Toad for SQL Server:
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.
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
Citrix Installation.
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
ท
Microsoft SQL-DMO
For
information about installing Toad silently, see Install Toad Silently in
the Toad for
SQL Server Getting Started Guide.
Verify the following general requirements to ensure that the Debugger operates properly for all SQL Server installations:
Note: Currently, you cannot debug
SQL/CLR code.
To debug locally, perform the following on the client machine:
To debug remotely, perform the following:
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
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
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.
SQL Server 2005 Platforms Tested for Debugging Support |
|||||||
Client |
Server |
||||||
2003 EE |
2003 EE (SP1) |
2000 |
2000 Pro (SP4) |
XP Pro |
XP Pro (SP2) |
Vista Pro | |
2003 EE |
|
|
| | |
|
|
2003 EE (SP1) |
|
Yes |
Yes |
Yes |
|
Yes |
|
2000 |
|
Yes |
Yes |
Yes |
|
Yes |
|
2000 Pro |
|
Yes |
Yes |
Yes |
|
Yes |
|
XP Pro |
|
|
|
|
|
|
|
XP Pro (SP2) |
|
Yes |
Yes |
Yes |
|
Yes |
|
Vista Pro | | | | | | | Yes |
SQL Server 2000 (SP4) Platforms Tested for Debugging Support |
|||||||
Client |
Server |
||||||
2003 EE |
2003 EE (SP1) |
2000 |
2000 Pro (SP4) |
XP Pro |
XP Pro (SP2) |
Vista Pro | |
2003 EE |
Yes |
|
| | |
|
|
2003 EE (SP1) |
|
Yes |
|
|
|
|
|
2000 |
|
|
Yes |
|
|
|
|
2000 Pro |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
XP Pro |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
XP Pro (SP2) |
Yes |
Yes |
Yes |
|
|
Yes |
|
Vista Pro | | | | | | | |
SQL Server 2000 (SP3) Platforms Tested for Debugging Support |
|||||||
Client |
Server |
||||||
2003 EE |
2003 EE (SP1) |
2000 |
2000 Pro (SP4) |
XP Pro |
XP Pro (SP2) |
Vista Pro | |
2003 EE |
Yes |
|
| | |
|
|
2003 EE (SP1) |
|
Yes |
|
|
|
|
|
2000 |
|
|
Yes |
|
|
|
|
2000 Pro |
Yes |
Yes |
Yes |
Yes |
|
|
|
XP Pro |
Yes |
Yes |
Yes |
Yes |
Yes |
|
|
XP Pro (SP2) |
|
|
|
|
|
Yes |
|
Vista Pro | | | | | | | |
SQL Server 2000 (SP3a) Platforms Tested for Debugging Support |
|||||||
Client |
Server |
||||||
2003 EE |
2003 EE (SP1) |
2000 |
2000 Pro (SP4) |
XP Pro |
XP Pro (SP2) |
Vista Pro | |
2003 EE |
|
|
| | |
|
|
2003 EE (SP1) |
|
Yes |
|
|
|
|
|
2000 |
|
|
Yes |
|
|
|
|
2000 Pro |
Yes |
Yes |
Yes |
Yes |
|
|
|
XP Pro |
|
|
|
|
|
|
|
XP Pro (SP2) |
|
|
|
|
|
|
|
Vista Pro | | | | | | | |
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 Editions that contain Knowledge Xpert.
The Knowledge Xpert feature is available with English language content
only.
The Toad for SQL Server release package contains the following products:
For general 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.2 | Documentation.
To install Toad on a Citrix system
Connect to the Citrix Environment as an administrator.
Copy Toad to the Citrix server, if required.
Install Toad.
During installation, select the Anyone who uses this computer checkbox when prompted.
Repeat steps 2 through 4 for each server in the Citrix farm.
Note: Although you must install Toad on every server in the Citrix farm, you only need to publish Toad once.
Review the following considerations regarding licensing. A license supplied by an administrator always overrides a user-supplied license in a Citrix environment.
If you need to provide the same Toad functionality to all your users, you can enter the default license key for all users.
If you have users with different license requirements, individual licenses should be entered for each user. You should not enter the default license key because it enables all functionality in Toad.
info@quest.com | |
Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA | |
Web |
Refer to our web site for regional and international office information.
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:
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.
ฉ 2008 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:
Quest Software World Headquarters LEGAL Dept 5 Polaris Way Aliso Viejo, CA 92656 Email: legal@quest.com |
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.