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!

438 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

539 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.

850 0 / 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 78 2 / Create an account to join the discussion.
Gavin.Sinclair
Follow / 30 Jun 2016 at 11:56am / Toad for SQL Server
Latest post by on 19 May 2017 at 9:14am

Can I Disable "File Modified" Warning?

Expand content
Is there any way to stop Toad checking the version of a SQL file, with the version that you have open within the editor? I've looked, but I can't find any setting that would do this for me. (Toad...

Is there any way to stop Toad checking the version of a SQL file, with the version that you have open within the editor?   I've looked, but I can't find any setting that would do this for me.  (Toad for SQL Server 6.7).

I am saving sql files from Toad into Microsoft OneDrive.  One of the consequences of this (it's a known issue with OneDrive) is that every time OneDrive automatically syncs files, Toad believes that the file has been externally modified by another application/user.    So the next time it checks you receive a "File Modified" popup warning;

[Your File.sql] has been modified on disk.  Do you want to reload the file?

Of course, if you respond Yes to this, you revert back to the file exactly as it was when you last saved it, and you lose all edits since then.  So it's an annoying, constant nag that you have to keep replying No to.


The frustrating thing about this is that the file hasn't been modified by OneDrive at all.  It is exactly the same, with the timestamp untouched.  But something it's doing when syncing to the OneDrive cloud convinces Toad that the file has changed.

Unanswered 1264 3 / Create an account to join the discussion.
jhetrick
Follow / 4 May 2017 at 5:51pm / Toad for SQL Server
Latest post by on 5 May 2017 at 5:30pm

Fragmented Indexes Error Code 13

Expand content
Hi I have three SQL 2008 R2 Servers each being monitored with Spotlight Enterprise 11.7.1 and I am seeing this error only on one of the servers and I was wondering if this was a bug or if there was something...

Hi I have three SQL 2008 R2 Servers each being monitored with Spotlight Enterprise 11.7.1 and I am seeing this error only on one of the servers and I was wondering if this was a bug or if there was something not configured correctly? 

The popup box has the following Collection by Fragmentation Index Failed: The SQL query has been executing for longer than it's timeout limit but has not timed out.  It maybe hung.  No alarms currently raised.

When I go into the database and select the fragmented indexes this is the error I receive:

Fragmented Indexes
Component: Fragmented Indexes
The following error occurred while collecting data
The SQL query has been executing for longer than its timeout limit but has not timed out. It may be hung. [Error Code: 13].
Table: Fragmentation by Index
Occurred: 5/4/2017 10:22:30 AM

I appreciate any help or direction as I am new to Spotlight and I have walked through all 3 servers and all are configured the same for Spotlight.

Thank you!

104 3 / Create an account to join the discussion.
francois.guertin
Follow / 27 Apr 2017 at 4:17pm / Toad for SQL Server
Latest post by on 4 May 2017 at 9:30am

Database compare does not work on SQL Server 2016

Expand content
Hi, The database compare crashes when using SQL Server 2016. It crashes with a stack trace and the message starts with: Problem with load Permissions I have the lastest beta of 6.8 and this is still...

Hi,

The database compare crashes when using SQL Server 2016. It crashes with a stack trace and the message starts with: Problem with load Permissions

I have the lastest beta of 6.8 and this is still not fixed. Will it be fixed in the next beta version?

Thanks

85 1 / Create an account to join the discussion.
costabas
Follow / 3 May 2017 at 11:36pm / Toad for SQL Server

Loading a file into a varbinary(max) field in a grid doesn't ...

Expand content
Hi: I am using Toad 6.7.0.176 Steps to reproduce: 1. I have an editor open with a script where one of the statements is: drop table schema.TableName. I highlighted schema.TableName and I pressed...

Hi:

I am using Toad 6.7.0.176 

Steps to reproduce:

1. I have an editor open with a script where one of the statements is: drop table schema.TableName. I highlighted schema.TableName and I pressed Shift+F4. Toad opened the table details on another tab - I set it that way.

2. I went to the table details Data tab, I enabled the editing in the table and I selected the only row in the table. I clicked on the varbinary(max) field and Toad displayed a dropdown with several tabs: Image, Hex, Ascii, Utf-16, Utf8 and Pdf. The Image and Pdf tabs are disabled.

3. With the Hex tab selected I clicked on the Open button (with the yellow icon), I selected a sql file, the open file dialog disappeared, then I clicked the button with the green check mark. The dropdown disappeared. I clicked the check mark icon in the grid bottom toolbar to save the row.

4. In a different editor tab, I ran a query select * from schema.TableName where varbinaryMaxField is null and it returned the row I selected. This confirmed that toad didn't load the file and it didn't save anything in the varbinary(max) field.

Could you please fix this issue, in case it hasn't already been fixed?

Thanks,

64 0 / Create an account to join the discussion.
costabas
Follow / 25 Nov 2016 at 8:45pm / Toad for SQL Server
Latest post by on 3 May 2017 at 11:13am

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 637 4 / Create an account to join the discussion.
LangLang
Follow / 28 Apr 2017 at 9:06pm / Toad for SQL Server
Latest post by on 2 May 2017 at 1:42pm

Need to open .mdf file

Expand content
Hello everyone, Could anyone out there help me? How to open .mdf format file without SQL Server?

Hello everyone,

Could anyone out there help me? How to open .mdf format file without SQL Server?

Answered 108 1 / Create an account to join the discussion.
s.bertolotti
Follow / 13 Jun 2016 at 4:47pm / Toad for SQL Server
Latest post by on 25 Apr 2017 at 1:03pm

Toad for SQL Server 6.7.0.176 - Problem with row count

Expand content
I attach a screenshot for details : As you can see I execute a simple - select count (*) from TABLE_NAME. The results show me the row counts equal to 6932. If you see in the object Explorer,...

I attach a screenshot for details :

As you can see I execute a simple - select count (*) from TABLE_NAME.

The results show me the row counts equal to 6932.

If you see in the object Explorer, same table, row counts is equal to 6695.

What's the real value of row counts ?

From my point of view the first, 6932, but this is very strange or I never set correctly some parameters.

I stay tune for your consideration.

Best regards,

Sergio

1748 9 / Create an account to join the discussion.
dwayne.sawyer
Follow / 8 Mar 2016 at 9:29pm / Toad for SQL Server
Latest post by on 25 Apr 2017 at 9:51am

Does Toad for SQL Server not support AlwaysOn functionality

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

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.

Thanks

Dwayne

Unanswered 2002 3 / Create an account to join the discussion.
s.bertolotti
Follow / 11 Nov 2012 at 8:07pm / Toad for SQL Server
Latest post by on 24 Apr 2017 at 2:53pm

TOAD 5.8 problem with Database Diagram

Expand content
I work with Database Diagram of the last version 5.8 of TOAD. I compose my diagram with drag and drop of table of my DB and all is OK. At this point I save it in a file. The diagram that I save is screenshot...
I work with Database Diagram of the last version 5.8 of TOAD.
I compose my diagram with drag and drop of table of my DB and all is OK.
At this point I save it in a file.
The diagram that I save is screenshot AFTER_SAVE.JPG.

At this point I close the diagram designer.
I reopen it ant load my previous save file and with my disappointment I obtain diagram like the screenshot  AFTER_REOPEN.JPG.

Why this ?

Have you some idea ?

At this point I must to reorganize my table to print correctly on my printer.

I stay tune for your answer.

Best regards.

Sergio Bertolotti

after_reopen.jpg

after_save.jpg

8560 17 / Create an account to join the discussion.
s.bertolotti
Follow / 17 Jun 2013 at 5:21pm / Toad for SQL Server
Latest post by on 24 Apr 2017 at 2:32pm

Problem in Storage management of TOAD SS 6.0

Expand content
Last version of TOAD SS 6.0 . See my JPG in attach for details. I select storage management and as you can see there are some DB of size to 0 B. This isn't true. All these DB's have a size...

Last version of TOAD SS 6.0 .

See my JPG in attach for details. I select storage management and as you can see there are some DB of size to 0 B.

This isn't true.

All these DB's have a size of some M bytes.

I use SQL Server 20120 with service pack 1 Developer Edition and Microsoft Windows 8 prof. at 64 bits.

 

I stay tune for your consideration.

 

Best regards.

Sergio Bertolotti

Answered 25928 22 / Create an account to join the discussion.
s.bertolotti
Follow / 23 Jan 2016 at 9:49am / Toad for SQL Server
Latest post by on 24 Apr 2017 at 2:27pm

Error in Data Generator Toad for SQL Server 6.6.0.963

Expand content
Toad for SQL Server 6.6.0.963. Today I try to generate random datas for my table. Table is a simple table. This is the script : CREATE TABLE dbo.Price ( ProductID INT PRIMARY KEY, LastUpdate DATE...

Toad for SQL Server 6.6.0.963.

Today I try to generate random datas for my table.

Table is a simple table.

This is the script :

CREATE TABLE dbo.Price (
    ProductID INT PRIMARY KEY,
    LastUpdate DATE NOT NULL,
    Price SMALLMONEY NULL,
    Qty INT
)

I open TOOLS - DATA GENERATOR, connect my DB and table and I try to pump/generate datas in it.

I attach a screenshot for details :

I obtain a lot of errors on field - PRICE - . Type of it is : Overflow of value.

As you can see price field is of type smallmoney and your tool set maximum and minimum range of data correctly, minimum : -214748.3648 and mximum : 214748.3647.

But if you analize the value in the bottom of the window - preview of  generated data first 1000 rows -  you can see for example, line 4 : 46235357, line 8 : 804436644, etc,etc,.. is not in the range and this generate the problem.

Values generated is 1000 and if I analyze the data I fond a lot of errors.

The same problem is present in the last BETA Toad for SQL Server Beta 6.7.0.112.

Can you correct this problem please ?

Best regards,

Sergio

3055 12 / Create an account to join the discussion.
s.bertolotti
Follow / 10 Aug 2016 at 10:06pm / Toad for SQL Server
Latest post by on 24 Apr 2017 at 2:16pm

GPF when try to debug a stored procedure - Toad for SQL Server 6.7...

Expand content
Last official release of TOAD 6.7.0.176. 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...

Last official release of TOAD 6.7.0.176.

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,

Best regards,

Sergio

2294 18 / Create an account to join the discussion.
david_74271
Follow / 20 Jun 2016 at 8:36am / Toad for SQL Server
Latest post by on 24 Apr 2017 at 1:26pm

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.

1788 10 / Create an account to join the discussion.
sraghura
Follow / 18 Dec 2013 at 3:44pm / Toad for SQL Server
Latest post by on 18 Apr 2017 at 7:51pm

Vertical stacking of result sets (no tabs) when running multiple ...

Expand content
Is it possible in toad-for-sql-serverto display results from more than one query one below the other when multiple queries are selected and run. SQL Server Mgmt Studio does this and this makes for easy...

Is it possible in toad-for-sql-serverto display results from more than one query one below the other when multiple queries are selected and run. SQL Server Mgmt Studio does this and this makes for easy comparison between results from two different queries/tables. In toad-for-sql-server I can tab between multiple result sets but only view one result set at a time. Or I can have results from multiple queries in the same result set and get a sort of index column at the left which tells me the no. of rows returned from each query and I can then choose one of them to see in the result set. Either way I cannot view more than one result set or multiple results in a result set at the same time. This is insanely useful when successively building more complex queries.

8503 14 / Create an account to join the discussion.
costabas
Follow / 22 Mar 2017 at 5:53pm / Toad for SQL Server
Latest post by on 14 Apr 2017 at 5:42pm

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

206 4 / Create an account to join the discussion.
SCline45
Follow / 12 Apr 2017 at 9:12pm / Toad for SQL Server
Latest post by on 13 Apr 2017 at 2:46pm

Database consistency errors reported by DBCC CHECKB

Expand content
Hello. Please help me to solve my problem. Is there a way to fix SQL Server database error message: Database consistency errors reported by DBCC CHECKB Any help you anyone can provide would be gre...

Hello.

Please help me to solve my problem. Is there a way to fix SQL Server database error message: Database consistency errors reported by DBCC CHECKB

Any help you anyone can provide would be great

Answered 136 1 / Create an account to join the discussion.