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.

2096 0 / 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!

2114 5 / Create an account to join the discussion.
costabas
Follow / 20 Apr 2018 at 6:11pm / Toad for SQL Server

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

27 0 / 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. 

50 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 504 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 1487 3 / 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 20 Mar 2018 at 10:05pm

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 833 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

4448 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

236 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 475 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 239 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 881 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.

783 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 359 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

610 0 / Create an account to join the discussion.
bhaight
Follow / 23 Jan 2018 at 6:09pm / Toad for SQL Server
Latest post by on 30 Jan 2018 at 8:19am

How to modify the font for the column headers in the Results wind...

Expand content
How can I modify the font for the column headers in the Results window? I would like to make the font bold in order to have it stand out from the actual results. I have played around with the Tools ...

How can I modify the font for the column headers in the Results window?  I would like to make the font bold in order to have it stand out from the actual results.

I have played around with the Tools -> Options -> Interface ->Grid Style and that does not do what I would like.  As a side question is there a way to create custom Grid Styles and/or Skins?

Thanks

Unanswered 1248 1 / Create an account to join the discussion.
jarledge
Follow / 24 Jan 2018 at 4:55pm / Toad for SQL Server
Latest post by on 30 Jan 2018 at 7:54am

Toad Performance is Poor on Database with a large amount of Objec...

Expand content
I work in a database with a large amount of objects and Toad performance is poor. See the following for reference. Object Type Count Default or DEFAULT constraints 35...

I work in a database with a large amount of objects and Toad performance is poor. 

See the following for reference.

Object Type

Count

Default or DEFAULT constraints

             35

Scalar functions

                1

Inlined table-functions

                1

PRIMARY KEY or UNIQUE constraints

   172,050

Stored procedures

             64

System tables

             45

Table functions

                2

Triggers

     19,039

User tables

   229,710

Views

       6,996

Any suggestions on how to improve performance?

1375 4 / Create an account to join the discussion.
Ralf.Sommer
Follow / 26 Jan 2018 at 9:53am / Toad for SQL Server
Latest post by on 29 Jan 2018 at 9:29am

Oracle Formatting Options - JOIN direct under FROM

Expand content
Hello, I can nowhere find an option how I can define that the JOIN's are directly formatted like the from or where. The JOIN in a new line is just allignet right by the FROM. I would like it so...

Hello,

I can nowhere find an option how I can define that the JOIN's are directly formatted like the from or where. The JOIN in a new line is just allignet right by the FROM.


I would like it so:

SELECT table1.id, table2.id, table3.id, table4.id
  FROM table1
  JOIN table2 on table2.id = table1.id
  LEFT JOIN table3
  NATURAL JOIN table4;

I dont like it so:

SELECT table1.id, table2.id
  FROM table1
       JOIN table2 on table2.id = table1.id
       LEFT JOIN table3
       NATURAL JOIN table4;

regards Ralf Sommer

1322 5 / Create an account to join the discussion.
LK
Follow / 12 Jan 2018 at 8:43pm / Toad for SQL Server
Latest post by on 16 Jan 2018 at 9:44am

Active Directory Password Authentication

Expand content
Is it possible to authenticate using Active Directory Password Authentication in Toad for SQL Server 6.8? In Microsoft SQL Server Management Studio there's an option for this, but in Toad for SQL Server...

Is it possible to authenticate using Active Directory Password Authentication in Toad for SQL Server 6.8?  In Microsoft SQL Server Management Studio there's an option for this, but in Toad for SQL Server there's only "Windows Authentication" and "SQL Server Authentication".  My Login name is my email address, e.g., last.first@domain.com.  When I login with SQL Server Authentication in Toad, it fails with the error message "Cannot open server "domain.com" requested by the login.  The login failed."

Thanks in advance

Answered 1554 1 / Create an account to join the discussion.
gmrober
Follow / 10 Jan 2018 at 6:53pm / Toad for SQL Server
Latest post by on 11 Jan 2018 at 3:02pm

Double Clicking Table in Object Explorer - Change Behavior?

Expand content
In the object explorer, when I see a list of table names, 99% of the time in my organization we right click, go down to "Generate SQL" and click "Select statement" or some other SQL...

In the object explorer, when I see a list of table names, 99% of the time in my organization we right click, go down to "Generate SQL" and click "Select statement" or some other SQL statement.

Is there a way to change a setting so that when you double click a table it automatically generates a Select statement? Currently when I double click it brings up an "Alter Table" dialog which we never use. Having it generate a Select statement for that table would save a lot of time.

1494 2 / Create an account to join the discussion.