SQL Server 2005 Debugging Support

Client

Server

2003 EE

2003 EE (SP1)

2000
(SP4)

2000 Pro (SP4)

XP Pro

XP Pro (SP2)

2003 EE

—

—

—

—

—

—

2003 EE (SP1)

—

X

X

X

—

X

2000
(SP4)

—

X

X

X

—

X

2000 Pro
(SP4)

—

X

X

X

—

X

XP Pro

—

—

—

—

—

—

XP Pro (SP2)

—

X

X

X

—

X

SQL Server 2000 (SP4) Debugging Support

Client O/S

Server O/S

2003 EE

2003 EE (SP1)

2000
(SP4)

2000 Pro (SP4)

XP Pro

XP Pro (SP2)

2003 EE

X

—

—

—

—

—

2003 EE (SP1)

—

X

—

—

—

—

2000
(SP4)

—

—

X

—

—

—

2000 Pro
(SP4)

X

X

X

X

X

X

XP Pro

X

X

X

X

X

X

XP Pro (SP2)

X

X

X

—

—

X
(local server only)

SQL Server 2000 (SP3) Debugging Support

Client

Server

2003 EE

2003 EE (SP1)

2000
(SP4)

2000 Pro (SP4)

XP Pro

XP Pro (SP2)

2003 EE

X

—

—

—

—

—

2003 EE (SP1)

—

X

—

—

—

—

2000
(SP4)

—

—

X

—

—

—

2000 Pro
(SP4)

X

X

X

X

—

—

XP Pro

X

X

X

X

X

—

XP Pro (SP2)

—

—

—

—

—

X
(local server only)

SQL Server 2000 (SP3a) Debugging Support

Client

Server

2003 EE

2003 EE (SP1)

2000
(SP4)

2000 Pro (SP4)

XP Pro

XP Pro (SP2)

2003 EE

—

—

—

—

—

—

2003 EE (SP1)

—

X

—

—

—

—

2000
(SP4)

—

—

X

—

—

—

2000 Pro
(SP4)

X

X

X

X

—

—

XP Pro

—

—

—

—

—

—

XP Pro (SP2)

—

—

—

—

—

—

Component

Enhancement/Resolved Issue

Case ID/ Change Request

DB Browser/ Obj Palette

Switching from Processes to Locks under Activity no longer results in an error.

CR0188862

Editor

Resolved an issue with the parser that resulted in an ArgumentOutOfRange error.

CR0189662

Supported bind variable formats are now ignored when quoted.

CR0188832

Log Reader

The Log Reader now includes fully qualified object names so it can be used on SQL Server 2005.

CR0189937

The Owner/Schema name is now included in the following:

• Statistics tab

• DML/DDL tab

• Full Log tab

• Undo/Redo wizard

• Generated scripts

CR0167708

Varchar and nvarchar values now display in the Log Reader.

CID449114

Money and Smallmoney datatypes now display the correct values.

CR0192107

Data is no longer truncated in the log file for SQL Server 2000.

CR0189939

On SQL Server 2005, BINARY values can now be reconstructed for UPDATE operations.

CR0191901

The DML/DDL tab now:

• Automatically refreshes table names after INSERT operations.

• Displays the correct script for DELETE operations.

CR0191906
CR0191757

Options

The search feature in the Options window now returns results for all pages.

CR0191531

SQL Modeler

Saved model files from the 1.0 release can now be opened in the 2.0 release.

CID455708

Component

Enhancement/Resolved Issue

Case ID/ Change Request

DB Browser/
Obj Palette

Resolved a performance issue when displaying data in the Data tab.

CR0180112

Resolved a performance issue that occurred when the msdb.dbo.backupset table contained 1000+ rows. You can further improve performance after applying this patch by clearing the Enable database backup checking under Tools | Options | Database | SQL Server.

CID449965

Editor

Resolved a memory leak in the Script Results data grid which affected performance.

CR0186975

Export Wizard

The Export wizard now supports exporting INSERT statements with decimal data when the decimal separator is a comma.

CID449125

Options

An error no longer occurs after selecting the Disable all caching checkbox in Tools | Options | Database | SQL.

CR0188268

SQL Tuning

For a list of resolved issues in this release, refer to:

