Toad for SQL Server Beta Program Community

Toad for SQL Server - Beta Forum

s.bertolotti
Follow / 17 Jan 2018 at 10:55am / Toad for SQL Server Beta Program
Latest post by on 6 Feb 2018 at 8:41am

Strange error in Toad for SQL Server Beta 6.9.0.126 (64 bit)

Expand content
I notice a strange error in Toad for SQL Server Beta 6.9.0.126 (64 bit). I connect to a DB. I select a table and via right click I select - generate sql - insert statement - . At this point I insert...

I notice a strange error in Toad for SQL Server Beta 6.9.0.126 (64 bit).

I connect to a DB. I select a table and via right click I select - generate sql - insert statement - .

At this point I insert in a new editor's window the sql generated by TOAD.

T-SQL parser tell me there is an error.

I attach a screenshot to show the problem :

There isn't any error in this sql insert statement. If I try to execute all is OK.

For every tables that I use to generate an insert sql I obtain the same error in the same position, at the end of the first line before '(' .

I sty tune for your consideration,

Best regards,

Sergio

130 3 / Create an account to join the discussion.
michael
Follow / 4 Jan 2018 at 3:20am / Toad for SQL Server Beta Program
Latest post by on 17 Jan 2018 at 3:21pm

Toad for SQL Server Beta build 6.9.0.126 is now available

Expand content
Hello, Toad for SQL Server Beta build 6.9.0.126 is now available Installer is available on the Community website: https://www.toadworld.com/products/toad-for-sql-server/toad_for_sql_server_beta_program...

Hello,

Toad for SQL Server Beta build 6.9.0.126 is now available

Installer is available on the Community website:

https://www.toadworld.com/products/toad-for-sql-server/toad_for_sql_server_beta_program/

Bug Fixed:

Summary
 ===================================

improve some performance issues in Object Explorer and Editor

ToadforSQLServer Team

297 8 / Create an account to join the discussion.
kaplan.dani
Follow / 7 Jan 2018 at 6:43pm / Toad for SQL Server Beta Program
Latest post by on 8 Jan 2018 at 9:03am

Generate Create Script doesn't generate constraints

Expand content
I've install the latest beta (126). the upgrade process is still faulty (need to manually uninstall old version, then install new version - already reported that). The new thing I've noticed...

I've install the latest beta (126).

the upgrade process is still faulty (need to manually uninstall old version, then install new version - already reported that).

The new thing I've noticed - the generate create script - 

I've created a table with primary key and 2 foreign keys then I've tried the create script generation - it only create the columns in the script, but not the constraint and PK. 

