Toad for SQL Server - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in v6.8.1?
How to find the license number
Contact Us
Technical Support
View All Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1262
'punctuation' is an unexpected token. Expecting white space. Line ... (238476)

Comparing the entire database, without filters between source database on SQL Server 2016 and target database on SQL Server 2012. Ignoring whitespaces, statistics, permissions, and extended properties, one gets ...

Product(s): Toad for SQL Server
Last Updated On: 1/16/2018
(0 Ratings) 6 views
Error when executing a specific query (235321)

An error can occur when executing a particular query in Toad for SQL Server: System.Xml.XmlException: Unerwartetes Token 'false'. Erwartet wird ein Leerzeichen. Zeile 6, Position 62. System.Xml.XmlException: Unexpected token 'false'. Expecting a white space. ...

Product(s): Toad for SQL Server
Last Updated On: 1/15/2018
(0 Ratings) 2 views
How to reset menu and toolbar settings back to default. (238073)

Some things have change in the toolbar and menu bar. Is there a way to reset these back to default? 1) Right click in the toolbar or menu and select Customize. 2) In the Options tab, click the Reset All Customizations button.

Product(s): Toad for SQL Server
Last Updated On: 1/11/2018
(0 Ratings) 5 views
Toad installation error: The installer was not able to complete successfully. (189788)

Unable to install product suite. When trying to install Toad, getting the error below. The issue happens on the .EXE file, but can also happen on the .MSI file. ERROR: "The installer was not able to complete successfully. RegisterComplete returned error code [0x80070005]. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 1/9/2018
(1 Ratings) 9529 views
TSS 6.8. Export DDL does not include the Clustered Key indexes. (237474)

Export DDL does not pick up clustered indexes. The Script produced by the Export DDL function does not include the clustered key. However, the 'Script' tab in the object window for a table does have the correct syntax. WORKAROUND ...

Product(s): Toad for SQL Server
Last Updated On: 1/8/2018
(0 Ratings) 9 views
Starting Data Generator causes an error: 'Object reference not set to an instance of an object' (237233)

In Toad v6.8.1, the following error appears when trying to use the Data Generator feature on a table: 'Object reference not set to an instance of an object'. Following this error, it's not possible to use the functionality. WORKAROUND: None. ...

Product(s): Toad for SQL Server
Last Updated On: 1/5/2018
(0 Ratings) 7 views
"Advance | Optimize the current statement" is not available. (236813)

Having a license for Toad for SQL Server that includes SQL Optimizer, one can't see available the option "Advance | Optimize the current statement", and the documentation says: "If you purchased a version that includes the SQL Optimizer". Why is it not available? ...

Product(s): Toad for SQL Server
Last Updated On: 1/3/2018
(0 Ratings) 22 views
Get "Server user is not a valid user in database " hovering over database (123199)

Getting a message saying "Server user is not a valid user in database " when hovering over the databases in the Object Explorer. Also, all the database icons have x's on them in the Object Explorer. Also, the Object Search is ...

Product(s): Toad for SQL Server
Last Updated On: 12/29/2017
(1 Ratings) 2768 views
Do Toad for SQL Server or Toad for Oracle follow the Microsoft Evergreen approach for this software (aka. Windows as a Service)? (232825)

Do Toad for SQL Server or Toad for Oracle follow the Microsoft Evergreen approach for this software (aka. Windows as a Service)? No, no specific development has been done for this.

Product(s): Toad for SQL Server, Toad for Oracle
Last Updated On: 12/27/2017
(0 Ratings) 157 views
Internally generated query causes an idle blocking situation in Toad. (225044)

The Toad background query below is sometimes an idle blocker, blocking a query from SSMS Intellisense: SELECT tr.name AS [Name],. tr.object_id AS [ID]. FROM sys.triggers AS tr. WHERE (tr.parent_class = 0). ORDER BY [Name] ASC. ...

Product(s): Toad for SQL Server
Last Updated On: 12/22/2017
(0 Ratings) 6 views
"The specified account already exists" error installing. (137591)

When trying to install Toad, the following error or similar is encountered: "Error 1316 the specified account already exists". The error message may or may not also specify a portion of the installation, ie "While attempting to install BackupReporter_2.0.1.50_x86_EN.msi". ...

Product(s): Toad Data Point, Toad for SQL Server, Toad for Oracle
Last Updated On: 12/19/2017
(0 Ratings) 4508 views
Enhancement - Would like the Schema Compare results sent to Excel with the same format as the Data Grid Results (235597)

When sending the Schema Compare results to an Excel file (Schema Compare Report), would like to see the format the same as what is seen in the Data Grid Results WORKAROUND. none. STATUS. Enhancement Request ...

Product(s): Toad for SQL Server
Last Updated On: 12/19/2017
(0 Ratings) 3 views
Is it possible to change the icon that is shown for Toad when it is open and in the taskbar (235425)

There are multiple Toads installed on the same PC. Is it possible to change the product icon in order to distinguish between each Toad in the taskbar, when the products are open? Go to All Programs | Quest Software | right click Toad | Properties | Change icon. ...