http://www.toadsoft.com/toadsqlserver/SQL_Tuning_for_SQL_Server_
Release_Notes.htm

Component

Enhancement/Resolved Issue

Case ID/ Change Request

Export Wizard/
Import Wizard

The correct file encoding format is now applied when exporting or importing files.

CID436008

Import Wizard

An error no longer occurs when importing a file where the regional setting for short date on the client does not match the DATEFORMAT setting on the database server.

CR0184058

Component

Enhancement/Resolved Issue

Case ID/ Change Request

General

A threading error no longer locks Toad if left idle for an extended period of time.

CID396214

DB Browser/ Obj Palette

In Tree view, attempting to select Filegroups, Files, or Scripts from the "Current" node no longer results in an exception error.

CR0137393

When altering a column in a table, you can now modify whether the column accepts null values.

CID384449
CID419995

When generating DDL for a database, unique constraints are now included in the DDL script.

CID386637

When generating a data script for a database, Long text fields are now supported.

CID390627

When creating a job step, selecting a database other than the default and then creating a SELECT statement on an existing table in that database no longer results in an error.

CR0139781

Data Compare

The synchronization script for each table no longer has a storage limit of 5 MB.

CR0142210

Data Grid

You can now edit data for tables that do not contain a primary key by clicking the red, read-only indicator (bottom left of the data pane) to open a custom key editor. You can modify settings options or accept the defaults to allow editing of data in the grid.

CID398999
CID409604
CID411025
CID411254
CID435513

Debugger

Debugging some stored procedures no longer results in an sp_procedure_param_rowset error.

CID431294
CID427808

The debugger now highlights the correct row to debug and displays breakpoints in the correct location.

CID428887

Editor

COMPUTE BY statements are not supported in this release, due to a limitation with the ADO.NET provider.

CR0105196

Tables or columns that include the word go, such as a table name "goals," are no longer treated as keywords and parsed.

CID378475

Code is now formatted properly when the WITH(NOLOCK) option is included in the statement.

CID386983

Formatting a script and then attempting to view the explain plan no longer results in an error message displaying or the explain plan hanging.

CR0134422

Export Wizard

You can now set an identity_insert on and specify an explicit column list on the generated script.

CID408101

Object Search

After searching a database, right-clicking a trigger in the result set and selecting Generate DDL no longer results in an error.

CID407062

Options

The "Fetch data in background" option (Tools | Options | Browser | General) is now available in Toad for SQL Server.

CR0120679

Schema Compare

Dependencies in generated synchronization scripts are now ordered correctly.

CID388327

SQL Modeler

The correct syntax now displays in a generated query when using a cross join.

CR0132231

Joining three tables no longer creates a cross join.

CID401665

The SQL modeler now supports case sensitivity.

CID398727

Table aliases now persist when using WHERE and OR conditions.

CID393995

SQL Tuning

For a list of resolved issues in this release, refer to: http://www.toadsoft.com/toadsqlserver/SQL_Tuning_for_SQL_Server_
Release_Notes.htm

Component

Known Issue

Case ID/
Change Request

Code Snippets

When creating a new snippets folder, an exception error occurs if you do not rename the folder.

CR0164885

Connection

Attempting to launch Toad results in a System.Security.Policy.PolicyException error. To resolve this issue, ensure that the system administrator has placed Toad in the correct code group with permissions set to execute code.

CID408845

If the status bar is hidden, attempting to connect to a database using Toad results in a "Parameter is not valid" error. As a workaround, right-click the toolbar area in the main Toad window and enable the Statusbar.

CR0189787

Data Compare

Currently, you can compare indexed views, but you cannot synchronize them.

CR0166497

Quest recommends limiting compares to 20000 rows in tables. When using Data Compare on large databases, Quest recommends excluding tables with large data sets from the comparison.

CR0142208

During synchronization, you should disable script options for triggers, dropping primary and foreign keys, etc. until the sync is complete under Tools | Options | Data Compare | Script.

CR0142211

Database Browser/ Obj Palette

After creating a database role and login and denying permission for creating a table on that login as well as giving the login the db_denydatabasereader role, attempting to create a table results in an error.

 CR0179445

When generating a data script for a database, CLR objects are not supported.

CR0169708

The Deps (Uses) & Deps (Used by) tabs display as empty if an extended stored procedure is used.  

CR0117189

