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.

1078 0 / Create an account to join the discussion.
stout098
Follow / 19 Oct 2017 at 6:19pm / Toad for SQL Server

Table has crashed and the last repair failed

Expand content
Every time when I try to start MySQL, I'm getting an error message : Table has crashed and the last repair failed Any Idea , Suggestions would be appreciated, Thanks, I didn't find the right...

Every time when I try to start MySQL, I'm getting an error message : Table has crashed and the last repair failed

Any Idea , Suggestions would be appreciated,

Thanks,

I didn't find the right solution from the internet.

Unanswered 17 0 / Create an account to join the discussion.
russ b
Follow / 7 Sep 2017 at 5:38pm / Toad for SQL Server
Latest post by on 19 Oct 2017 at 3:32pm

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.

278 9 / Create an account to join the discussion.
marko.beleuca
Follow / 12 Oct 2017 at 12:58pm / Toad for SQL Server
Latest post by on 19 Oct 2017 at 11:40am

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!

63 2 / Create an account to join the discussion.
Clock
Follow / 12 Jul 2014 at 4:00pm / Toad for SQL Server
Latest post by on 15 Oct 2017 at 8:27am

[Data Compare Automation] Export to Excel is very slow

Expand content
Dear Toad and co, First of all: great and advanced features for Data Compare and Automation. They prove to be a big lifesaver in the current project I'm working on. However, I'm running into...

Dear Toad and co,

First of all: great and advanced features for Data Compare and Automation. They prove to be a big lifesaver in the current project I'm working on. However, I'm running into some issues I would like to share with you.

I have made a simple automation procedure that performs a Data Comparison and exports the results to PDF (summary) and Excel (detailed results). The automation script runs fine, but I encounter some issues with the performance when the Excel file is being generated. When I do this manually (Data Compare, save grid to Excel) it takes about 10 seconds. The automation script takes about 8 minutes. This is a real problem for me, since the current comparison is peanuts compared to the heavy ones I need to run in the near future. How can I speed this up?

Verbose logfile of automation execution:

-- 12-7-2014 16:31:28: Run_comparison.log: Setting up environment
-- 12-7-2014 16:31:28: Run_comparison.log: Script run by Toad for SQL Server 6.1.0.1759
-- 12-7-2014 16:31:28: Run_comparison.log: Build started
-- 12-7-2014 16:31:28: Run_comparison.log: Compiling script
-- 12-7-2014 16:31:30: Run_comparison.log: Build completed
-- 12-7-2014 16:31:30: Run_comparison.log: Begin execution script activities
-- 12-7-2014 16:31:53: Run_comparison.log: Data Compare report finished, click Employees_InfoType_0000_CompareSummary2014-07-12 04-31-53.pdf to view file.
-- 12-7-2014 16:31:53: Run_comparison.log: Exporting data compare detail report(s) to Excel
-- 12-7-2014 16:32:35: Run_comparison.log: Exporting data compare detail report: C:\XXXX\SQL\Employees_InfoType_0000_Src_View\Output\report_sap2fr.Employees_InfoType_0000_Src_View - dbo.Employees_InfoType_0000_Dest_View.xlsx
-- 12-7-2014 16:40:05: Run_comparison.log: Data Compare report finished, click report_sap2fr.Employees_InfoType_0000_Src_View - dbo.Employees_InfoType_0000_Dest_View2014-07-12 04-32-35.xlsx to view file.
-- 12-7-2014 16:40:05: Run_comparison.log: Data Compare detail report(s) finished, click Output to view file(s).
-- 12-7-2014 16:40:05: Run_comparison.log: Done

5695 3 / Create an account to join the discussion.
costabas
Follow / 22 Sep 2017 at 10:32pm / Toad for SQL Server
Latest post by on 13 Oct 2017 at 4:39pm

The Data Compare is awesome!

Expand content
I usually come here to report bugs or look for resolutions on issues I have. For once, I used the Data Compare for the first time, I like it very much and I thought of sharing it. It is a nice, good...

I usually come here to report bugs or look for resolutions on issues I have.

For once, I used the Data Compare for the first time, I like it very much and I thought of sharing it. It is a nice, good and useful dialog.

Costa

100 2 / Create an account to join the discussion.
agarcia.planit
Follow / 13 Oct 2017 at 5:31am / Toad for SQL Server
Latest post by on 13 Oct 2017 at 11:56am

The network path was not found when connecting to my SQL Server

Expand content
Hi Can you please help me as I am new to Toad. Trying to connect to my SQL Server I put the correct servername username and password but still have this error "The network path was not found"...

Hi Can you please help me as I am new to Toad.

