New in this Beta Drop

ArgumentOutOfRangeException is shown when typing space in the INSERT statement.

63896

Exception is thrown when adding a database name to the script.

63624

Code completion takes too long to shows stored proc, CPU usage goes to 100% and memory usage also goes up.

63336

System.ArgumentOutOfRangeException when click spacebar in sub-query.

63964

Sometimes doesn’t list correct columns for tables after typing "=" in a query.

62700

Toad crashes when executing some code in editor while showing "Retrieving" text in database dropdown on the toolbar.

63394

Stop execution doesn't work.

62916

Setting max objects in Properties in ER Diagram does not work properly.

58479

Unicode: Import error when exporting datetime from French in XML format and importing to English.

63126

Unicode: Import error when exporting money, float or real data from French and importing them to English.

63125

Unicode: Date is wrong when exporting datetimeoffset from French and importing to English Verified Fixed.

63127

Unicode: Question marks are shown in sql_variant columns with Unicode characters.

62755

System objects are listed under Select Target page for Import Wizard.

50807

Agent Jobs/Job List: Exception appear on Show History for Multi-Server jobs on MSX server.

59706

Toad hangs while executing 'read a list of job' task.

62039

Partitioned Table: After making changes to the partitioned table, partitions tab doesn’t refresh automatically.

59415

Users: Exception occurs when adding extended properties to user.

61599

Users: System.ArgumentOutOfRangeException occurs if add extended properties on Alter User dialog.

58498

Server Triggers: Event list in DOE combined incorrect: DDL_SERVER_LEVEL_EVENTS includes only create, alter and drop database events.

63459

Tables: UDDT column does not support identity.

63554

Full-Text Catalogs: System.ArgumentException occurs when altering full-text catalog with !@#$%^&*() symbols in its name.

63440

Users: SQL Server Database error is shown when creating a user which is mapped to certificate or asymmetric key with DEFAULT_SCHEMA.

62228

Users: 'Default Schema' field is available in Create User dialog when User mapped to certificate or asymmetric key.

57913

Triggers: 'Operand data type varchar is invalid for sum operator.' error when select any database after disable trigger on table.

60147

Index: Exception is shown when creating/altering/dropping clustered index for the table.

63973

Include collation script option does not work for CLR table-valued function.

59313

Empty tab or empty node is displayed for object list.

63445

Duplicated tree nodes are shown after refreshing.

62894

Legacy Maintenance Plans: RHS History tab does not refresh until reconnect to server.

63318

Data Grid: Unable to change the scientific numbers.

63239

Standby database does not show up in Object Explorer dropdown.

63234

System.NullReferenceException occurs when refreshing while on Tables node if database has partitioned table.

62377

Table: Binding/unbinding columns to default or rule does not automatically refresh.

58398

'Object reference not set to an instance of an object' when reverse engineering for union, union all, intersect and except statements.

63551

'Index was out of range' when using alias name for special table name in the query.

63791

Scripts stored in source control contain collation that user would like to remove so it will use DB default.

41972

SVN: System.NullReferenceException when adding a table to subversion.

63064

VSS: Toad should prompt user to checkout object first when user try to alter an index under VC.

62392

VSS: "Unable to check out object" error when try to check out default object under VC.

62835

VSS: User should be prompted to check out first while altering a trigger on table.

62820

In Previous Beta Drops

Support of new data types in column pane/Columns RHS tab.

CR57338

Support of new data types in Create/Create Like/Alter dialogs: DATE, TIME, DATETIME2, DATETIMEOFFSET, FILESTREAM, HIERARCHYID, GEOMETRY, GEOGRAPHY.

CR56034

Support of new data types in UDDT: DATE, TIME, DATETIME2, DATETIMEOFFSET, FILESTREAM, HIERARCHYID, GEOMETRY, GEOGRAPHY, UDTT (User-Defined Table Types).

N/A

Support of new data types in datagrids/data editors - DateTime Types (DATE, TIME, DATETIME2, DATETIMEOFFSET), Spatial Types (GEOMETRY, GEOGRAPHY), HIERARCHYID.

N/A

Databases: Create/Create Like/Alter dialogs: support for FILESTREAM file group.

CR56030

Data Compare: Support of new data types: DATE, TIME, DATETIME2, DATETIMEOFFSET, FILESTREAM, HIERARCHYID, GEOMETRY, GEOGRAPHY.

CR56035

Backup/Restore Database: Support for SQL Server 2008 native backup and restore with new Enterprise Edition Compression option for native backups.

CR58043

