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.

980 0 / Create an account to join the discussion.
costabas
Follow / 25 Nov 2016 at 8:45pm / Toad for SQL Server
Latest post by on 22 Aug 2017 at 6:22pm

When is the next version going to be released?

Expand content
It has been a while since the last one was released... Thanks

It has been a while since the last one was released...

Thanks

Answered 1182 14 / Create an account to join the discussion.
costabas
Follow / 21 Aug 2017 at 8:05pm / Toad for SQL Server
Latest post by on 22 Aug 2017 at 6:10pm

Running multiple scripts in one shot

Expand content
Hi: More often than not, I have multiple scripts that I need to run as part of a test/production deployment or during development. For instance, I have a script that creates tables and another one that...

Hi:

More often than not, I have multiple scripts that I need to run as part of a test/production deployment or during development. For instance, I have a script that creates tables and another one that populates them with data. Sometimes, I want to run both scripts in one shot. Currently, I have them open in two tabs, I select one script, I run it (I press F5), I wait until it's done, then I select the other script and I run it. As a side note, In 6.8, when I run a script that takes longer to process, it blocks the entire UI - as far as I recall it didn't used to do this in 6.7.

Anyway, in my mind it would be nice if Toad allowed me to define a deployment manifest consisting of the scripts I want to run so I can run them using one click. Is this currently doable in 6.8? 

The alternative is to define a cmd file and use the sqlcmd utility to run the scripts. That's what I've done so far.

Thanks

11 1 / Create an account to join the discussion.
vane
Follow / 22 Aug 2017 at 7:56am / Toad for SQL Server

Export error HY001 (Access database file)

Expand content
When I export data, an error occurs. Please help. Thanks. ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables. Export is cancelled. Toad for SQL Server 6.6.0.963 SQL...

When I export data, an error occurs. Please help. Thanks. 

ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables. Export is cancelled.

Toad for SQL Server 6.6.0.963

SQL 2000

Access 2010x64

Unanswered 13 0 / Create an account to join the discussion.
schubby
Follow / 3 Aug 2017 at 7:10pm / Toad for SQL Server
Latest post by on 17 Aug 2017 at 3:08pm

The autocompletion window disappear

