Log-In to post
Tomorrow, we are kicking off a new daily content feature in Social Media.
We can show your Social Media presence with other Toad users tomorrow using the hashtag, #ToadTuesday
This is the tweet that will start the hashtag trending:
Hashtag game! Tweet out how long Toad has been a part of your life! Tag w/ #ToadTuesday
You could be featured on next blog!
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
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.
.This is version 6.6 of TOAD FOR SQL SERVER (Freeware):System.ArgumentExceptionOs controles criados em um thread não podem ser controles pai de um controle em um outro thread.Nome do parâmetro: valueStack Trace: em System.Windows.Forms.Form.set_MdiParentInternal(Form value) em System.Windows.Forms.Form.set_MdiParent(Form value) em Quest.Toad.Gui.MainForm.CreateTabbedDocument(DocumentForm document) em Quest.Toad.Gui.MainForm.set_ActiveDocument(DocumentForm value) em Quest.Toad.Gui.MainForm.AddDocument(DocumentForm form) em Quest.Toad.Gui.DocumentForm.CreateDocument(Type type, IConnection connection, Boolean withInitialTemplate) em Quest.Toad.Analyst.AnalystActionManager.OpenSqlEditorDocument(Object oSender, ITrl aitrls) em Quest.Toad.Editor.EditorForm.OpenAnalystDocument(Object sender, ITrl trls) System.ArgumentExceptionOs controles criados em um thread não podem ser controles pai de um controle em um outro thread.Stack Trace: em System.Windows.Forms.Control.ControlCollection.Add(Control value) em System.Windows.Forms.Control.set_ParentInternal(Control value) em System.Windows.Forms.Control.set_Parent(Control value) em Quest.Toad.Gui.MainForm.MainFormDocumentManager.CreateToolwinTemp(DockPanel toolWindow) em Quest.Toad.Gui.MainForm.MainFormDocumentManager.GetToolWindow(Guid key) em Quest.Toad.Gui.MainForm.MainFormDocumentManager.FindOpenedToolWinControl(Guid key) em Quest.Toad.Gui.MainForm.FindOpenedToolWin(Type type) em Quest.Toad.DatabaseBrowser.ObjectPaletteControl.get_ActivePalette() em Quest.Toad.Editor.EditorForm.SynchronizeActionBarDatabases() em Quest.Toad.Editor.EditorForm.EditorForm_Load(Object sender, EventArgs e) em System.EventHandler.Invoke(Object sender, EventArgs e) em System.Windows.Forms.UserControl.OnLoad(EventArgs e) em System.Windows.Forms.UserControl.OnCreateControl() em System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) em System.Windows.Forms.Control.CreateControl() em System.Windows.Forms.Control.WmShowWindow(Message& m) em System.Windows.Forms.Control.WndProc(Message& m) em System.Windows.Forms.ScrollableControl.WndProc(Message& m) em System.Windows.Forms.ContainerControl.WndProc(Message& m) em System.Windows.Forms.UserControl.WndProc(Message& m) em System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) em System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I've noticed that when my boss uses Toad for SQL Server and he wants to generate a string field with in essense an infinite length, that it generates it using the data type text. Here's an example of a very simple table, where the field name Comments illustrates what I'm talking about:
CREATE TABLE SomeTable ( Id Int IDENTITY(1,1) NOT NULL, Comments text NULL, CONSTRAINT IX_Id PRIMARY KEY CLUSTERED ( Id ASC ) )
The data type VARCHAR(MAX) (or NVARCHAR(MAX)) is favored over the older data type text (or ntext). Is there a way of making Toad for SQL Server generate VARCHAR(MAX)/NVARCHAR(MAX) when generating the code that it does to create/modify a table?
Anybody know if this bug has been fixed? It was posted in August of 2016 and I do not see a resolution yet.
Alter View window can cause table locking
In the background, when doing an Alter View or Alter View as Script, Toad executes the following to get information about the table in a view
BEGIN TRANSACTION; SET FMTONLY ON; SELECT * FROM tablename COMMIT TRANSACTION; SET FMTONLY OFF;
The problem is that a COMMIT TRAN is issued in between the SET FMTONLY ON and OFF which means it will never be actually run. The COMMIT should be after the SET FMTONLY OFF command. This can cause long term blocking.
Waiting for fix in a future release of Toad for SQL Server
I just installed toad on my new pc 64 bits , configured a item as I use to do and I get this error. It seems that there is a missing installation file.
Indeed, the folder is empty. What is the matter with it ?
Shoul i also install sql server on my pc ?
System.UnauthorizedAccessExceptionAccess to the path 'C:\Users\XXXX\AppData\Roaming\Quest Software\Toad for SQL Server Freeware 6.6\Templates\Scripts\InitialSqlServer.Sql' is denied.Stack Trace: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost) at System.IO.File.Copy(String sourceFileName, String destFileName) at Quest.Toad.SqlServer.SqlServerSettings.CheckNewConnectionScriptFile() at Quest.Toad.SqlServer.SqlServerSettings..ctor()
If I right-click on a database trigger in Object Explorer and select Version Control, all of the choices are disabled. Is there a way to add this type of object to Version Control (I'm using TFS 2012).
1) Adding a new procedure requires disconnect and reconnect before appearing in Object Explorer.
2) Objects in the database but not in the repository (status = Untracked) do not appear in the Perspectives tab:
Is there a reason why a 6.7 free version isn't released yet??
When do you plan to publish a new free release? will be a 6.7 or directly a 6.8 (32/64bit)?
I just downloaded version 6.7 and found what I believe is a bug. When I right click on a table in the Object Explorer window and then Options --> Extra Columns --> and select "Columns" and/or "Creation Date", the data in these columns are flip-flopped. Is anyone else noticing this?
In Toad 6.7, is there a way to get rid of the prefix 'Editor ' in the tab caption and have it display just the file name? The tabs are very long and I usually have a lot of files open and I can see only up to 3 at the time. And no, getting a bigger monitor is not an option.
Also, the Windows dialog (Window->Windows...) - can you please, please, please, display the full text for each tab and remove any elipsis (...) string? There is plenty of space - that's the whole purpose of the Windows dialog, don't you think? The window that is displayed when I press CTRL+Tab suffers from the same affliction. I cannot see the full names of the files. Again, get rid of the preview or make it an option and show the full names.
The triangle button (pointing down) on the top right (besides the connection button) is supposed to display a list of tabs when I click on it. Most of the time, instead of displaying the tabs list, it shows the context menu. Can you please, please, please fix this?? It is annoying as hell.
Another annoying thing, I use a lot Shift+F4 to display information about a table or view or stored procedure. Shift+F4 doesn't work for code in the Object Details. Why??
The Object Explorer window sometimes doesn't remember an active filter I set for, let's say, procedures, when I leave that section of the tree and come back to it. In this case resetting the filter doesn't have any effect by selecting None in the dropdown menu. I have to go back and forth between different sections (tables, views) and eventually it appears back. Very annoying.
Also, in the Object Explorer when I right-click and choose View Details, an empty tab appears in the Object Details window. I have to move to another object and then come back to this one to make it display the details of the object I originally selected.
In all honesty, I was hoping you re-write this tool in Delphi. I don't want to be negative, and I don't want to bash the tool, I think you guys are hard working but when I have so much work to do and the little things don't work properly it's very frustrating.
Your last release was in May. I was hoping you have another release where you fix all these annoying bugs but I can only hear the crickets. I noticed that toad for Oracle had more releases since May which I find interesting.
I have this problem since the last version of the software. When I use "Schema Compare" and generated the script I get the following error on execution:
SQL Server Database Error: 'CREATE/ALTER PROCEDURE' debe ser la primera instrucción en un lote de consultas.
The first lines of script generated are:
/* Script created at 20/06/2016 9:15. Please back up your database before running this script.
Source server: XXXXXXXXX Source database: XXXXXXXXX
Target server: XXXXXXXXXX Target database: XXXXXXXXX*/
SET NUMERIC_ROUNDABORT, IMPLICIT_TRANSACTIONS OFFSET ANSI_PADDING, ANSI_NULLS, QUOTED_IDENTIFIER, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, XACT_ABORT ONSET TRANSACTION ISOLATION LEVEL SERIALIZABLEGO
SET ANSI_NULLS ONSET QUOTED_IDENTIFIER ON
ALTER PROCEDURE [dbo].[VI_MENSAJE_SIMPLE_ENV_SEL](-- PARAMETROS DEL PROCEDIMIENTO
@idMensaje int = null,
Could you help me? Thanks in advance.
In this sql server tutorial video in the Sven Aelterman's SQL Review series, the focus is on writing queries in the real-world. A significant portion of the video is spent on step-by-step solution development for a complex query in the AdventureWorks2012 sample database. A date arithmetic function is introduced to solve one of the query's problems.
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.
Last official release of TOAD 22.214.171.124.
I connect to my SQL Server 2012 with service pack 3 developer edition.
I try to debug a stored procedure that contains UDT.
I obtain a GPF.
See my scrennshot in attach for details :
I stay tune from your consideration,
I'm looking at TOAD for SQL Server as a replacement for SSMS, but it appears as thought there is some functionality missing in TSS. Specifically the commands and management options for supporting and administrating my AlwaysOn cluster in SQL 2012? Is this true or am I missing it from somewhere or do I have to turn it on some how?
I'm currently using TOAD for SQL Server 6.6 Xpert edition. Any info would be helpful.
Using toad for MS-SQL v6.6 and it fail to read DB log file.
Hello. We are ramping up an evaluation period for migrating Oracle databases to SQL Server. We are big time TOAD users for Oracle, and I have a group of non-admin power users who will definitely need a tool for a front end. For now, I would like a freeware copy or a trial version to allow me to justify purchase. I found an older copy of freeware, V6.6, but it doesn't support Windows 10. It might still work. When I look at what is available for me to evaluate, it's overwhelming! I also notice that the trial version is for 30 days, which definitely will not be enough time. I
I'd appreciate some insight into what product I should be looking at, and experiences from Oracle to SQL Server that might help.
We are using SQL Server 2016 for this project.
I sometimes need to change data manually. I double-click on the table, I navigate to the Data tab in the Object Details window, I find the record, then I attempt to modify the record, but as soon as move off the record I invariably get the message: Concurrency Violation. Expected to update 1 row(s), but actually updated 0 row(s).
My question is this. All my tables have primary keys. Why isn't Toad able to figure out automatically the update statement it has to run to update the record? Yes, if I configure the update/delete/insert statements by selecting the Define Custom Editing option it works, but why do I have to do that, since all the information needed to infer the three statements is there already.
Is there an option to tell Toad to do it automatically?