Product(s): Toad for SQL Server
Last Updated On: 12/15/2017
(0 Ratings) 11 views
Can't login to Toad. What is the Toad password? (80949)

Cannot or unable to login. What is the Toad password? The account is locked so it needs to be unlocked and the password reset. There is a prompt that the password has expired, and to reset, the old password is needed, but what is the old password? ...

Product(s): Toad Edge, Toad for SAP Solutions, Toad Data Point, Toad Data Modeler...
Last Updated On: 12/15/2017
(2 Ratings) 13712 views
Object Explorer does not retain the changes to column layout between sessions (235155)

With the Object Explorer in tabbed mode, it's not possible to change the size of columns and have the change be permanent. For example, the Programmability tab is too narrow to see the names of stored procedures. It's possible ...

Product(s): Toad for SQL Server
Last Updated On: 12/7/2017
(0 Ratings) 6 views
Installation, Unable to install product, "HTTPs Error: This package download process are interrupted, error code [0x80072EFE] or [0x80072EFF] or [0x80070642] or [0x80070EFD] (229235)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the Https error. The issue happens on the web installer then your internet connection is unreachable. ERROR: "HTTPs Error: This package download processes are interrupted. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 12/7/2017
(0 Ratings) 1757 views
Get message saying SQL Optimizer is not installed when launching from Toad for SQL Server (235101)

When launching SQL Optimizer for SQL Server from Toad for SQL Server, a message is returned saying that SQL Optimizer is not installed and SQL Optimizer does not launch. WORKAROUND #1: Launch SQL Optimizer as a standalone product from the installation folder. ...

Product(s): Toad for SQL Server
Last Updated On: 12/6/2017
(0 Ratings) 9 views
How to uninstall the add-in Toad from SQL Server Management Studio? (109598)

How to uninstall the Toad add-in from MS Studio ? RESOLUTION 1: Here are steps to uninstall SSMS add-in: 1. Run CMD with administrator privileges. 2. Navigate to Toad install directory, "SSMS Installation" subfolder for instance ...

Product(s): Toad for SQL Server
Last Updated On: 11/14/2017
(0 Ratings) 4991 views
What is Spotlight Essentials System Health Check? (133142)

When launching Toad for SQL Server 6.5 for the first time, it displays a window asking Would you like to check if your SQL Server Instances are Healthy? What does this feature do, and who is the functionality designed for? What is Spotlight Essentials? ...

Product(s): Toad for SQL Server
Last Updated On: 11/13/2017
(0 Ratings) 5055 views
Video - How to install Spotlight Essentials for Toad for SQL Server (133512)

The following article contains a tutorial video that describes how to set up Spotlight Essentials for Toad for SQL Server. Overview -. How to Setup a Spotlight Essentials account. Install the Diagnostic Server for Toad for SQL Server. Verify that the Service is installed and running. ...

Product(s): Toad for SQL Server
Last Updated On: 11/13/2017
(0 Ratings) 4740 views
Error "The request failed with HTTP status 404: Not Found" or "Team Foundation services are not available from server" when setting up version control with Team Foundation Server (87250)

When connecting to Team Foundation Server via the Version Control Wizard, the following error occurs on entering the server details: "The request failed with HTTP status 404: Not Found.". and/or. “The request failed with HTTP status 400: Bad Request.”. or. ...

Product(s): Toad for SQL Server
Last Updated On: 11/6/2017
(0 Ratings) 5386 views
Error, "TypeLoadException. Could not load type" when launching SSMS after installing Toad SQL Server (115209)

Been using SQL Server Management Studio (SSMS) without errors. After successfully installing Toad for SQL Server, whenever launching SSMS the following error occurs: Toad for SQL Server:Type Load exception TypeLoadException. Could not load type. ...

Product(s): Toad for SQL Server
Last Updated On: 10/4/2017
(1 Ratings) 4717 views
Error: "The Add-in... failed to load" when launching SQL Server Management Studio (SSMS) (118695)

After installing Toad, the following error displays every time SSMS is launched Error message still displays even after selecting 'Yes' to uninstall the Add-in. "The Add-in 'Quest Toad Add-in for SQL Server Management Studio 2008' failed to load or caused an exception. ...

Product(s): Toad for SQL Server
Last Updated On: 10/4/2017
(1 Ratings) 6169 views
Keyboard Shortcuts to comment and to uncomment not working in Toad for SQL Server (139889)

In Toad for SQL Server Keyboard Shortcuts: Ctrl-K, Ctrl-C, to comment and Ctrl-K Ctrl-U to uncomment is not working. WORKAROUND. 1. Select Edit | Advanced | Comment (Ctrl-K, Ctrl-C) to comment out code works. 2. Select ...

Product(s): Toad for SQL Server
Last Updated On: 9/8/2017
(1 Ratings) 2999 views
'Failed to save application settings' when saving options (117209)

When making changes to the options in Toad Data Point or Toad for SQL Server and pressing OK, the following message appears: 'Failed to save application settings.'. Editing options doesn't save to the settings.xml file This ...

Product(s): Toad Data Point, Toad for SQL Server
Last Updated On: 8/24/2017
(0 Ratings) 2666 views