Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

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
Whats new in v6.8
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 1275
How to run a silent installer as administrator (226994)

How to run a silent installer as administrator. Running as administrator can help if getting the following error message running install: 1. - Toad_xXxX has stopped working, when installing, the installer stops and does not install. 2. - The LOG says: ...

Product(s): Toad Data Point, Toad for SQL Server, Toad for Oracle
Last Updated On: 11/17/2017
(0 Ratings) 1619 views
Deleted items on menu bar cannot be recovered without resetting to defaults (234599)

On doing an ALT + menu item (eg View) and dragging/dropping out of the menu bar, the item is removed from the menu bar and cannot be put back in. Right clicking the menu bar and using 'Customize' does not allow for the adding back of the menu item. WORKAROUND. ...

Product(s): Toad for SQL Server
Last Updated On: 11/16/2017
(0 Ratings) 9 views
Selecting Include Actual Execution Plan appears to only generate an Estimated Plan (234574)

With the Include Actual Plan button highlighted, executing SQL via either F9 or Execute the Current SQL, seems to only generate an estimated plan. Under the Execution Plan, the only tab shown is "Estimated Plan" and the plan is Assign with Query. ...

Product(s): Toad for SQL Server
Last Updated On: 11/15/2017
(0 Ratings) 4 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) 4934 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) 4957 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) 4663 views
Data Generator script fails with the error 'Conversion failed when converting date and/or time from character string', when using non US regional settings (234343)

When using v6.8 on Windows 7, the Data Generator fails with the error 'Conversion failed when converting date and/or time from character string' if the Windows Regional Settings are set to anything other than 'English (United States)' and the table contains a datetime2 and a ...

Product(s): Toad for SQL Server
Last Updated On: 11/7/2017
(0 Ratings) 7 views
Is there a 64-bit version of SQL Optimizer for SQL Server? (234253)

Looking for a 64 bit version of SQL optimizer, only 32 bit appears available for download. Is there a 64-bit version of SQL Optimizer for SQL Server? Currently, there is not a 64-bit version of SQL Optimizer for SQL Server. Note ...

Product(s): SQL Optimizer for SQL Server, Toad for SQL Server
Last Updated On: 11/7/2017
(0 Ratings) 28 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) 5348 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: 11/1/2017
(1 Ratings) 8207 views
Getting "Exception: System.NullReferenceException" when loading tables in Object Explorer (232861)

Getting error "System.NullReferenceException" when going to Object Explorer and trying to load the list of tables. This only happens when connected to SQL Server 2005 and 2008. In the grid pane there is the following message ...

Product(s): Toad for SQL Server
Last Updated On: 10/31/2017
(0 Ratings) 101 views
Database schema compare is not sensitive to fulltext indexes (234033)

A Schema Compare is showing full-text index difference as equal in the summary section. WORKAROUND: None. SOLUTION: Waiting for a fix in a future version of Toad for SQL Server.

Product(s): Toad for SQL Server
Last Updated On: 10/30/2017
(0 Ratings) 6 views
In Toad v6.8, when querying any database the first time it takes a long time return the result set. Subsequent queries then run faster. (234115)

In v6.8, when querying any database the first time it takes a long time to return the result set. Subsequent queries then run faster. When afterwards querying a different database on the same server, the first time it again takes ...

Product(s): Toad for SQL Server
Last Updated On: 10/27/2017
(0 Ratings) 9 views
Get "The back or restore was aborted" message when doing a Restore Database (234049)

When trying to do a Restore Database, once it says it is 100% processed, it gives an error that says, "The back or restore was aborted". When looking at the database in the Object Explorer, after this, it shows it is in a restore mode. ...

Product(s): Toad for SQL Server
Last Updated On: 10/25/2017
(0 Ratings) 8 views
Object Explorer's performance is slow (233899)

Time of response when trying to query a table or dropping one is taking more time than expected. Workaround: 1. Try to implement filters in the Object Explorer for tables can help to reduce the time of response. 2. Download the 64 bit version of Toad for SQL Server. ...

Product(s): Toad for SQL Server
Last Updated On: 10/25/2017
(0 Ratings) 20 views
Option "fully qualified object names when dragging objects" does not work (233982)

Steps to reproduce the problem: Go to Object explorer ,drag one table to the editor and select "select statement" Result is , for example, SELECT AddressID, AddressLine1, AddressLine2, City, StateProvinceID, PostalCode, SpatialLocation ...

Product(s): Toad for SQL Server
Last Updated On: 10/24/2017
(0 Ratings) 7 views
Job Manager - Calendar view fails in v6.8 (233893)

When opening Job Manager, choosing a database connection, and then switching to calendar view, the entries are shown correctly. But when you change the displayed date (using any method) the calendar is no longer displayed and a red X shows. ...

Product(s): Toad for SQL Server
Last Updated On: 10/20/2017
(0 Ratings) 7 views
Error: Log Reader does not support reading log of the database with enabled SQL Server Transparent Data Encryption." (233746)

Error: "Log Reader does not support reading log of the database with enabled SQL Server Transparant Data Encryption.". Can it be supported? The Log Reader does not support TDE (Transparent Data Encryption) because ...

Product(s): Toad for SQL Server
Last Updated On: 10/18/2017
(0 Ratings) 9 views
Get 'System.UnauthorizedAccessException: Access to the path 'C:ProgramData\...AddIns\Menus' is denied' when launching (233667)

When launching, the following error is received... System.UnauthorizedAc cessException: Access to the path 'C:ProgramData\Application Data\Microsoft\ MSEnvShared\AddIns\Menus' is denied. at System.IO._Error.WinIOError ...

Product(s): Toad for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 3 views
Get "The Add-in 'Dell Toad Add-in' failed to load or caused an exception." message launching SSMS (233664)

When launching SQL Server Management Studios (SSMS), the following error is returned. "The Add-in 'Dell Toad Add-in' failed to load or caused an exception.". If the user clicks 'No', it takes them into SSMS. If they clicks Yes ...

Product(s): Toad for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 3 views
Error, "Can't find tree item by param's search path" when using the change current comparison button on certain compares (193716)

When performing a schema compare and looking at the results of the compare, using the change current comparison button would result in the following exception error: Quest.Shared.Processing.CallStackSaverException Can't find tree item by param's search path Parameter ...

Product(s): Toad for SQL Server
Last Updated On: 10/12/2017
(0 Ratings) 1096 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) 4553 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) 5963 views
ER to remove / hide extra column placeholder in the Object Explorer, which is always present. (233325)

ER to remove / hide extra column placeholder in the Object Explorer, which is always present. In Object Explorer (dropdown view), there is an extra empty column placeholder which is always present, even if additional columns are added (for row count, etc.). ...

Product(s): Toad for SQL Server
Last Updated On: 10/3/2017
(0 Ratings) 9 views
Can Toad's Log-Reader be used to recover and not to rollback? (233288)

SITUATION: 1. - Database "DB_1" crashed on day 21, it no longer exists. 2. - There's a back-up from day 17. 3. - Created a new database "DB_2" using the back-up from day 17. 4. - For days: 18, 19, 20 and 21, there are ONLY TRANSACTION logs. ...

Product(s): Toad for SQL Server
Last Updated On: 9/29/2017
(0 Ratings) 10 views