Toad for SQL Server Forum - Toad for SQL Server - Toad World
Danny Torres
Follow / 16 Jan 2017 at 8:26pm / Toad for SQL Server
Latest post by on 24 Mar 2017 at 3:01pm

Hashtag game! Tomorrow, let's make #ToadTuesday trend!

Expand content
Hi All, 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...

Hi All,

 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!

271 2 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 2:01pm / Toad for SQL Server

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
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

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

451 0 / Create an account to join the discussion.
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.

795 0 / Create an account to join the discussion.
russ.barth
Follow / 7 Mar 2017 at 5:37pm / Toad for SQL Server
Latest post by on 29 Mar 2017 at 4:59pm

I'm evaluating Toad for SQL Server and have some questions

Expand content
I've used Toad for MySQL for over 10 years. I have a love hate relationship with it, it often gets released with broken features, but it's free, so what can you do? I've recently switched...

I've used Toad for MySQL for over 10 years.  I have a love hate relationship with it, it often gets released with broken features, but it's free, so what can you do?

I've recently switched jobs and am now in a .NET / SQL Server shop.  So I decided to try out Toad for SQL Server.  It seems that it's missing features that are in the freeware MySQL version.  For example:

  • Block inserts are not an option in the Export to Wizard when choosing to export to SQL Script
  • Exporting is not working on simple data types such as ints nvarchars.  This happens on both export to excel and export to SQL Script.  It will export the records, but most of the fields are just left blank or null.

I've tried both the trial and freeware versions of SQL Server and both have these issues.  Exporting is one of the features I use more than anything.  Are the trials/freeware versions crippled?  I know you have three tiers of pricing for the SQL server version, but this is such a basic function that I'm surprised it's not in the the Trial at least.  

I'm pretty sure I only need the Professional Version, at least I don't need data compare and just need the features in the MySQL freeware version.  If you've crippled the trial and freeware below the first tier on your pricing, how can I justify the $655 cost for the Professional Version to my new boss?

Answered 293 9 / Create an account to join the discussion.
costabas
Follow / 22 Mar 2017 at 5:53pm / Toad for SQL Server
Latest post by on 27 Mar 2017 at 6:31pm

Code formatter dialog - Custom tab issues

Expand content
Hello: These have been old issues, I never reported them, but today somehow it seems more annoying than usual. 1. I navigated to Options->Editor Formatter->Custom tab. 2. Issue #1. Expanding...

Hello:

These have been old issues, I never reported them, but today somehow it seems more annoying than usual.

1. I navigated to Options->Editor Formatter->Custom tab.

2. Issue #1. Expanding nodes does not refresh the tree (I am using windows 2008 r2). To get the node refreshed I have to click again on the tree node and then its child nodes appear.

3. Issue #2. There is no scrollbar in the formatter options tree. The Options dialog itself is not resizeable. If I expand too many nodes I cannot really get to the bottom nodes.

4. Issue #3. The keyboard up/down keys don't work on the formatter options tree. I have to use the mouse to navigate to the option I want.

5. Issue #4. I click on the formatter options tree (the mouse cursor is above the tree). When I try to use the mouse wheel it scrolls the editor behind the Options dialog and not the formatter options tree.

Please fix these issues.

Thanks

71 3 / Create an account to join the discussion.
david_74271
Follow / 20 Jun 2016 at 8:36am / Toad for SQL Server
Latest post by on 23 Mar 2017 at 12:50pm

Toad for SQL Server 6.7.0.176- Problem with Schema Compare

Expand content
Good morning 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...

Good morning

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:

USE [XXXXXXXX]
GO