It used to work in previous versions (I'm almost sure).

85 1 / Create an account to join the discussion.
s.bertolotti

New Toad for SQL Server Beta 6.9.0.126 (64 bit)

Expand content
Hi, today I donwload new beta version of TOAD for SQL Server 6.9 . Can someone publish what's new and what's error/problem fixed in this new beta release ? I stay tune for your answer. ...

Hi,

today I donwload new beta version of TOAD for SQL Server 6.9 .

Can someone publish what's new and what's error/problem fixed in this new beta release ?

I stay tune for your answer.

Best regards,

Sergio

83 0 / Create an account to join the discussion.
s.bertolotti
Follow / 5 Dec 2017 at 7:10am / Toad for SQL Server Beta Program
Latest post by on 21 Dec 2017 at 7:13am

New beta version of TOAD for SQL Server 6.9

Expand content
Dear Michael, last beta version of TOAD for SQL Server 6-9 was expired. When do you plan to release a new beta of TOAD 6.9 ? Best regards, Sergio

Dear Michael,

last beta version of TOAD for SQL Server 6-9 was expired.

When do you plan to release a new beta of TOAD 6.9 ?

Best regards,

Sergio

212 3 / Create an account to join the discussion.
MFeeney
Follow / 7 Feb 2011 at 8:20pm / Toad for SQL Server Beta Program
Latest post by on 6 Dec 2017 at 4:51pm

Setting a cell value to {null}

Expand content
When editing in the data tab grid of a table, is there a way to set a cell value to {null} (as in null value, not the string "{null}")? If not, please add this feature to the context menu (right...

When editing in the data tab grid of a table, is there a way to set a cell value
to {null} (as in null value, not the string "{null}")?

If not, please add this feature to the context menu (right-click) of a cell!

Thanks!
Matt

11901 4 / Create an account to join the discussion.
DarrenM
Follow / 30 Nov 2017 at 1:00pm / Toad for SQL Server Beta Program

Replace Keyboard Shortcuts - Please add ALT+a for Replace All, ALT...

Expand content
In nearly every other development application that I use if I am using a find and replace I expect to be able to use certain keyboard shortcuts. Open Microsoft Word for Example and Press CTRL+H. Notice...

In nearly every other development application that I use if I am using a find and replace I expect to be able to use certain keyboard shortcuts.

Open Microsoft Word for Example and Press CTRL+H. Notice the buttons across the bottom of the screen?  Notice the keyboard shortcuts assigned to those buttons? 

Now, do the same in SQL Server Management Studio - The dialog looks different, but notice that the hotkeys are the same and if you hover over each button, the control tip text indicates the keyboard shortcut for each option.

They are:

  • Replace - ALT+r
  • Replace All - ALT+a
  • Find - ALT+f  (Or F3)
  • Use Regular Expressions - ALT+e

It's time to bring these same features to the Toad Search and replace.  It would also be appreciated if we could have the CTRL+H keyboard shortcut ALSO map by default to the find and replace dialog just like CTRL+F does currently (I realize that find and replace are the same thing in Toad).

If I had to choose only one change from the list above it would be to make the ALT+a (replace all) shortcut work.

Thanks for considering this feature request.

99 0 / Create an account to join the discussion.
DarrenM
Follow / 28 Nov 2017 at 4:41pm / Toad for SQL Server Beta Program
Latest post by on 29 Nov 2017 at 6:42am

Code snippets with variables broken as of Toad 6.8 - still not fixed...

Expand content
Steps to reproduce: Create a code template that includes fillable variables. Add the code template the editor window. Fill in the first variable and press tab to move to the next variable. EXPECTED...

Steps to reproduce:

Create a code template that includes fillable variables.

Add the code template the editor window.

Fill in the first variable and press tab to move to the next variable.

EXPECTED: It should move to the next variable.

ACTUAL: All fields are disabled, cannot use code templates anymore.  Must revert to Toad 6.7

Here is an actual snippet that you may use:

--Region CREATE $TableName$
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name = '$TableName$')
DROP TABLE [$TableName$]

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name = '$TableName$')
CREATE TABLE [$TableName$]
(
--Region Column Definitions
$TableName$ID int identity CONSTRAINT PK_$TableName$ PRIMARY KEY
, $FirstColumnName$ nvarchar(30) NOT NULL
, CreatedBy nvarchar(50) NOT NULL CONSTRAINT DF_$TableName$_CreatedBy DEFAULT(sUser_Name())
, CreatedDate datetime NOT NULL CONSTRAINT DF_$TableName$_CreatedDate DEFAULT(GetDate())
, LastModifiedTimestamp RowVersion
--End Region
--Region Add Foreign Keys here:
--, CONSTRAINT FK_$TableName$_$FirstForeignKeyFieldName$ FOREIGN KEY ( $FirstForeignKeyFieldName$ ) REFERENCES dbo.$ForeignTableName$ ( $ForeignColumnName$ ) ON UPDATE CASCADE ON DELETE NO ACTION
--End Region
)
--Region $TableName$ Descriptions:
--Describe the Table:
--EXEC sys.sp_addextendedproperty @value=N'Custom Table', @level1name=N'$TableName$', @name=N'MS_Description', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE'

--Describe Column(s):
--EXEC sys.sp_addextendedproperty @value=N'Custom Field', @level1name=N'$TableName$', @level2name=N'$FirstColumnName$', @name=N'MS_Description', @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE', @level2type=N'COLUMN'
--End Region
--End Region

105 1 / Create an account to join the discussion.
kaplan.dani
Follow / 6 Nov 2017 at 6:42am / Toad for SQL Server Beta Program
Latest post by on 21 Nov 2017 at 8:33am

new beta version can't automatically uninstall the old versio...

Expand content
It ends with an error (user account already exists) It will work if you un-install the 6.8 beta and then install.

It ends with an error (user account already exists)

It will work if you un-install the 6.8 beta and then install. 

168 2 / Create an account to join the discussion.
michael
Follow / 30 Oct 2017 at 7:40am / Toad for SQL Server Beta Program
Latest post by on 1 Nov 2017 at 6:31pm