Tables: Spatial indexes support (Create/Alter).

CR59245

Add RHS support for stored procedures' and functions' read-only parameters.

CR60134

LiteSpeed Engine: Restore Database not working - direct editing of restored file names not allowed.

CR55381

Backup Database - Focus is not on the first item when you open Backup Database dialog.

CR45416

Backup doesn’t work when database name include special characters.

CR59829

Native transaction log backup with "Create tail-log backup" (NO_TRUNCATE) option fails.

CR51090

Can’t restore an encrypted database because there is no option to provide password/key while restoring.

CR60005

LiteSpeed Backup: "new media" and "check media name" do not work.

CR51062

LiteSpeed: Improve the server folder/file browser.

CR59188

LiteSpeed: Optimize for Object Level Recovery (@OLRMAP). This option is unchecked by default.

CR59189

LiteSpeed: Provide the ability to add multiple files and folders.

CR59190

Code completion dropdown is disappearing when entering @ after WHERE statement.

CR55361

Code completion doesn't complete for system functions.

CR46871

Code completion doesn't come up when SET is entered.

CR49355

Improper recognition of table hints.

CR61366

Code Completion adds procedure name twice.

CR61989

Search in Code Snippets should search the descriptive text as well.

CR59178

When displaying for the first time, the root node should be expanded so the user can already see the categories underneath the root node.

CR59179

Importing connections doesn’t import those connections under the group.

CR60772

Cannot connect to the SQL Servers that are on clusters.

CR59002

Copy/Move Database: Support Filestream on 2008 and prevent copy/move database to 2005 if there is filestream on source end.

CR59598

Copy/Move Database: Exception when copying a database from 2000 to 2005.

CR52403

Copy/Move Database Wizard should provide a list of registered instances on Source and Target pages.

CR54637

"Database already exists" problem when copying the same database on the same server.

CR58091

Selection of action in Select Databases step is available for databases that are in Loading, Offline, Recovering, Suspect, or in Emergency Mode and Wizard allows to proceed to the next step.

CR54360

There is no error message if user tries to copy\move database from 2008 SQL Server to 2005 SQL Server.

CR61859

Exception is shown when closing all documents after data compare is opened.

CR63228

Add compare facilities to the right-click menu on an object in the LHS when two objects are selected within the Object Palette/Database Browser.

CR59199

Add a button to hide the columns that don’t contain different values.

CR57657

Memory usage remains high even though data compare has been finished and closed.

CR47028

Support recovery from lost connection.

CR60417

Should not lock the application when generating the script.

CR55143

Generate Data Script throws System.OutOfMemoryException on large DB.

CR60398

The selections have been cleared if some options are changed.

CR55116

Object section disappears from the dialog after Generate DDL Script dialog was minimized and then maximized.

CR60090

Job id instead of job name is displayed on Generate DDL Script dialog.

CR62200

System.ArgumentException occurs when turn selecting General tab after SQL Script tab.

CR62068

Incorrect job name displays in name field on Generate DDL Script dialog.

CR60978

Remove ODBC from debugger (SQL Server 2000) test for PolyServe support and to get ODBC out of the product.

CR59182

System.ArgumentException and toad freezes when debugging stored procedure with image as input.

CR60421

Debugger throws exception because Toad can't process varbinary data type.

CR41675

Debugging support for SQL Server 2008.

CR57790

Remove info message when moving from code to script mode.

CR51895

Error while debugging stored procedure with bit and timestamp input parameters.

CR41539

Error when debugging stored procedure with BINARY&VARBINARY input parameters.

CR41538

Debugging stored procedure with timestamp parameter throws an error.

CR59344

Support ER Diagram and Query Builder.

CR56044

Include comment chunking statement types for SQL Server.

CR61483

Add connection information (namely the instance name) to the editor window tabs.

CR58052

Add an Editor context-menu for Formatting and Optimizing with SQL Tuning.

CR58047

Add an Editor context-menu for "Analyze query in Database Engine Tuning Advisor".

CR58048

New 2008 data types (hierarchyid, geography, geometry) are not highlighted.

CR59746

Support Estimated/Actual Execution Plans.

CR60355

Explain Plan: Not working for sp_help.

CR50377

Explain Plan: Database Errors.

CR42562

Import: Smalldatetime doesn’t show correctly when importing from Excel file.

CR62841

Export: Money data doesn't format correctly when exporting to Excel file.

CR62844

Import - Error is shown when importing Excel file with decimal or numeric data type.

CR62842

Export data error is shown when exporting uniqueidentifier data type to Access.

CR62346