Trying to connect to my SQL Server I put the correct servername username and password but still have this error

"The network path was not found"

Thanks in advance

63 1 / Create an account to join the discussion.
dauduong
Follow / 5 Sep 2017 at 2:29am / Toad for SQL Server
Latest post by on 12 Oct 2017 at 11:35pm

Toad For SQL - Snippet Token not working in v6.8 x64

Expand content
a token has been defined and tested in the (Test Tab), it is working. It is automatically replace. When in the editor, the text just get overwritten.

a token has been defined and tested in the (Test Tab), it is working. It is automatically replace.

When in the editor, the text just get overwritten.

295 9 / Create an account to join the discussion.
costabas
Follow / 5 Oct 2017 at 9:29pm / Toad for SQL Server

The sql editor slows down significantly in 6.8

Expand content
Hi: I have a sql file that I am working on, it has about 250 lines, and some of the lines are wide (the longest line has 280 chars, it contains a big string). The sql editor slowed so much down that...

Hi:

I have a sql file that I am working on, it has about 250 lines, and some of the lines are wide (the longest line has 280 chars, it contains a big string).

The sql editor slowed so much down that it almost became unusable. Actually I gave up and I switched back to Toad 6.7. The editor is slow in 6.7 as well...

The file contains exec statements of stored procedures.

*** Big Sigh ***

I started to look for a Toad replacement. I am sorry. I might continue paying for maintenance, but I will use another tool for editing sql and running queries.

I don't understand what's going on with this product. I am a software developer myself and I don't get it.

Cheers,

Costa

64 0 / Create an account to join the discussion.
nageshkumarapp
Follow / 3 Oct 2017 at 8:07am / Toad for SQL Server

To partially Match cell against another partial cell

Expand content
I have a problem with two tables which I need to compare dates for the same reference. The problem is that a) the dates are different formats and b) superfluous data is also contained within both date...

I have a problem with two tables which I need to compare dates for the same reference. The problem is that a) the dates are different formats and b) superfluous data is also contained within both date cells.

Global

No. Date
1   1992-08-25 00:00:00.000
2   2015-05-19 00:00:00.000
3   2000-01-12 00:00:00.000

Local

No. Date
1   25.08.1992 00:00:00.000000000 GMT
1   28.08.1992 00:00:00.000000000 GMT
2   19.05.2015 00:00:00.000000000 GMT
3   12.01.2000 00:00:00.000000000 GMT
3   17.01.2000 00:00:00.000000000 GMT

Note that the date formats between the two tables differ and contain lots of time and zero data that is not needed. So ideally I would like to see the format as DD-MM-YYYY.

I would like to return only the Global and Local entries where the Local date differs from Global date. So from the data above, I would want to see:

No. Date        No. Date
1   25-08-1992  1   28-08-1992
3   12-01-2000  3   17-01-2000

I would put my attempts so far, but to be honest I have no idea on how to tackle the partial cell matching and re-formatting.

Any ideas?

Thanks

Nagesh Kumar

42 0 / Create an account to join the discussion.
knot22
Follow / 29 Sep 2017 at 2:50pm / Toad for SQL Server

undo 'dock as tabbed document'

Expand content
Yesterday I right clicked on the Connection Manager window that was located on the left hand side of my screen and selected 'dock as tabbed document'. The Connection Manager window then changed...

Yesterday I right clicked on the Connection Manager window that was located on the left hand side of my screen and selected 'dock as tabbed document'.  The Connection Manager window then changed to a tab rather than a window on the left side.  I liked it better as a window on the left side of the screen and would like to change it back to that configuration.  However, nothing happens when the Connection Manager tab is right clicked.  I was expecting it to give options to change the arrangement but it does not.  I looked through Tools > Options and did not find anything that could change it back to the way it was before this change.  The version is Toad 6.7.0.176.

63 0 / Create an account to join the discussion.
Maurusaurus
Follow / 27 Sep 2017 at 7:59pm / Toad for SQL Server

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

50 0 / Create an account to join the discussion.
sCmancuso
Follow / 21 Sep 2017 at 2:34pm / Toad for SQL Server
Latest post by on 26 Sep 2017 at 6:59am

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 120 1 / Create an account to join the discussion.
costabas
Follow / 24 Aug 2017 at 7:40pm / Toad for SQL Server
Latest post by on 21 Sep 2017 at 4:03pm

Running multiple statements takes a long time to run in 6.8

Expand content
Hi: I started to use 6.8 and something is off when it comes to running multiple sql statements separated with go. I have this script that alters some tables, creates tables (5), inserts some data ...

Hi:

I started to use 6.8 and something is off when it comes to running multiple sql statements separated with go.

I have this script that alters some tables, creates tables (5), inserts some data (about 15 rows), creates foreign key constraints (about 7), nothing major.

In 6.8, I open the script in an editor, I press F5, then the UI freezes for quite a bit of time and it takes a while until this is done ~ 20s. I basically have to do something else. When I execute the same script using the automation manager, it takes just a few seconds, as expected.

Also, I noticed today that when I run one statement (update or select), it takes a good couple of seconds until the result comes back even though the query took let's say 75ms. I just repeated this with a select statement.

In 6.7 the results come back immediately.

*Big Sigh*

Do others experience this?

I run Toad 6.8 64 bit on windows 2008 r2.

308 8 / Create an account to join the discussion.
loddes
Follow / 20 Sep 2017 at 11:10pm / Toad for SQL Server
Latest post by on 21 Sep 2017 at 2:45pm

Toad for SQL Server 6.8 freeware still can't format SQL

Expand content
Toad for SQL Server 6.8 freeware still can't format SQL, although from download page it showed can.

Toad for SQL Server 6.8 freeware still can't format SQL, although from download page it showed can.

121 1 / Create an account to join the discussion.
dauduong
Follow / 11 Sep 2017 at 1:24am / Toad for SQL Server
Latest post by on 21 Sep 2017 at 7:05am

Toad For SQL - Short Cut key is not working in v6.8 x64

Expand content
Keyboard = Management Studio. Start Toad (without connecting to SQL) - Paste in SQL select code, to comment Press Ctrl + K + Ctrl +C ( Not working ) Put Cursor on the Line to Comment Press...

Keyboard = Management Studio.

Start Toad (without connecting to SQL)

- Paste in SQL

select code, to comment

Press Ctrl + K + Ctrl +C (Not working)

Put Cursor on the Line to Comment

Press Ctrl + K + Ctrl +C (Not working)

- Connect to SQL

select code, to comment

Press Ctrl + K + Ctrl +C (Not working)

Put Cursor on the Line to Comment

Press Ctrl + K + Ctrl +C (Not working)

Delete all the pasted text and type in

type in 

select *

from sysobject so

where 1=1

and so.name like 'sys%'

Ctrl + K + Ctrl + C (Not Working)

Start a fresh query,

type in 

select *

from sysobject so

where 1=1

and so.name like 'sys%'

Ctrl + K + Ctrl + C (Working)

284 10 / Create an account to join the discussion.
gag.ran
Follow / 14 Sep 2017 at 5:58pm / Toad for SQL Server
Latest post by on 19 Sep 2017 at 6:54am

Short cut for viewObjectAtCursor command not working

Expand content
Key board short cut for View Object At Cursor command does not work.

Key board short cut for View Object At Cursor command does not work.

Unanswered 176 3 / Create an account to join the discussion.
k.shilpa
Follow / 5 Dec 2016 at 9:08am / Toad for SQL Server
Latest post by on 19 Sep 2017 at 6:35am

Unable to connect using server authentication in toad for sql ser...

Expand content
After creating login i am unable to connect to database using server authentication. I need steps to create login for server authentication in toad for sql server.

After creating  login i am unable to connect to database using server authentication.

I need steps to create login for server authentication in toad for sql server.

Unanswered 808 4 / Create an account to join the discussion.
GeraldNewman
Follow / 26 Jun 2017 at 8:56pm / Toad for SQL Server
Latest post by on 18 Sep 2017 at 7:43am

Convert OST to PST

Expand content
Can somebody tell me how to convert OST file to PST, useraccount is no longer in Exchange but exist in AD. Any suggestion.

Can somebody tell me how to convert OST file to PST, useraccount is no longer in Exchange but exist in AD.

Any suggestion.

741 12 / Create an account to join the discussion.
costabas
Follow / 12 Sep 2017 at 7:57pm / Toad for SQL Server
Latest post by on 14 Sep 2017 at 7:58pm

Restoring sql recall from a previous version

Expand content
Hi: Unfortunately I Restored Defaults in the options dialog (following this thread) and that discarded a vast part of my queries in SQL Recall. The default number is 100 queries, which IMO is very low...

Hi:

Unfortunately I Restored Defaults in the options dialog (following this thread) and that discarded a vast part of my queries in SQL Recall. The default number is 100 queries, which IMO is very low. I like to keep track of all of them from the beginning of time.

Fortunately I haven't uninstalled Toad 6.7 and I have the history there. Is there a way to transfer this history to Toad 6.8?

Thanks

Answered 117 2 / Create an account to join the discussion.