/*
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 OFF
SET ANSI_PADDING, ANSI_NULLS, QUOTED_IDENTIFIER, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, XACT_ABORT ON
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

BEGIN TRANSACTION
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON

ALTER PROCEDURE [dbo].[VI_MENSAJE_SIMPLE_ENV_SEL]
(
-- PARAMETROS DEL PROCEDIMIENTO


@idMensaje int = null,

.........

Could you help me? Thanks in advance.

1559 6 / Create an account to join the discussion.
jspringe
Follow / 22 Mar 2017 at 9:19pm / Toad for SQL Server

Does Toad for SQL Server supporting the APS (Parallel Data Warehouse...

Expand content
I am using Toad for SQL Server 6.6 Freeware. We are connecting to Microsoft Appliance Analytical Platform System. It appears that not all commands are supported. We connect, then click on a table and continually...
I am using Toad for SQL Server 6.6 Freeware.  We are connecting to Microsoft Appliance Analytical Platform System. It appears that not all commands are supported.  We connect, then click on a table and continually receive the error message 'COLUMNPROPERTY' is not a recognized built-in function name.  Is this a freeware issue or Toad for SQL Server unsupported command?
Unanswered 35 0 / Create an account to join the discussion.
AJ0101
Follow / 21 Mar 2017 at 10:15pm / Toad for SQL Server

Generating a Hyperperlink for the links which are exported from Sql...

Expand content
Hello Guys, I am new for this Toad for Sql Server. I have a database which contains specific links to each records. Each record have different links adding a different parameters to that link. Record contains...

Hello Guys, I am new for this Toad for Sql Server. I have a database which contains specific links to each records. Each record have different links adding a different parameters to that link. Record contains more than 1000 records. When I export them with a Sql Query to excel using export wizard those  links does not have hyperlink. How can I generate an export which even have hyperlinks to each and every links given in that export data.

Thanks in advance.

36 0 / Create an account to join the discussion.
Kevin Nechodom
Follow / 20 Mar 2017 at 6:09pm / Toad for SQL Server

How do I use TOAD for SQL Server with SSDT database projects?

Expand content
We have a substantial amount of work on a database project that is managed within SQL Server Data Tools (under VS2015), and stored in TFS. When I look to see how TOAD can use TFS, it appears to start from...

We have a substantial amount of work on a database project that is managed within SQL Server Data Tools (under VS2015), and stored in TFS.  When I look to see how TOAD can use TFS, it appears to start from the standpoint of the database, leaving our changeset history orphaned if we switch over to TOAD.

I am a TOAD newbie, so I realize I am not speaking the right language, but I would appreciate any pointers on how to accomplish this.  Is there a way to have TOAD side-by-side with VS2015, so that both can reference the same TFS objects, or am I looking at a cut-over project?

Thank you, Kevin

Unanswered 52 0 / Create an account to join the discussion.
harsha.siripurapu
Follow / 16 Mar 2017 at 3:22pm / Toad for SQL Server

Multiple statement execution

Expand content
Hi, I have two SQL statements (insert and select). I am trying to execute those two statements at the same time. When I click F5 it works fine but when I click F9 it gives me an error saying that command...

Hi,

I have two SQL statements (insert and select). I am trying to execute those two statements at the same time. When I click F5 it works fine but when I click F9 it gives me an error saying that command is not properly ended. I do this pretty often in SQL server and I am new to TOAD. It works fine in SQL server when you execute multiple statements. Aren't we supposed to execute multiple statements in Oracle TOAD? Can you please help me on this.

47 0 / Create an account to join the discussion.
observingman
Follow / 21 Oct 2015 at 4:56pm / Toad for SQL Server
Latest post by on 16 Mar 2017 at 11:41am

disable prefix for schema name

Expand content
Hello, I'm using trial version of Toad for Sql Server ver. 6.6.0.963. What I want is to disable the insertion of "dbo.objectname" when auto complete suggests things. I've already...

Hello,

I'm using trial version of Toad for Sql Server ver. 6.6.0.963. What I want is to disable the insertion of "dbo.objectname" when auto complete suggests things.


I've already disabled the Editor - Code completion --> Insert default schema name  checkbox, but Toad still gives me the suggestions with the .dbo prefix, and for me it's redundant (call me puristic).

Thanks in advance !

2063 2 / Create an account to join the discussion.
ArtUrlWWW
Follow / 15 Mar 2017 at 10:32am / Toad for SQL Server

Creating new code snippets

Expand content
Hello. I've used Toad for Oracle more than 6 years ago and forget, how to create code snippets. Now I want to create snippet in Toad for SQL Server: select * from | with ( nolock ) I want...

Hello.

I've used Toad for Oracle more than 6 years ago and forget, how to create code snippets.

Now I want to create snippet in Toad for SQL Server:

select *

from | with(nolock)

I want to force snippet to place cursor after from statement - I tried to use "|" for it, but it doesn't work, as expected - after code snippet was placed in editor, result is same, as in Code Snippet Editor and cursor was not placed to position of "|":

select *

from | with(nolock)

I use Toad for SQL Server 6.7.0.176.

I remembered, that in old time I was able to add cursor position and parameters in code snippets.

How to correctly define cursor position and parameters in this new version (for me) of Toad?

Thank you!

Unanswered 42 0 / Create an account to join the discussion.
Alan Scott
Follow / 10 Mar 2017 at 4:04pm / Toad for SQL Server
Latest post by on 13 Mar 2017 at 6:13am

How to download over half a million rows to a file

Expand content
Hello...I'm using Toad for Sql Server, version 6.5.0.3282. I have over half a million rows I need to provide to another work group who will upload the data in an entirely different and disconnected...

Hello...I'm using Toad for Sql Server, version 6.5.0.3282.

I have over half a million rows I need to provide to another work group who will upload the data in an entirely different and disconnected system so they can run some tests on it.  I'm hoping there's a way to download my data to a  file I can FTP to them.  The Export feature only lets me export about 70k rows.  I haven't found a way, if there is one, of increasing that capacity.  

Thank you for considering my question.

Alan

Unanswered 77 1 / Create an account to join the discussion.
costabas
Follow / 2 Mar 2017 at 8:33pm / Toad for SQL Server
Latest post by on 6 Mar 2017 at 2:12am

Bug when exporting data from grid inside Object Details

Expand content
I have came across a strange bug. Here is the context. I have a query editor open and I ran a query select * from Table1. The data is displayed in the grid. In the object explorer window I selected...

I have came across a strange bug.

Here is the context.

I have a query editor open and I ran a query select * from Table1. The data is displayed in the grid.

In the object explorer window I selected a table, let's call it Table2,  I right-clicked and I selected View Details to display the Object Details window and to look at  the Table2 data. Eventually it is displayed, I clicked on the Data tab, I see the data, I right-clicked inside the grid and I selected Quick Export -> File ->Excel File. When I opened the spreadsheet I noticed that Toad exported the data from Table1 instead of the data from Table2 which is displayed in Object Details!!

Could you please look into this and fix it?

Thank you

165 3 / Create an account to join the discussion.
Ericpeeg
Follow / 23 Feb 2017 at 2:38pm / Toad for SQL Server
Latest post by on 23 Feb 2017 at 2:58pm

Can the default ReferenceLevel in the Diagrammer be changed from 1...

Expand content
Hi - I'm new to Toad, and I'm still trying to determine if I can configure it to generally conform to my work preferences. I don't frequently use drag-and-drop functionality like the Diagrammer...

Hi - 

I'm new to Toad, and I'm still trying to determine if I can configure it to generally conform to my work preferences. I don't frequently use drag-and-drop functionality like the Diagrammer, but occasionally I do. By default, the tool seems to pull in all tables referenced by foreign keys, which I don't want. I understand how to alter the reference level setting for the diagrammer to stop this behavior, but is there a way to set the ReferenceLevel to 0 by default? I've poked around in the options menus, but can't seem to locate it.

Thanks for any assistance or hints more experienced Toad users can offer!

143 1 / Create an account to join the discussion.
netanel
Follow / 22 Jan 2017 at 8:05am / Toad for SQL Server
Latest post by on 23 Feb 2017 at 4:40am

Toad Data Point VS Toad for SQL Server

Expand content
Hello, I am looking for a tool that i can manage my SQL Server easily. I can see that there is 2 tools that look the same: 1) Toad for Data Point 2)Toad for SQL Server What are you reccomnded...

Hello,

I am looking for a tool that i can manage my SQL Server easily.

I can see that there is 2 tools that look the same:

1) Toad for Data Point

2)Toad for SQL Server

What are you reccomnded?

And what are the diffrences between Toad Data Point and Toad for SQL Server?

thanks in advance

314 1 / Create an account to join the discussion.
costabas
Follow / 25 Nov 2016 at 8:45pm / Toad for SQL Server
Latest post by on 18 Feb 2017 at 12:31am

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

Unanswered 513 2 / Create an account to join the discussion.
suhaib
Follow / 22 Nov 2016 at 2:39am / Toad for SQL Server
Latest post by on 26 Jan 2017 at 6:17pm

when Toad for MS-SQL log reader will support SQL 2016?

Expand content
Using toad for MS-SQL v6.6 and it fail to read DB log file.

Using toad for MS-SQL v6.6 and it fail to read DB log file.

Unanswered 483 2 / Create an account to join the discussion.
Nate.Gaffaney
Follow / 23 Jan 2017 at 9:42pm / Toad for SQL Server

Toad World feedback

Expand content
Hello, My name is Nate Gaffaney and I’m part of the user experience team at Quest Software. Quest Software provides Toad software and the Toad World web site. We’re currently learning how...

Hello,

My name is Nate Gaffaney and I’m part of the user experience team at Quest Software. Quest Software provides Toad software and the Toad World web site.

We’re currently learning how to make Toad World better from the people who use it, which is why I am posting to this forum. Your feedback is important and will help us make the site better.

We have a few open slots for a phone conference on Thursday or Friday this week if you have 30 to 60 minutes of time. We would appreciate it!

There will also be other opportunities for providing feedback, including a survey we are planning.

To participate in a phone conference to provide us with feedback, please let me know you are interested (Nate.Gaffaney@quest.com), along with the following:

  • Your name
  • The company you work for
  • Your e-mail
  • Your time zone

I look forward to hearing from you!

Best Regards,

Nate Gaffaney

Nate.Gaffaney@quest.com

185 0 / Create an account to join the discussion.
wchavari.kacyumara
Follow / 17 Jan 2017 at 4:29pm / Toad for SQL Server
Latest post by on 19 Jan 2017 at 9:43am

Problems starting the program

Expand content
. This is version 6.6 of TOAD FOR SQL SERVER (Freeware): System.ArgumentException Os controles criados em um thread não podem ser controles pai de um controle em um outro thread. Nome do parâmetro...

.
This is version 6.6 of TOAD FOR SQL SERVER (Freeware):

System.ArgumentException
Os controles criados em um thread não podem ser controles pai de um controle em um outro thread.
Nome do parâmetro: value
Stack 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.ArgumentException
Os 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)


377 5 / Create an account to join the discussion.