You will no longer receive e-mail notifications from this forum.
Log-In to post
Contact Support on Twitter
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.
It has been a while since the last one was released...
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.
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 184.108.40.2063
I installed le last version of Toad for SQL Server 220.127.116.113 and when i do CTRL + "." the autocompletion window disappear :(
I didn't found a solution on internet :(
any idea ?
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?
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 18.104.22.168.
Thanks in advance for any assistance!!
Hi there, Does anybody know the release date for Toad for SQL Server 6.8 64 bit version ?
Все доброго времени суток.
За время работы в вашей программе столкнулся со следующими проблемами -
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?
VERSION - Toad for SQL Server 22.214.171.1243
Can somebody tell me how to convert OST file to PST, useraccount is no longer in Exchange but exist in AD.
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?
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
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
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.
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?
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.
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?
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!
When will Import Wizard include the feature of row updating? Now there is only inserting or appending rows when importing.
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=126.96.36.199, Culture=neutral
Error appeared when I installed office proplus. How this error can to fix MS SQL?
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!