Toad For SQL Server 6.9.0.70 Beta have been post.

Expand content
Hello , Toad For SQL Server 6.9.0.70 Beta have been post. Download Link: www.toadworld.com/.../ Thanks, TSS Team

Hello ,

Toad For SQL Server 6.9.0.70 Beta have been post.

Download Link:  www.toadworld.com/.../

Thanks,

TSS Team

598 7 / Create an account to join the discussion.
brett.stutzman
Follow / 13 Sep 2017 at 12:38pm / Toad for SQL Server Beta Program
Latest post by on 25 Oct 2017 at 10:13am

When will a new release version be available for Beta testing? The...

Expand content
When will a new release version be available for Beta testing? The last one expired in mid August 2017. I have been watching but have not seen any posts for the next beta version

When will a new release version be available for Beta testing?  The last one expired in mid August 2017.  I have been watching but have not seen any posts for the next beta version

351 3 / Create an account to join the discussion.
sureshrm
Follow / 12 May 2017 at 6:17pm / Toad for SQL Server Beta Program
Latest post by on 17 Oct 2017 at 2:22am

Save Dialog Box Issue

Expand content
Version : Toad For SQL Server 6.8.0.57 (64 bit) When selecting the Save Icon from the Toolbar to save the Sql Script from the Editor, it opens up the save dialog box, but the place to enter the file...

Version : Toad For SQL Server 6.8.0.57 (64 bit)

When selecting the Save Icon from the Toolbar to save the Sql Script from the Editor, it opens up the save dialog box, but the place to enter the file name is messed up, and the save button not working.

attaching the screen shot of the issue.

472 3 / Create an account to join the discussion.
francois.guertin
Follow / 26 Oct 2016 at 1:19pm / Toad for SQL Server Beta Program
Latest post by on 13 Sep 2017 at 10:34am

Schema compare crashes when using SQL Server 2016

Expand content
Hi, I am trying to compare two schemas. One of them is on SQL Server 2014 and the other on SQL Server 2016. The program crashes when loading the permissions from the 2016 schema with the fhe following...

Hi,

I am trying to compare two schemas. One of them is on SQL Server 2014 and the other on SQL Server 2016. The program crashes when loading the permissions from the 2016 schema with the fhe following error:

System.ApplicationException
Not supported permission type 'VWCK' detected

This is using build 6.8.0.249.

Thanks

828 1 / Create an account to join the discussion.
mwebster_37527
Follow / 30 Oct 2016 at 6:35pm / Toad for SQL Server Beta Program
Latest post by on 13 Sep 2017 at 10:31am

Save SQL file using windows explorer Save button does not work

Expand content
Hello, Using Windows 10 and 6.8.0301 (64 Bit). If I try to save a SQL file using CTRL-S or the save icon, then provide a name and then click on the Save button in the windows explorer window...

Hello,

Using Windows 10 and 6.8.0301 (64 Bit).  

  • If I try to save a SQL file using CTRL-S or the save icon,
  • then provide a name
  • and then click on the Save button in the windows explorer window.  The Save button in windows explorer does not work.  

Pressing enter saves the file with the provided name.  Pressing cancel does cancel the save.

Thanks,

Mike Webster

643 1 / Create an account to join the discussion.
Rich J.
Follow / 30 Mar 2017 at 3:04pm / Toad for SQL Server Beta Program
Latest post by on 13 Sep 2017 at 3:57am

Ability to grab password hash when scripting logins

