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.

2681 0 / Create an account to join the discussion.
brian_mullins_156
Follow / 14 Feb 2018 at 10:29pm / Toad for SQL Server
Latest post by on 11 Jun 2018 at 1:12pm

No more highlight other instances of selected text in editor

Expand content
I just upgraded to 6.8.2.9 yesterday and almost immediately notice that when I select a variable name (or any text) other instances of that text in the current editor window do not highlight like they...

I just upgraded to 6.8.2.9 yesterday and almost immediately notice that when I select a variable name (or any text) other instances of that text in the current editor window do not highlight like they did in 6.7. Is this an option that must be turned on? If so, where is the setting? I've looked and looked, searched and searched, but found none.

Thanks,
Brian

Unanswered 1819 5 / Create an account to join the discussion.
obygyv
Follow / 23 May 2018 at 8:58am / Toad for SQL Server

How to disable the "Lookup search" tab

Expand content
Hi, How to get rid of the Lookup search tab that appears at every single error. When I execute a statement, and there is an error in it, there is this "Lookup search" tab appearing and switching...

Hi,

How to get rid of the Lookup search tab that appears at every single error. When I execute a statement, and there is an error in it, there is this "Lookup search" tab appearing and switching to it. It's very annoying. I couldn't find any option on that feature.

I'm using Toad for SQL Server 6.8.0.97.

Unanswered 226 0 / Create an account to join the discussion.
bkim_99845
Follow / 22 May 2018 at 4:12pm / Toad for SQL Server

SSIS comparison (and migration)

Expand content
In 6.7 professional edition, I see the "server compare" is capable of comparing DTS packages. The DTS is long gone. Does anyone know if there is a plan to add SSIS comparison?

In 6.7 professional edition, I see the "server compare" is capable of comparing DTS packages. The DTS is long gone. Does anyone know if there is a plan to add SSIS comparison?

234 0 / Create an account to join the discussion.
jigarsnaik
Follow / 18 May 2018 at 10:57am / Toad for SQL Server

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 290 0 / Create an account to join the discussion.
sCmancuso
Follow / 21 Sep 2017 at 2:34pm / Toad for SQL Server
Latest post by on 14 May 2018 at 7:11pm

Toad for SQL Server 6.8 Freeware export to Excel

Expand content
I want to export the results of a query to an Excel file. In 6.6, this was an option in the Export Wizard. However, in 6.8, this is no longer an option: Is this intentional? Or am I doing something...

I want to export the results of a query to an Excel file. In 6.6, this was an option in the Export Wizard. However, in 6.8, this is no longer an option:

Is this intentional? Or am I doing something wrong? I am still able to do a quick export to Excel, but that is much less convenient, and I would really appreciate being able to use the export wizard to create Excel files.

Thanks for your help!

Unanswered 3002 2 / Create an account to join the discussion.
costabas
Follow / 20 Apr 2018 at 6:11pm / Toad for SQL Server
Latest post by on 14 May 2018 at 2:14pm

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

867 1 / Create an account to join the discussion.
bobmoore
Follow / 1 Nov 2017 at 2:00pm / Toad for SQL Server
Latest post by on 8 May 2018 at 2:10pm

Query Builder in Freeware Version

Expand content
According to the comparison chart query builder is supposed to be available in the freeware version, but it says (Not Licensed) when i try to use it. Am I missing something?

According to the comparison chart query builder is supposed to be available in the freeware version, but it says (Not Licensed) when i try to use it.  Am I missing something?

2716 2 / Create an account to join the discussion.
marko.beleuca
Follow / 12 Oct 2017 at 12:58pm / Toad for SQL Server
Latest post by on 20 Apr 2018 at 11:57pm

Import wizard disabled / greyed out.

Expand content
Hi, I've switched from Toad for SQL Server 6.6 to 6.8 64bit freeware version, but now menu option Tools/Import/Import wizard is disabled. Any idea what can be the problem and how to solve it? Thanks...