ODBC error is shown when exporting to Access 2007.

CR62455

Export data error is shown when exporting bigint data type to Access.

CR62342

Error is shown when importing xml file with "date" data type.

CR62766

"Incorrect Syntax" is shown when importing time and datetimeoffset datatypes.

CR60077

Importing XML file with Korean data shows “????” after import.

CR55248

Question marks are shown for imported data of nvarchar, nchar and ntext datatypes.

CR60054

Export fails because too much memory is being used.

CR41935

Export wizard: Change default encoding and sort order for File encoding drop-down list.

CR60189

Support of new 2008 data types.

CR60350

If result sets match then results should be returned in a single grid with instance name as the first column.

CR60414

Can't group by any columns in Job List view of Job Manager.

CR49041

Toad does not display Job Steps or Job History in Job List view.

CR59186

Integrate into the database context menu.

CR59201

Create Table: Identity flag doesn't clear after changing column type from int to varbinary(MAX).

CR62801

CLR Stored Procedure: System.NullReferenceException occurs when opening Context menu if several CLR stored procedures are selected.

CR61302

Create Table: Exception occurs when create table if column default type is type that is absent from current database.

CR55434

Alter Table: Incorrect script when renaming PK in filestream table.

CR63074

Alter Table: Incorrect script when changing PK filegroup in filestream table.

CR63081

Create Table: 'Sort Order' column is absent from Specify Constraint Columns dialog.

CR62369

Alter Table: Script is invalid after adding NOT NULL column with formula to primary key.

CR62634

Alter Table: Filestream for index not scripted when making extended alter table.

CR63207

Spatial Index: There is no Use Index option on Create Index dialog (Options tab) for Spatial Index.

CR60757

UDDT: User-defined table type shouldn’t be listed in the create dialog.

CR60396

Table: Incorrect type is selected for column because of case sensitivity.

CR54200

Spatial Index: There is no Use Index option on Create Index dialog (Options tab) for Spatial Index.

CR60757

UDDT: User-defined table type shouldn’t be listed in the create dialog.

CR60396

Table: "Default value or binding" attribute should be grayed out for identity column.

CR50752

Table: Identity attribute should not be enabled on nullable column.

CR50747

Maintenance Plans: Toad crashes when you try to edit SSIS maintenance plan using Toad that is running on a machine without SSIS components.

CR51468

Maintenance Plans: Exception occurs when pressing OK button while loading Alter Maintenance Plan.

CR55126

Security Migration: There is no script for login when migrating the user (2005).

CR51230

Restore "Shrink Log File" functionality.

CR57078

Partitioned objects support: Partition Schemes DOE.

CR59192

Partitioned objects support: Partition Functions DOE.

CR59191

Full-text Catalogs: Description field is empty on Population Schedule tab when altering Full-text catalog.

CR55427

Indexes: Script generated for enabling an index is incorrect.

CR60526

Index: Script generated for disabling an index is incorrect.

CR60527

Indexes: Extra options are scripted when alter index.

CR60935

Logins: <Enable> option should be added to login options list when altering.

CR53807

Logins: Status page is missing from create login dialog.

CR50599

Logins: Permission information is not displayed in alter login dialog.

CR54427

Roles: Securables page is not displayed in create/alter role dialog.

CR51410

Table Script tab: Incorrect script is displayed on Script tab for table (2000) where filegroup and text filegroup was created on different filegroups.

CR63089

Notes are shown for the table that was re-created.

CR41954

No result set shown when running MERGE statement. Messages tab shows statement executed successfully and (nn) rows affected.

CR61027

SQL Server Logs: Object details window is shown for SQL Server Logs.

CR57361

Server Properties: changes of some options are not scripted.

CR54477

Database/Server Trigger: "Generate SQL" menu is not available from right-click menu and "Editor as Script" is disabled from the "Send To" menu.

CR59005

CLR Server Triggers: Event_type/event_group is absent from RHS Script tab.

CR59786

Data Grid: Uncheck "Format XML" erases the XML data.

CR57998

Clicking on any folder in Object Explorer (such as CLR, System objects) should by default display a list of objects for that folder on the RHS.

CR57994

Incorrect script is generated for logins with mapped users.

CR58707

NullReferenceException occurs when activity node is focused and Object Explorer is resized.

CR56861

Alter Objects in Editor - Implement for stored procedures, functions and triggers.

N/A

Databases: Files RHS tab should contain information about file's used space.

CR58129

Functions: Parameters RHS tab should support table-valued functions.

CR58243

Jobs: Incorrect script is generated for job stopping.

