Look for changes to Toad World coming soon, including new Forum and Blog web pages.
We appreciate your patience during the migration process.
We have locked Forums from new posts and replies while we complete the migration. If you have an urgent problem, please send an e-mail to email@example.com
You will no longer receive e-mail notifications from this forum.
Contact Support on Twitter
We've been working on a redesigned Toad World web site, and are getting ready to launch it soon.
Capabilities such as Forums and Blogs will be on new web pages with a more modern appearance and capabilities.
Existing Forum posts will be migrated, and many Blog posts and Videos will be migrated. Older out-of-date Blog and Wiki posts will not be migrated.
During the migration process, posting to Forums will be temporarily turned off. We currently expect this to happen starting August 10.
See John Pocknell's Blog post for more details on the migration.
Nate Gaffaney, Quest Software
The better a problem is described, the better the assistance tends to be.
In order to better assist with your issue at hand, please include the following information in your initial post:
- Product, Version, and relevant environment details.
- Include a screenshot of the problem
- Describe the problem fully. What result was expected?
- Can the issue be created on demand or is it intermittent?
- If the problem can be generated faithfully, what are the exact steps to recreate the problem?
- Any other pertinent information
How to create Support Bundles
The support bundle window provides information about several aspects of your SQL Server and Toad setups.
To create a support bundle, select Help | Support Bundle, in Toad’s menu bar. This will generate a report that you can include in your post. It may also generate an e-mail that contains the same report, along with your settings files and log files.
*Note: Please refrain from including private data in your posts. Be as thorough as you can with the provided info. We will reply to you as quick as possible. We are glad to assist you.
Latest Release Information:
This announcement includes information on our latest releases, links to our downloads and documentation and overview of new features. This way you can stay as informed as possible:
"What’s New" Section:https://documents.software.dell.com/toad-for-sql-server/6.7/release-notes/release-notes/new-features
Link to Download & Documentation:https://support.software.dell.com/toad-for-sql-server/6.7
Link to Trial:https://software.dell.com/products/toad-for-sql-server/software-downloads.aspx
Link to the release notes:http://documents.software.dell.com/toad-for-oracle/12.9/release-notes/
Top 5 Knowledge Base Articles:
Here you can find what knowledge articles are trending.
These are this month’s Top Knowledge Base Articles:
1. What's New in Toad for SQL Server 6.7? (198975)https://support.software.dell.com/toad-for-sql-server/kb/198975
2.The license key and site message do not work with version 6.7 (205008)https://support.software.dell.com/toad-for-sql-server/kb/205008
3. Debug Error "The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database ' (66187)https://support.software.dell.com/toad-for-sql-server/kb/66187
4. Is it possible to increase the connection timeout setting in Toad (28042)https://support.software.dell.com/toad-for-sql-server/kb/28042
5. How to read SQL Server transaction logs in Toad for SQL Server? (85266)https://support.software.dell.com/toad-for-sql-server/kb/85266
Feel free to browse them. Remember to sign in to get the entire information available for our Register users.
Toad for SQL Server Freeware 6.8.2 is available for download in both 64-bit and 32-bit from the Toad World Downloads page.
Specific link: https://www.toadworld.com/download/toad-for-sql-server/freeware
This should resolve the prior issue with 6.8 Freeware asking for a license key.
Все доброго времени суток.
За время работы в вашей программе столкнулся со следующими проблемами -
1. Проценты не корректно отображаются в плане выполнения запроса. В отличии от SSMS, в планах выполнения часто указываются нулевые проценты стоимости запроса. Есть ли возможность исправить данную ошибку?
2. Нет возможности настроить систему для того что бы она корректно воспринимала пользовательские агрегатные функции. Пример - функция list. Она была добавлена в базу данных из внешней dll и используется для соединения строк. Однако если перед параметром функции list поставить ключевое слово DISTINCT, TOAD for SQL SERVER распознает его как не корректный синтаксис и выдаст множество синтаксических ошибок. Однако код является валидным и успешно выполняется. Есть ли возможность исправить данную ошибку?
Hello.During the work in your program faced the following problems -1. The interest is not correctly displayed in the query execution plan. Unlike SSMS, execution plans are of zero interest cost of the query. Is there a way to fix this error?2. There is no possibility to configure the system for that would it correctly take a user-defined aggregate functions. Example - function list. It was added to the database from an external dll and is used to join strings. However, if before the function parameter list to put the DISTINCT keyword, TOAD for SQL SERVER will recognize it as invalid syntax and will give you many syntax errors. However, the code is valid and runs successfully. Is there a way to fix this error?
VERSION - Toad for SQL Server 184.108.40.2063
I installed the freeware version of Toad for SQL Server not too long ago. It worked well for a bit until it recently started prompting me for a license key whenever I started the application. Now I can't use the application because I can't get past the license prompt. Does the freeware version of Toad for SQL Server require a license key? If so, how do I get one for my copy? If not, why am I encountering this prompt? Uninstalling and reinstalling the software does not fix the issue.
I don't really need the full version of Toad for SQL Server, but the current Freeware is only on 6.6 and is terribly buggy. When are you going to update the Freeware to 6.8?
BTW, I'd pay for a "lite" version of SQL Server if it had everything the Freeware had the "Edit: snippets, predictive typing, syntax highlighting" of the full version. I just don't need everything the pro version has and can't justify $700 for that. But $150 or so for a lite version I could justify.
Does anyone know if version 6.9 is coming out anytime soon?
Up until today all was fine. I uninstalled it, downloaded both the 64 and 32 bit versions and installed one with the same problem. Uninstalled again then installed the other with the same problem.
Has there been a change where a license key is now required? If Yes how do I get one?
I noticed today that my freeware version of Toad is giving me an expiration message when I try to open the application, or reinstall it. "Please enter a license key and site message".
Some research led me to a 2011 post about the freeware version needing to be updated on quest's end to fix the error, as it seems the expiration/license is stored on quest's end to determine if a version is legit or not, which makes sense.
Since I didn't notice any new topics related to the issue, I thought I'd post my concerns to see if it's actively being looked at or if the problem might be more localized than I am led to believe.
Either way, thanks for taking a look and giving this a read.
I have been using the freeware version without problem (220.127.116.11) and today it is now asking me for a license key, before I can start running queries, how to do I get it running again
today Toad (versione 6.8 64bit) ask me for a license key. This is very strange, I've been using it from long time.
I also tried to uninstall, download the 64bit msi installer and then reinstall: again the same problem. Any ideas?
Toad Sql Server Trial Edition Instaler is asking me a "Licence Key". But I never received a mail with Licence key (I already checked spam folder and nothing)
I there anyway to send againg the key, please?
I just downloaded and installed TOAD for SQL Server 6.8 Community Freeware edition. But it asks for license key & site messaage. What should I enter? There's no license key file/email whatsoever, and I can't go through at all.
Why freeware version need to enter a license key and site message?? ???
how to do ?? thanks
We have 2 SQL Servers in Azure, sqlServer1 and sqlServer2.
We have more than 50 databases running on them. sqlServer1 isn't always where the Primary database is, sometimes it is sqlServer2 that is primary.
When something breaks I need to fix it fast. In our customer's table, we track which SQL Server they have as their primary database. I have to query that each time to figure out the Primary one or my changes will fail due to it being secondary (read only).
When I open Toad, I have to choose Server1 or Server2 from the Connection Manager. I have to flip back and forth between these connections.
Is there a way to open a Toad Connection and only see the Primary databases?
I am rather new to all of this, please ask me any questions in case I didn't come across well.
Thank you for the help on this.
I downloaded Toad for SQL Server 6.7 from our corporate license and can't see query builder. 10 other folks in the organization have downloaded the same thing and can see it just fine. Is there possibly another application on my computer that is conflicting and preventing it from showing or an option within my application that might be unchecked in order to see it.
I submitted this idea. Please vote if you think it would be useful for you.
HI Is there any standalone toad available which i can just copy and run. without any installation?
Or is there anyway i can install toad only for current user and to specific directory?
I want to import the data from an excel file which has approximately 85k rows. Toad imports only up to 65536 rows. Can you please fix this and increase the limit to 1 million or whatever the maximum allowed is in Excel?
How do I change the font color in the Editor? Not the background color. The font color. I like a dark editor with light colors.