Hi,

I've switched from Toad for SQL Server 6.6 to 6.8 64bit freeware version, but now menu option Tools/Import/Import wizard is disabled. Any idea what can be the problem and how to solve it?

Thanks!

3221 5 / Create an account to join the discussion.
kaplan.dani
Follow / 20 Apr 2018 at 12:04pm / Toad for SQL Server

Toad pricing

Expand content
I was considering buying the full version, when I saw that the price will gain me access for the full edition only for 12 months. I think it's a bad practice, pushing users to other products. I...

I was considering buying the full version, when I saw that the price will gain me access for the full edition only for 12 months. 

I think it's a bad practice, pushing users to other products. 

I think that giving a lifetime license at even cheaper price ( I think 230$ is really high) , and having users pay only for major upgrade after the first 12 months  is a much more acceptable approach. 

Thus - the customer knows the money he spent will keep it's value, and if he wants new feature after 12 months, he pays a maintenance fee (around 20% of a full price) .

you can offer bundles for maintenance in advance.

Just an idea. 

681 0 / Create an account to join the discussion.
konst
Follow / 22 Mar 2018 at 3:08pm / Toad for SQL Server
Latest post by on 6 Apr 2018 at 9:41am

Toad for sql server 6.8 on windows 10

Expand content
I am trying to install ToadforSQLServer_6.8.0.97_x64_En.exe And error is that it is incompatible with windows (10, x64) Please help.

I am trying to install ToadforSQLServer_6.8.0.97_x64_En.exe

And error is that it is incompatible with windows (10, x64)

Please help.

Answered 1588 2 / Create an account to join the discussion.
Yoni Sade
Follow / 18 Jan 2018 at 12:17pm / Toad for SQL Server
Latest post by on 3 Apr 2018 at 10:50am

Bug: Connection Manager cannot load saved password from connections...

Expand content
In connection manager After I entered server / user/ password and clicked "Save password"->"Save", I can see Toad saved the password encrypted in the connections.xml file, but the...

In connection manager After I entered server / user/ password and clicked "Save password"->"Save", I can see Toad saved the password encrypted in the connections.xml file,  but the connection manager doesn't load it so it always asks me for the password again.

It's a regular SQL Server user and the password works, but I have to reenter it again every time.

Toad for SQL Server 6.8.1.204 (64 bit)

Unanswered 2601 3 / Create an account to join the discussion.
EE
Follow / 12 Jan 2016 at 11:59am / Toad for SQL Server
Latest post by on 16 Mar 2018 at 5:01pm

Automation

Expand content
Hello , I need to execute script and send result by mail from automation tab, i drag execute scirpt and paste the script after that i drag send mail and configure mail server setting but i didn't...

Hello ,

I need to execute script and send result by mail

from automation tab, i drag execute scirpt and paste the script 

after that i drag send mail and configure mail server setting

but i didn't find from where I define that he mail will contain the script outlook?

Also I need to know when i use LINK SQL file ? i didn't understand the benfit from it

Thanks

5527 9 / Create an account to join the discussion.
Prashant Gijare
Follow / 15 Mar 2018 at 7:47pm / Toad for SQL Server

Bug? Create DDL Option - Deselecting FK still produces SQL with F...

Expand content
I've tried many times without luck. I deselect FK in the script creation and it still creates FK at the bottom of the script. I've to manually go and remove that as I don't want FK in the creation...

I've tried many times without luck. I deselect FK in the script creation and it still creates FK at the bottom of the script. I've to manually go and remove that as I don't want FK in the creation script. I create FULL DB script for deployment on test servers so I want script w/o FK to start with. Later I want ONLY FK script that I enable after data load. 

Please help as because of this possible glitch I cannot automate this task.

Regards,

Prashant

798 0 / Create an account to join the discussion.
Eliya.Voldman
Follow / 14 Mar 2018 at 2:47pm / Toad for SQL Server
Latest post by on 14 Mar 2018 at 4:18pm