CR56056

Linked Servers: Script tab is missing.

CR55886

Maintenance Plans: Show error log.

CR56043

Tables: No computed formula information is displayed on Columns tab.

CR57765

Tables, Views: Indexes tab in the RHS should show what columns are in an index.

CR57341

Scripting: 'Send To -> Editor as Script' action should be implemented for users, roles, schemas, logins.

CR56339

There is no way to disable\enable alert and operator from context menu and tab toolbar.

CR56009

Improvements to deadlock handling.

CR57089

LHS is not showing objects in standby database.

CR57926

Move System Data Types under Programmability node.

CR59478

Object Explorer RHS: Need to get rid of empty Send To pop-up menu groups.

CR60343

Script does not refresh automatically after script options change.

CR58457

"Object reference not set to an instance of an object" when clicking Script tab for in-line table-valued function.

CR59679

Support for UDTTs as parameters for running functions and procs.

CR58994

Browser should expose some of our comparison facilities when exactly two objects are chosen within the Browser.

CR59576

MERGE option added to Generate SQL for a table for 2008 (UPSERT).

CR60352

Add ability to start/stop SQL Server Agent from the Agent tab in Object Explorer.

CR45821

Need to include server roles in the Object Explorer.

CR50009

Right-clicking a several objects and selecting Send To|Editor as Script does nothing.

CR50651 (Reported by plarb@yahoo.com)

Execution context is not displayed in Properties tab for server triggers.

CR61286

Scripting should be added for CLR objects: stored procedures, functions, types, etc.

CR56036

Script tab is missing from RHS on XML Schema Collection object.

CR55579

There is only Table Triggers checkbox in Search Source Code of Object Type section.

CR57754

Table: Script for partitioned table that contains BLOB columns is wrong (TEXTIMAGE_ON is scripted that is not applicable for partitioned objects).

CR51807

Table: Extended Alter for partitioned table that contains BLOB columns fails (TEXTIMAGE_ON is scripted that is not applicable for partitioned objects).

CR51809

Table: Extended Alter for partitioned table that has constraints like PRIMARY KEY, UNIQUE fails (partition scheme is NOT scripted for constraints).

CR51812

Invoke Partitioning Wizard from context menu on table: should depend on table partitioning status.

CR58044

Invoke Partitioning Wizard from partitioning tab on RHS of Object Explorer.

CR58045

Make Partitioning Wizard more Toad stylish.

CR58046

Support partitioned objects (indexes, tables) on RHS Script tab.

CR59193

Generate data script is slow on a table with 2,600 rows.

CR55474

Scripting: Improve script generation (for some objects checking/unchecking scripting options is too slow).

CR59181

Memory Leak: Issue with Toad and high number of handles/threads.

CR57707

The Report Properties Editor should be a resizable dialog.

CR60418

Incorrect script for login with GRANT CONTROL ON LOGIN.

CR63283

Explicit permissions grids are not shown when adding a securable.

CR62779

Login: Securables page doesn’t show up in Create Login dialog.

CR50595

Click Edit Permissions for logins throws database error.

CR61147

"Object reference not set to an instance of an object" when setting permissions to CLR function.

CR58970

SQL Server database error occurs when granting permissions for Assembly, Asymetric Key, Certificate and Symmetric Key.

CR61871

Hide the menu option by default for new installations.

CR59198

CVS: When files are checked out by another user, it is not showing that this is the case when user sets up version control.

CR52038

CVS: When files are checked out by another user, it is not showing that this is the case.

CR52036

CVS: Unable to cancel CVS validation process.

CR52045

CVS: Confusing message saying things are out of sync when they are not when adding an index or a trigger.

CR51956

Subversion: It takes too long to update LHS after an object is removed from Version Control.

CR52035

Subversion: Configuration Enable/Disable buttons don't behave properly.

CR52141

Subversion: Performance issue on Subversion.

CR50279

Subversion: Some objects failed to add to version control because they are CLR objects.

CR52089

Subversion: Icon status of script doesn’t change after checking out.

CR52241

TFS: Support of TFS 2008.

CR55362

TFS: Attempting to add an object raises an exception.

CR51033

TFS: System.NullReferenceException when checking in an object.

CR51965

TFS: System.NullReferenceException when clicking properties button in Version Control wizard.

CR50133

TFS: Checking out an object from TFS is extremely slow.

CR50850 (Reported by Darren Myher)

VSS: Toad crashes when adding objects to SourceSafe.

CR50276

Options/Version control/General page shows version control enabled when it is not.

CR51933