Toad for SQL Server 7.2 - Release Notes

New Features System Requirements Resolved Issues and Enhancements Known Issues Third Party Known Issues Getting Started Toad for SQL Server Editions Product Licensing Globalization About Us Copyright

Known Issues

The following is a list of issues known to exist at the time of this release.

Feature	Known Issue	Defect ID
Startup/Installation	If intending to hibernate the machine with the open connections to the servers that might be unavailable at the next startup, it is recommended to disconnect first due to risk of data loss.	N/A
Startup/Installation	When installing Toad using Quest Installer on Windows 7 64-bit, Program Compatibility Assistant may appear with “This program might not have installed correctly” message. Workaround: Select This program installed correctly to continue installation. For more information, see http://windows.microsoft.com/en-PH/windows7/Program-Compatibility-Assistant-frequently-asked-questions	N/A
Code Completion	Code Completion provides limited syntax support of SELECT * INTO clause.	ST87112
Connection Manager	Cannot establish Named Pipes connection if "Poll service status in connection list" option is selected. Workaround: Clear "Poll service status in connection list" checkbox on the Tools \| Options \| Database \| General page.	ST86603
Connection Manager	You need to install Microsoft Active Directory Authentication Library (adalsql.msi) to connect to Azure SQL Database using Active Directory Password Authentication.	QAT-14556
Data	For some queries, attempting to right-click a row and select Row Count results in a message stating that the row count could not be determined.	N/A
Performance Monitor	You may encounter an exception in the Performance Monitor during recording: in the Object explorer expand and collapse a tables list.	930
Performance Monitor	You may encounter an exception when using the Performance Monitor and Session Browser at the same time.	948
Schema Compare	When the Ignore column order option is not selected two tables are incorrectly reported to be equal.	245
	The script comparing two databases where one database is empty has execution errors.	271
	The script synchronizing two databases that have the same table with different index is incorrect.	834
Debugger	You may encounter some issues when debugging remotely.	ST82044
Editor	Toad may hang after applying Short Format Uppercase Keywords or Short formats to large scripts.	ST83268
Execution Plan	You cannot generate an estimated execution plan for queries containing local temporary tables because the execution plan uses a different connection to generate the plan and does not know about the temp table. Workaround: Use the actual execution plan button to generate execution plans for SQL that contains a temp table.	N/A
Export Wizard/ One Click Export	Limitations when exporting fractional seconds: When exporting to an Access Database File, exports do not support fractional seconds, so the additional data is not exported. When exporting to an Excel instance, exports support only 3-digits for fractional seconds. However, if you export to an Excel file, it supports all fractional seconds.	N/A
Export Wizard/ One Click Export	Avoid using Excel for exporting if your data has numeric values that require a high precision because Excel's precision is limited to 15 digits. If you export numbers with more precision, the values are rounded. If you export boundary numbers (max, min), rounded numbers will exceed the data type limit.	N/A
Job Manager	SQL Azure connections currently display in the Job Manager even though the Job Manager is not available for SQL Azure.	ST75721
Log Reader	User information only displays for operations in the sessions that are currently open. Backups do not contain this information because only the SPID information is available to them.	ST37112
Log Reader	SQL Azure connections currently display in the Read Log wizard even though the Log Reader is not available for SQL Azure.	ST75720
Object Explorer/ Database Explorer	Table and Index Partitioning: Currently, you cannot create or manage a partition on a table or index that includes a FileStream column. Currently, estimating index compression savings runs a full table compression savings query, so the estimation may be slow on large tables.	ST59194 ST68131
Object Explorer/ Database Explorer	FDCC: User cannot start/stop SQL Agent running Toad with Regular or Admin User account on the client side in some limited environments. Workaround: Start the SQL Agent on the server side.	ST91618

Third Party Known Issues

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

Feature	Known Issue	Defect ID
Excel	If an Excel file is open in Toad, you cannot open the same file in a separate Excel instance. To review this and other limitations when using Excel in the Web Browser, see "Considerations When Using the WebBrowser Control" at: http://support.microsoft.com/kb/304662.	42486
Export Wizard/ One Click Export	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: http://www.microsoft.com/en-us/download/details.aspx?id=20923 2007 PIAs: http://www.microsoft.com/en-us/download/details.aspx?id=18346	N/A
Import Wizard	Importing large data sets from Excel (approximately 650,000 rows) is not recommended because of the amount of time it may take. This issue occurs because the Excel import component maintains the output in memory until the import completes. This can cause performance issues depending on the available system resources.	219754
Screen Resolution	Some users may experience an exception when the screen is set to certain resolutions. Workaround: Adjust screen resolution.	N/A