Currently, you cannot unbind a column from a rule if the table owner is not "dbo."

CR0142201

When adding columns to a table, Toad does not increment the Identity Increment value properly.  

CR0117786

Attempting to view the error log in SQL Agent Properties on SQL Server 2005 results in an error.

CR0167581

Debugger

After entering start parameters for a remote debugging session on SQL Server 2005, a "CoUnmarshalInterface failed with error code 0x80040155" may display. To resolve this issue:

1. Copy the ssdebugps.dll (SQL Server Debugging Host component) from the computer where SQL Server 2005 is installed to the same directory on the client computer. By default this directory is: C:\Program Files\Common Files\Microsoft Shared\SQL Debugging.

2. Open a command prompt on the client computer and register the ssdebugps.dll by typing:
   regsrv32 ssdebugps.dll

CR0166022

Quoted object names are not supported when using the Debugger.

CR0125691

Editor

Toad cannot execute an SQL script in the Editor if syntax highlighting is disabled (Tools | Options | Editor | Highlighting Styles).

CR0167980

The following object types are not found when using the View Object at Cursor feature:

• Triggers

• Procedures

• Functions

• Users

• Hosts

CR0164917

ClickingClear All Filters in the Editor toolbar does not take effect. As a workaround, click Define Filters and clear the filter manually, or open the Database Browser/Object Palette, and click Clear All Filters.

CR0189718

Currently, the same parameter name cannot be used more than once for multiple tables in a query.

CR0163853

Export Wizard

Currently, the Export wizard does not support binary data types.

CID419715

Help

The following new features and enhancements have limited documentation in this release. This documentation will be expanded in a future release.

• Charts

• Pivot Grids

• Database Browser object lists, details, and object editors

• SQL Modeler subquery updates

Log Reader

In some environments, attempting to refresh the Log Reader may result in one of the following errors:

• An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

• A transport-level error has occured when receiving results from the server. (provider: TCP provider, error: 0 - The specified network name is no longer available.)

CID450811

If a database was backed up with the Overwrite option set to Append to media, the Log Reader is unable to read any appended changes. As a workaround, back up the database with the Overwrite option set to Overwrite existing media.

CR0192659

Object Search

Currently, you cannot search Unicode databases.

CR0166781

Schema Compare

Extended properties for a trigger do not display in the Results pane.

CR0137005

Users with different names that share the same login are not synchronized correctly.

CR0103387

Server Compare

When running MSDE 2000, attempting to retrieve information from DTS Packages may result in a "General Repository Error: 80041035."

CR0142205

If the target server is configured with Use Windows NT Fibers, you will not be able to synchronize Meta Data Service Packages.

CR0142206

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.

CR0142207

Currently, you cannot rollback Meta Data Service DTS Packages.

CR0122712

Version Control

Some error messages are currently available with English language content only.

CR0140084

Component

Resolved Issue

Case ID/
Change Request

Export Wizard

In order to export to an Office 2003 Excel instance, the Office 2003 Primary Interop Assemblies (PIAs) must be installed. You can install the PIAs from:  http://www.microsoft.com/downloads/details.aspx?FamilyID=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&DisplayLang=en

CR0138239

Help

After installing Microsoft Security Update 896358, selecting a topic in the help file when using the Web Browser (Internal Help) results in the topic displaying in the navigation pane. Quest recommends using External Help (Tools | Options | Environment | Interface) as a workaround. If you want to use Internal Help, you will need to disable some features in the security update. Refer to Microsoft Knowledge Base article: http://support.microsoft.com/kb/896905/ for steps to re-enable these features in ActiveX.

CR0129554

After installing Microsoft Security Update KB922616, attempting to view the Help file from the Web Browser (Internal Help) results in the following error: "COM object that has been separated from its underlying RCW cannot be used." Quest recommends using External Help (Tools | Options | Environment | Interface) as a workaround. If you want to use Internal Help, you will need to disable some features in the security update. Refer to Microsoft Security Bulletin MS06-046: http://www.microsoft.com/technet/security/Bulletin/MS06-046.mspx

Version Control

Quest recommends using the native VSS implementation in Toad rather than VSS via SCC integration. When using VSS via SCC, if the file does not have the attributes that SCC expects, there may be issues with the file being updated properly.

CR0138078