Expand content
Howdy, All of our SQL Server installations are to support 3rd party (purchased) software. Every vendor has their own implementation, so when I need to copy logins from one server to another (e.g. Prod...

Howdy,

All of our SQL Server installations are to support 3rd party (purchased) software.  Every vendor has their own implementation, so when I need to copy logins from one server to another (e.g. Prod to Test, or vice versa), it's a pain.  If the vendor doesn't use/support Domain logins, I may or may not have access to the login's password.

I've been using a script similar to the one described at http://www.sqlservercentral.com/blogs/sqlstudies/2013/03/25/how-do-i-move-a-sql-login-from-one-server-to-another-without-the-password/ 

It would be nice if Toad could have an option to generate the hash on a login, specifically for copying to another server.

Thanks!
Rich

p.s.  Original message got cut off by the web...hmmm....

314 1 / Create an account to join the discussion.
Rich J.
Follow / 6 Apr 2017 at 4:21pm / Toad for SQL Server Beta Program
Latest post by on 13 Sep 2017 at 2:34am

Export datetime data types to Excel formats as float instead of d...

Expand content
Hi, In 6.8.0.636, I'm exporting a grid to Excel. The grid contains various data types including datetime. When I open the resulting workbook in Excel 2010, the datetime columns are formatted as floats...

Hi,

In 6.8.0.636, I'm exporting a grid to Excel.  The grid contains various data types including datetime.  When I open the resulting workbook in Excel 2010, the datetime columns are formatted as floats.

They are formatted correctly in 6.7.0.176.

Thanks!
Rich

Unanswered 452 3 / Create an account to join the discussion.
msprygada
Follow / 24 May 2017 at 4:10pm / Toad for SQL Server Beta Program
Latest post by on 13 Sep 2017 at 2:30am

Cannot import Excel file in import to database wizard

Expand content
When I try to use the import wizard (Toad Beta 6.8.0.57 64 bit) to import an Excel file to a new table I get a "Please enter password" dialog. I can open the file with Excel no problems as it...

When I try to use the import wizard (Toad Beta 6.8.0.57 64 bit) to import an Excel file to a new table I get a "Please enter password" dialog. I can open the file with Excel no problems as it is not password protected or even open on my PC.

I click OK without entering a password (because the file is not password protected) and I get this:

So I tried importing the same Excel file with Toad 6.7.0.176 and I get this screen without the "Please enter password" dialog box:

So I had to save as the Excel file to CSV and it then imported just fine.

614 3 / Create an account to join the discussion.
s.bertolotti
Follow / 28 Apr 2017 at 7:37pm / Toad for SQL Server Beta Program
Latest post by on 12 Sep 2017 at 10:14am

GPF with Log Reader

Expand content
Last Toad for SQL Server Beta 6.8.0.57 (64 bit). I conncet to a DB and select - TOOLS - ADMINISTER - LOG Reader. At this point I obtain a GPF. See screenshot in attach for detail : I stay tune...

Last Toad for SQL Server Beta 6.8.0.57 (64 bit).

I conncet to a DB and select - TOOLS - ADMINISTER - LOG Reader.

At this point I obtain a GPF. See screenshot in attach for detail :

I stay tune for your consideration.

Best regards,

Sergio

365 2 / Create an account to join the discussion.
babe2546
Follow / 30 Apr 2017 at 3:36pm / Toad for SQL Server Beta Program
Latest post by on 12 Sep 2017 at 7:45am

Log Reader could not start

Expand content
I click Tools, Adminster, Log Reader, but I got an error reading: System.IO.FileNotFoundException Could not load file or assembly 'Windows.Utils, Version=3.1.1.3, Culture=neutral, PublicKeyToken...

I click Tools, Adminster, Log Reader, but I got an error reading:

System.IO.FileNotFoundException
Could not load file or assembly 'Windows.Utils, Version=3.1.1.3, Culture=neutral, PublicKeyToken=c862883b2ae69822' or one of its dependencies. The system cannot find the file specified.
Stack Trace:
   at Quest.LogReader.SqlServer.Settings.WriteLog(Exception ex, Boolean showExcepion)
   at Quest.LogReader.SqlServer.UI.MainContainerControl.executeAction(ActionCode action)
   at Quest.LogReader.SqlServer.UI.MainContainerControl.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

My PC runs on Windows 10 64Bit

Please help, thank you.

325 1 / Create an account to join the discussion.
Rich J.
Follow / 3 May 2017 at 4:29pm / Toad for SQL Server Beta Program
Latest post by on 12 Sep 2017 at 7:41am

How to prevent Web Browser from launching on startup?

Expand content
Howdy, In Toad for SQL Server Beta 6.8.0.57, the Web Browser window always appears on startup. I've searched the options, but I can't find how to prevent it from opening, like my 6.7 GA. Thoughts...

Howdy,

In Toad for SQL Server Beta 6.8.0.57, the Web Browser window always appears on startup.  I've searched the options, but I can't find how to prevent it from opening, like my 6.7 GA.

Thoughts?

TIA!
Rich

447 2 / Create an account to join the discussion.