Nate.Gaffaney
Follow / 3 Aug 2018 at 2:52pm / Toad for SQL Server

Toad World Changes Coming Soon

Expand content
Hi Everyone, 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...

Hi Everyone, 

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.

Regards, 

Nate Gaffaney, Quest Software

0 0 / Replies are disabled.
Chad Ossiginac
Follow / 30 Sep 2016 at 3:16pm / Toad for SQL Server

How to get the most out of this forum – a post describing best practices...

Expand content
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...

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.

2972 0 / Replies are disabled.
Nate.Gaffaney
Follow / 9 Aug 2018 at 10:17am / Toad for SQL Server
Latest post by on 10 Aug 2018 at 12:13pm

Toad for SQL Server Freeware Updated (6.8.2)

Expand content
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...

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.

0 9 / Replies are disabled.
BAH--zer
Follow / 31 Jul 2017 at 7:32am / Toad for SQL Server
Latest post by on 10 Aug 2018 at 5:36am

Execution Plan and Syntax Check

Expand content
Все доброго времени суток. За время работы в вашей программе столкнулся со следующими проблемами - 1. Проценты не корректно отображаются в плане выполнения запроса. В отличии от SSMS, в планах выполнения...

Все доброго времени суток.

За время работы в вашей программе столкнулся со следующими проблемами -

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?

1.

2.

VERSION - Toad for SQL Server 6.6.0.963

Unanswered 3332 6 / Replies are disabled.
mkrieg
Follow / 8 Aug 2018 at 6:05pm / Toad for SQL Server
Latest post by on 9 Aug 2018 at 8:45pm

How do I obtain a license key for the freeware version of Toad for...

Expand content
Hello all, 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...

Hello all,

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.

Thanks

Unanswered 0 5 / Replies are disabled.
russ b
Follow / 7 Sep 2017 at 5:38pm / Toad for SQL Server
Latest post by on 9 Aug 2018 at 5:22pm

Are we going to get a Freeware for 6.8?

Expand content
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...

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.

3715 10 / Replies are disabled.
mitchell.sacks_234
Follow / 9 Aug 2018 at 4:14pm / Toad for SQL Server

Version 6.9 coming out any time soon?

Expand content
Hi, Does anyone know if version 6.9 is coming out anytime soon?

Hi,

Does anyone know if version 6.9 is coming out anytime soon?  

0 0 / Replies are disabled.
g3force
Follow / 8 Aug 2018 at 2:25am / Toad for SQL Server
Latest post by on 9 Aug 2018 at 12:22pm

Toad for SQL Server 6.8.0 Freeware version suddenly asking for a license...

Expand content
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...

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?

Thanks

Unanswered 0 16 / Replies are disabled.
Varwulf
Follow / 8 Aug 2018 at 7:43pm / Toad for SQL Server
Latest post by on 8 Aug 2018 at 9:38pm

Toad for SQL Server Freeware Version Expired

Expand content
Greetings, 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"...

Greetings,

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.

0 2 / Replies are disabled.
Alison Clowes
Follow / 8 Aug 2018 at 10:43am / Toad for SQL Server
Latest post by on 8 Aug 2018 at 3:27pm

Freeware version

Expand content
HI I have been using the freeware version without problem (6.8.0.97) 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 thanks...

HI

I have been using the freeware version without problem (6.8.0.97) 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

thanks

Alison

0 2 / Replies are disabled.
Pietro_74
Follow / 8 Aug 2018 at 11:00am / Toad for SQL Server
Latest post by on 8 Aug 2018 at 3:27pm

Toad 6.8 FREEWARE ask for a license key ---please help

Expand content
Hello, 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...

Hello,

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?

0 2 / Replies are disabled.
Maurusaurus
Follow / 27 Sep 2017 at 7:59pm / Toad for SQL Server
Latest post by on 8 Aug 2018 at 3:27pm

Toad Sql Server Trial Edition Instaler

Expand content
Hello 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...

Hello

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?

Thanks

1357 2 / Replies are disabled.
xty
Follow / 8 Aug 2018 at 10:43am / Toad for SQL Server
Latest post by on 8 Aug 2018 at 3:26pm

TOAD for SQL Server 6.8 Community Freeware is asking for license ...

Expand content
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...

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.

Unanswered 0 1 / Replies are disabled.
williehao
Follow / 8 Aug 2018 at 9:11am / Toad for SQL Server
Latest post by on 8 Aug 2018 at 3:26pm

Why freeware version need to enter a license key and site message...

Expand content
Why freeware version need to enter a license key and site message?? ??? how to do ?? thanks

Why freeware version need to enter a license key and site message??   ???

how to do ?? thanks 

0 1 / Replies are disabled.
clintm
Follow / 16 Jul 2018 at 9:58pm / Toad for SQL Server
Latest post by on 19 Jul 2018 at 2:41am

Show only Primary Databases (azure)

Expand content
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...

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.

Unanswered 39 3 / Replies are disabled.
hokiefan1us
Follow / 9 Mar 2018 at 9:31pm / Toad for SQL Server
Latest post by on 17 Jul 2018 at 8:02am

Can't view query builder?

Expand content
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...

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.

Unanswered 1084 1 / Replies are disabled.
costabas
Follow / 20 Apr 2018 at 6:11pm / Toad for SQL Server
Latest post by on 17 Jul 2018 at 7:51am

SQL Recall list - shared between installations or add an import feature...

Expand content
I submitted this idea . Please vote if you think it would be useful for you. Thanks

I submitted this idea. Please vote if you think it would be useful for you.

Thanks

1379 2 / Replies are disabled.
jigarsnaik
Follow / 18 May 2018 at 10:57am / Toad for SQL Server
Latest post by on 16 Jul 2018 at 6:46am

Toad standalone instillation or Install for current user and to specific...

Expand content
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?

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?

Unanswered 607 1 / Replies are disabled.
costabas
Follow / 12 Jul 2018 at 7:23pm / Toad for SQL Server
Latest post by on 16 Jul 2018 at 2:40am

Import from excel is limited to 65536 rows

Expand content
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...

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?

Thank you!

105 1 / Replies are disabled.
ImBigData
Follow / 11 Jul 2018 at 5:57pm / Toad for SQL Server
Latest post by on 12 Jul 2018 at 8:51am

Editor Font Color

Expand content
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.

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.

Unanswered 126 1 / Replies are disabled.