Expand content
Hello, I installed le last version of Toad for SQL Server 6.6.0.963 and when i do CTRL + "." the autocompletion window disappear :( I didn't found a solution on internet :( any idea...

Hello,

I installed le last version of Toad for SQL Server 6.6.0.963 and when i do CTRL + "." the autocompletion window disappear :(

I didn't found a solution on internet :(

any idea ?

Nicolas

108 3 / Create an account to join the discussion.
helpdesk_10043
Follow / 7 Aug 2017 at 5:34pm / Toad for SQL Server
Latest post by on 7 Aug 2017 at 9:36pm

Execute option is greyed out

Expand content
I am relatively new to Toad for SQL. I only know how to run an existing script. My PC was reimaged and I had to download Toad for SQL again. I am using v6.6, which is a new version than I was previously...

I am relatively new to Toad for SQL. I only know how to run an existing script. My PC was reimaged and I had to download Toad for SQL again. I am using v6.6, which is a new version than I was previously using. I update the script and saved it. I want to execute it now, but the execute option is greyed out. F9 doesn't work. Also, there is now execute icon on the ribbon. Can anyone help me?

Thank you.

81 3 / Create an account to join the discussion.
mitchell.sacks_234
Follow / 1 Aug 2017 at 5:19pm / Toad for SQL Server

Imports ignoring processing row count

Expand content
Hi, This just started happening recently. For some reason, Toad is ignoring the processing row count when importing data, and defaulting to importing 1 row at a time. So even if I leave the import template...

Hi,

This just started happening recently.  For some reason, Toad is ignoring the processing row count when importing data, and defaulting to importing 1 row at a time.  So even if I leave the import template set to the default of 500, it just does 1 row at a time - I can see this by monitoring the import via the background process window.  My imports are taking forever, and I can't figure out why.  I used to be able to set the processing row count as high as 10000 and import performance was fantastic.  Anyone have an idea what might have changed.  I've tried rebooting, deleted and re-created the import templates, and a few other things I could think of, but nothing seems to help.

I am currently running Toad for SQL Server 6.7.0.176.

Thanks in advance for any assistance!!

49 0 / Create an account to join the discussion.
Rod
Follow / 28 Jul 2017 at 3:52pm / Toad for SQL Server
Latest post by on 31 Jul 2017 at 1:02pm

Hi, Quick question, Does anybody know the release date for Toad for...

Expand content
Hi there, Does anybody know the release date for Toad for SQL Server 6.8 64 bit version ? Thanks

Hi there,   Does anybody know the release date for Toad for SQL Server 6.8 64 bit version ?

 Thanks

Answered 149 2 / Create an account to join the discussion.
BAH--zer
Follow / 31 Jul 2017 at 7:32am / Toad for SQL Server

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 48 0 / Create an account to join the discussion.
GeraldNewman
Follow / 26 Jun 2017 at 8:56pm / Toad for SQL Server
Latest post by on 27 Jul 2017 at 11:12am

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.

288 7 / Create an account to join the discussion.
DanMerrill
Follow / 20 Jul 2017 at 2:19pm / Toad for SQL Server
Latest post by on 21 Jul 2017 at 1:49pm

Microsoft Dynamics AX SQL Server database

Expand content
I have a Microsoft Dynamics AX SQL Server database. Everything was running fine until today. The error message occurs, SQL Server Table Corruption Error. Do you have any suggestions how to work around...

I have a Microsoft Dynamics AX SQL Server database. Everything was running fine until today. The error message occurs, SQL Server Table Corruption Error.

Do you have any suggestions how to work around it? What could make this error and how to fix SQL Server database?

Answered 102 1 / Create an account to join the discussion.
Maxrad
Follow / 20 Jul 2017 at 2:58pm / Toad for SQL Server

Automation editor Issues,

Expand content
Hi I keep getting errors in the Automation editor, once I reopen a .TAS file (or if it accidentally closes) i loose the ability to edit the file : Have anyone had the same issue? Any known solutions...

Hi I keep getting errors in the Automation editor,  once I reopen a .TAS file (or if it accidentally closes)  i loose the ability to edit the file : 

Have anyone had the same issue?  Any known solutions?  

This issue started with the newest update of Toad

Best Regards

Max

57 0 / Create an account to join the discussion.
ubeauty
Follow / 10 Mar 2016 at 9:47am / Toad for SQL Server
Latest post by on 13 Jul 2017 at 5:57pm

Keyboard Shortcuts

Expand content
Morning all Does anyone have a list of keyboard shortcuts for Toad for SQL Server at all? I did pick up a mouse mat from a previous SQL Bits but this was a Toad for Oracle one. Anyone know the shortcuts...

Morning all

Does anyone have a list of keyboard shortcuts for Toad for SQL Server at all?

I did pick up a mouse mat from a previous SQL Bits but this was a Toad for Oracle one.

Anyone know the shortcuts for Comment\Uncomment as when you add them to the Menu bar they dissapear when you close and reopen Toad

Many thanks

Karl

Unanswered 2347 4 / Create an account to join the discussion.
rsmith
Follow / 10 Apr 2013 at 11:31pm / Toad for SQL Server
Latest post by on 9 Jul 2017 at 2:49am

The BLOB size is too large. Cannot generate script for this log r...

Expand content
attempted to undo a transaction of which has a big blob associated with it. stating that the BLOB size is to large. there's an article that references it. https://support.quest.com/SolutionDetail.aspx...

attempted to undo a transaction of which has a big blob associated with it. stating that the BLOB size is to large.


there's an article that references it.

https://support.quest.com/SolutionDetail.aspx?ID=103725


just worked on code all day and overwrote it by accident. it shows where I overwrote it in the transaction log but doesn't want to restore it due to the limitation in the above article.


is there a way to increase the memory with the application to allow it to generate the script?

5333 4 / Create an account to join the discussion.
Saeed003
Follow / 5 Jul 2017 at 1:53pm / Toad for SQL Server

Toad does not allow editing

Expand content
hi, am using oracle 10g i have multiple tables and views. my problem is when i type name of view and press F4 key it leads me to the view painter which is fine but in the same painter there is a button...

hi,

am using oracle 10g i have multiple tables and views. my problem is when i type name of view and press F4 key it leads me to the view painter which is fine but in the same painter there is a button called script( to see the script for the specific view) and Clicks the 'Copy script to editor' option shown at the left top of window it copies the script in the editor but does not allow me to edit the query.

anyone knows the reason behind this issue , kindy share your views, your help would be highly appreciated.

Thanks

100 0 / Create an account to join the discussion.
jlhook
Follow / 15 May 2015 at 5:45pm / Toad for SQL Server
Latest post by on 4 Jul 2017 at 10:06am

Shared snippets and CTL-SPACE

Expand content
I'm using TOAD for SQLServer V6.6. When I first started using the program, I created local snippets. I always included a "shortcut" for each snippet. In the query edit window, I could type...

I'm using TOAD for SQLServer V6.6.


When I first started using the program, I created local snippets. I always included a "shortcut" for each snippet. In the query edit window, I could type in the shortcut text then press CTL-SPACE to expand the shortcut. That worked really well. I then decided to share my snippets so I set up a "shared snippets folder" and moved all of my snippets there. Now when I enter the short cut text and press CTL-SPACE I get a prompt that asks me to "Insert Snippet:" and I have to use the mouse to select the directory and snippet. It is not nearly as nice as CTL-SPACE. How can use "short cutes" with CTL-SPACE with shared snippets?

3637 3 / Create an account to join the discussion.
IronToadX
Follow / 29 Jun 2017 at 7:25pm / Toad for SQL Server
Latest post by on 4 Jul 2017 at 9:46am

Toad Data Modeler or Toad for SQL Server?

Expand content
Looking to understand the differences between these 2 products. Can Data Modeler do everything that Toad for Sql Server can as far as Sql Server goes? Thanks for any feedback!

Looking to understand the differences between these 2 products.

Can Data Modeler do everything that Toad for Sql Server can as far as Sql Server goes?

Thanks for any feedback!

159 1 / Create an account to join the discussion.
vane
Follow / 6 Jun 2017 at 4:45am / Toad for SQL Server

Import issue

Expand content
When will Import Wizard include the feature of row updating? Now there is only inserting or appending rows when importing. Thanks.

When will Import Wizard include the feature of row updating? Now there is only inserting or appending rows when importing.

Thanks.

Unanswered 138 0 / Create an account to join the discussion.
Scottco93
Follow / 27 May 2017 at 9:54pm / Toad for SQL Server
Latest post by on 28 May 2017 at 3:08pm

Access Object Collector error

Expand content
I got following error while converting access db to MS SQL 2016 db using Microsoft SQL server migrant assist (MSSMA). Text of error: Access Object Collector error: Database. Could not load file or...

I got following error while converting access db to MS SQL 2016 db using Microsoft SQL server migrant assist (MSSMA).

Text of error:

Access Object Collector error: Database. Could not load file or assembly 'Microsoft.Office.Interop.Access.Dao, Version=12.0.0.0, Culture=neutral

Error appeared when I installed office proplus. How this error can to fix MS SQL?

Answered 269 1 / Create an account to join the discussion.
sherlyn.divya
Follow / 9 May 2017 at 3:17pm / Toad for SQL Server
Latest post by on 23 May 2017 at 2:38am

Toad Sql Server Import Wizard - difference seen in the rows loaded...

Expand content
I'm using Toad Import wizard to load a csv file into a Sql server table. When I do smaller loads it works fine and it has always worked fine, but this time my file is large. I imported the file and...

I'm using Toad Import wizard to load a csv file into a Sql server table. When I do smaller loads it works fine and it has always worked fine, but this time my file is large. I imported the file and the wizard said 1.9M rows have been loaded but when I look at the table it has only 1.3M rows. There are no errors on the log file, there are no triggers on the table, no space issues, nor any transformations that I'm applying during the load. Any reason or thoughts on why this difference in numbers between what toad tells me its loaded versus the actual number in the table? 

Thank you in advance!

Unanswered 296 2 / Create an account to join the discussion.