Navigate in Database Diagram

Expand content
Hello, Recently I found our that Toad provide the option to create Database Diagram. I have a lot of tables in my db hence I found it's very helpful. I created diagram but I have a problem to understand...

Hello,

Recently I found our that Toad provide the option to create Database Diagram. I have a lot of tables in my db hence I found it's very helpful. I created diagram but I have a problem to understand and navigate in it.

E.g. how could I search for particular table? I know the name of if but can't locate it easily. Does it have a 'search' option? What means symbols on diagram? I understand the symbol of primary key but how about the rest?

Any advice?

Thanks

Unanswered 1404 4 / Create an account to join the discussion.
hokiefan1us
Follow / 9 Mar 2018 at 9:31pm / Toad for SQL Server

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 792 0 / Create an account to join the discussion.
aliyazici
Follow / 2 Feb 2018 at 7:34pm / Toad for SQL Server
Latest post by on 5 Mar 2018 at 2:44pm

Is it possible that we can see the triggers more easily?

Expand content
I want to show "Triggers" sub-topic in "Probrammability" in the Object Explorer. How can I do? I am using Toad for SQL Server 6.8.1.204 (64 bit). Thanks

I want to show "Triggers" sub-topic in "Probrammability" in the Object Explorer. How can I do?

I am using Toad for SQL Server 6.8.1.204 (64 bit).

Thanks

Unanswered 1909 1 / Create an account to join the discussion.
SROUSTANG-CRIS
Follow / 28 Feb 2018 at 9:14am / Toad for SQL Server
Latest post by on 5 Mar 2018 at 8:59am

Problem with Toad

Expand content
Hello, I've reinstalled Toad a few days ago. I was using 6.7 before and now using 6.8. I've got a strange behavior when I want to launch a request: the first result to come takes time. Really...

Hello,

I've reinstalled Toad a few days ago. I was using 6.7 before and now using 6.8. I've got a strange behavior when I want to launch a request: the first result to come takes time. Really. More than 15 minutes in fact.

It doesn't depend on the request launched, even with a simple select on a one row table, it takes the same time. Just nothing happens, blue circle in result window and nothing more.

Once the first result has been displayed, next requests will be normally fast.

I've removed the script ran on new connection without result.

My database is a bit huge, around 50 000 tables, may be a problem. But it didn't change since a lot of time.

If anyone has got an idea... ?

Thanks for your help,

Sébastien.

1723 4 / Create an account to join the discussion.
andrew.marsh
Follow / 28 Feb 2018 at 4:47pm / Toad for SQL Server

Tools > Export > Generate DDL Script Error "Problem with...

Expand content
I mainly work with Toad for Oracle, I don't have a lot of experience with Toad for SQL Server. I have no idea what this error message means. Any help would be appreciated. I'm using Version...

I mainly work with Toad for Oracle, I don't have a lot of experience with Toad for SQL Server.  I have no idea what this error message means. Any help would be appreciated.

I'm using Version 5.8.1.916  Xpert Edition.

Thanks

Unanswered 923 0 / Create an account to join the discussion.
susja
Follow / 6 Feb 2018 at 8:27pm / Toad for SQL Server

How to get to 'function' syntax from Toad for SQL

Expand content
Hello, I'm using Toad for SQL Server 6.1.0.1759 On a right sided I have a Tab called Code Snippets. I'm looking for some function syntax or synopsis e.g. I care about synopsis of function...

Hello,

I'm using Toad for SQL Server 6.1.0.1759

On a right sided I have a Tab called Code Snippets.

I'm looking for some function syntax or synopsis e.g. I care about synopsis of function STR.

When I select it from drop-down ... it gives me only what the function does but don't give me syntax and synopsis.

It has an option 'click for online reference' but it also does not help me.

Well my question is: how from inside the Toad I could get syntax or synopsis for particular function?

Thanks

1190 0 / Create an account to join the discussion.