Toad for SQL Server - Beta Forum - Toad for SQL Server Beta Program - Toad World

Toad for SQL Server Beta Program Community

Toad for SQL Server - Beta Forum

s.bertolotti

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

20 0 / Create an account to join the discussion.
Damien B.

x64 version of the beta ?

Expand content
Hello, Can you post an x64 version of the beta ? I need it to export 1,4 million rows to an XLSX document but it crash due to an out of memory exception. On the previous beta build (.451) there was...

Hello,

Can you post an x64 version of the beta ?

I need it to export 1,4 million rows to an XLSX document but it crash due to an out of memory exception.

On the previous beta build (.451) there was an x64 version that allowed me that export.

Regards

25 0 / Create an account to join the discussion.
sonicfray

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

Expand content
in the latest beta, the view to show all results is still not as useful as SSMS. The all results stacks the results on top of each other and there is no independent scroll bar for each result like in SSMS...

in the latest beta, the view to show all results is still not as useful as SSMS.  The all results stacks the results on top of each other and there is no independent scroll bar for each result like in SSMS.  The current implementation is not useful at all and the functionality of SSMS is superior in this respect.  For the use case of doing multiple queries simultaneously, one doesn't want the results to be shown in different tabs.  Often one needs to look at the results all at the same time since the information is spread accross different queries.  Please make it like SSMS for the independent scrolling windows embedded within the result set for each query result.  This is the only thing that I don't like about TOAD for SQL Server.

See reference issue posted here 

32 0 / Create an account to join the discussion.
Kelly.Chen
Follow / 10 Mar 2017 at 7:08am / Toad for SQL Server Beta Program
Latest post by on 15 Apr 2017 at 4:02pm

Toad for SQL Server Beta build 6.8.0.636 has been posted and is ready...

Expand content
Toad for SQL Server Beta build 6.8.0.636 has been posted and is ready for download. We are welcome any comments or suggestions. Download link: https://www.toadworld.com/products/toad-for-sql-server...

Toad for SQL Server Beta build 6.8.0.636 has been posted and is ready for download. We are welcome any comments or suggestions.

Download link:

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

Fixed Issue:

ID                     Summary
=========      ===================================
TSS-1395        Press SHIFT+F4 to show Object Details function.
TSS-1391        Code completion work for union present

138 1 / Create an account to join the discussion.
joe.gollakner
Follow / 21 Mar 2017 at 6:51pm / Toad for SQL Server Beta Program
Latest post by on 13 Apr 2017 at 8:10pm

Release notes for Beta 6.8.0.636

Expand content
I recently downloaded the latest Beta for TOAD for SQL Server and when I went to Help --> Release Notes, the page took me to the Release Notes for version 6.7. Is there a way to get the cumulative Release...

I recently downloaded the latest Beta for TOAD for SQL Server and when I went to Help --> Release Notes, the page took me to the Release Notes for version 6.7.  Is there a way to get the cumulative Release notes for version 6.8?

253 10 / Create an account to join the discussion.
Rich J.

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 53 0 / Create an account to join the discussion.
DarrenM
Follow / 30 Mar 2017 at 6:07pm / Toad for SQL Server Beta Program
Latest post by on 31 Mar 2017 at 8:20am

Code Snippet Templates not working in Toad for SQL Server Beta 6.8...

Expand content
When I add a code snippet containing variables to the SQL Editor, my cursor defaults as it always did to the first variable field, however on keying the variable and pressing the TAB key, instead of it...

When I add a code snippet containing variables to the SQL Editor, my cursor defaults as it always did to the first variable field, however on keying the variable and pressing the TAB key, instead of it moving on to the next variable all input fields immediately disappear, and none of the other instances of the same variable are updated.

Here's how the snippet appears in 6.7:

Here's how that same snippet appears in 6.8 Beta:

Notice that the input fields are no longer highlighted.  If I type over the first variable nothing happens, it doesn't update.

If you want to try it with my actual snippet, create one with this definition:

--Region CREATE $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
, CreatedDate datetime NOT NULL CONSTRAINT DF_$TableName$_CreatedDate DEFAULT(GetDate())
, CreatedBy nvarchar(50) NULL
, LastUpdatedTimestamp rowversion
--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

89 1 / Create an account to join the discussion.
Rich J.
Follow / 30 Mar 2017 at 3:04pm / Toad for SQL Server Beta Program

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

52 0 / Create an account to join the discussion.
francois.guertin
Follow / 13 Mar 2017 at 11:19am / Toad for SQL Server Beta Program
Latest post by on 14 Mar 2017 at 3:42am

Schema compare crashes on SQL Server 2016

Expand content
Hi, When trying to do a schema compare on a server using SQL Server 2016 it crashes. Something to do with permissions. Here is the stack trace: System.ApplicationException Problem with load Permissions...

Hi,

When trying to do a schema compare on a server using SQL Server 2016 it crashes. Something to do with permissions. Here is the stack trace:

System.ApplicationException
Problem with load Permissions
Stack Trace:
at Quest.Schema.Common.ModelLoad.ModelLoader`6.Run(ICallBack callback)
at Quest.Schema.Common.ModelLoad.ModelLoadManager`7.Loader.LoadModel(ICallBack callback)
at Quest.Schema.Common.ModelLoad.ModelLoadManager`7.CreateInstance(ICallBack callback, FriendlyName friendlyName, SchemaSnapshot[] snapshots, SingleModel`3 model, OptionsStorage options)
at Quest.Schema.MSSQL.ModelLoad.ModelLoadServiceMSSQL.Create(ICallBack callback, FriendlyName friendlyName, SchemaSnapshot[] snapshots, ISingleModel model, OptionsStorage options)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.LoadModelFromSnapshot[T](ICallBack callback, SourceLoader`1 source)
at Quest.Schema.Common.Modules.SourcesLoader.SourcesLoaderModule.SourceLoader`1.Run(ICallBack callback)

System.ApplicationException
Not supported permission type 'VWCM' detected
Stack Trace:
at Quest.Schema.MSSQL.Interfaces.Utils.Converters.GetDatabasePermission(String value)
at Quest.Shared.Memorizing.ObjectCache`2.GetValue(TKey key)
at Quest.Schema.MSSQL.Interfaces.Utils.Converters.GetDatabasePermissionNameFromServerValue(String value)
at Quest.Schema.MSSQL.ModelLoad.LoadModel.Declarations.Process.NameLoaders.NameDatabasePermissionActionLoader.GetName(String value)
at Quest.Shared.Memorizing.ObjectCache`2.GetValue(TKey key)
at Quest.Schema.MSSQL.ModelLoad.LoadModel.Declarations.Process.NameLoaders.NameDatabasePermissionActionLoader.GetName(DataReader`1 reader, LoadContext context, ScriptInfo info, ParentSearchContext parentContext)
at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderWithExtension`5.LoadObject(DataReader`1 reader, TLoadContext context, ParentSearchContext searchContext)
at Quest.Schema.Common.ModelLoad.Declarations.ObjectLoaders.CommonObjectLoaderBase`5.LoadObjects(ICanceling cancel, DataReader`1 reader, TLoadContext context)
at Quest.Schema.Common.ModelLoad.Declarations.ScriptLoaders.ScriptLoader`5.LoadObjects(ICanceling cancel, DataReader`1 reader, TLoadContext context)
at Quest.Schema.Common.ModelLoad.ModelLoader`6.Run(ICallBack callback)

Thanks

102 1 / Create an account to join the discussion.
KDF-LA
Follow / 8 Mar 2017 at 7:10pm / Toad for SQL Server Beta Program
Latest post by on 10 Mar 2017 at 2:13pm

CREATE OR ALTER syntax is flagged as error within TOAD

Expand content
Toad (6.8.0.451) considers the recently added "create of alter" syntax to be an error. For example: CREATE OR ALTER PROCEDURE dbo.storeProc (...) is highlighted as being incorrect, however...

Toad (6.8.0.451) considers the recently added "create of alter" syntax to be an error. 

For example:

CREATE OR ALTER PROCEDURE  dbo.storeProc (...)

is highlighted as being incorrect, however is compiles fine.

Ken

112 1 / Create an account to join the discussion.
sureshrm
Follow / 9 Mar 2017 at 8:46pm / Toad for SQL Server Beta Program
Latest post by on 10 Mar 2017 at 1:13am

Request for Enhancements - Group Tabs Per Connection

Expand content
Request for Enhancements. Built Version ToadForSqlServer_Beta_6.8.0.451_exe Group Tabs Per Connection Topic. I find that you have enhancement requests for Group Tabs Per Connection in Data Point...

Request for Enhancements.

Built Version ToadForSqlServer_Beta_6.8.0.451_exe

Group Tabs Per Connection Topic.

I find that you have enhancement requests for Group Tabs Per Connection in Data Point.

Can you please add this feature to Toad for SQL Server.

Thanks

 

99 1 / Create an account to join the discussion.
Damien B.

Beta 6.8.0.451 expired

Expand content
Hello, Beta 6.8.0.451 has expired. Could you please post a new build ? Regards

Hello,

Beta 6.8.0.451 has expired.

Could you please post a new build ?

Regards

91 0 / Create an account to join the discussion.
sureshrm
Follow / 2 Mar 2017 at 11:07pm / Toad for SQL Server Beta Program
Latest post by on 3 Mar 2017 at 8:03am

Issue with Session Browser

Expand content
When Session Browser is invoked from the Toolbar, It opens up and the data is refreshed, but when I try to refresh, it is not refreshing, sometime it takes long time to refresh or do not refresh. ...

When Session Browser is invoked from the Toolbar, It opens up and the data is refreshed, but

when I try to refresh, it is not refreshing, sometime it takes long time to refresh or do not refresh.

Thanks

100 1 / Create an account to join the discussion.
Guest
Follow / 28 Apr 2010 at 4:24pm / Toad for SQL Server Beta Program
Latest post by on 22 Feb 2017 at 6:53pm

Shortcut key for closing results set

Expand content
Is there a shortcut key for closing the results set? When I am working on my code, I want the most real estate that I can get. I can click on the X on the top right of the results window to close it until...

Is there a shortcut key for closing the results set? When I am working on my
code, I want the most real estate that I can get. I can click on the X on the
top right of the results window to close it until I run the code again but a
short cut key would be real handy.

Matt

5904 8 / Create an account to join the discussion.
s.bertolotti
Follow / 13 Jan 2017 at 9:21am / Toad for SQL Server Beta Program
Latest post by on 23 Jan 2017 at 6:43am

GPF in Toad for SQL Server Beta 6.8.0.451 (64 bit)

Expand content
Connect to a DB. I select - MANAGEMENT - MAINTENANCE PLAN - and double click on a plan of backup a DB. At this point appear dialog to - Alter Maintenance plan - . i select task and - right click...

Connect to a DB.

I select - MANAGEMENT - MAINTENANCE PLAN - and double click on a plan of backup a DB.

At this point appear dialog to - Alter Maintenance plan - .

i select task and - right click on it do edit.. At this point appear a GPF and I can't modify/edit the plan.

I attach a screenshot to show the problem :

I stay tune for your consideration.

Best regards,

Sergio

163 1 / Create an account to join the discussion.
s.bertolotti
Follow / 10 Jan 2017 at 11:48am / Toad for SQL Server Beta Program
Latest post by on 12 Jan 2017 at 1:09am

Release Notes of new beta of TOAD SS 6.8

Expand content
Dear Kelly, Vincent or Skila can someone of Quest's developer publish the list of the fixes/improvements of the new beta of TOAD SS 6.8.0.451 ? I stay tune for your answer. Best regards, S...

Dear Kelly, Vincent or Skila

can someone of Quest's developer publish the list of the fixes/improvements of the new beta of TOAD SS 6.8.0.451 ?

I stay tune for your answer.

Best regards,

Sergio

211 3 / Create an account to join the discussion.
s.bertolotti
Follow / 5 Jan 2017 at 5:41pm / Toad for SQL Server Beta Program
Latest post by on 6 Jan 2017 at 8:22am

GPF in Toad for SQL Server Beta 6.8.0.451 (64 bit)

Expand content
I connect to a DB. I select - TOOLS - ADMINISTER - JOB MANAGER - at this point appear a GPF. I attach a screenshot of the message. I stay tune for your consideration. Best regards, Sergi...

I connect to a DB.

I select - TOOLS - ADMINISTER - JOB MANAGER - at this point appear a GPF.

I attach a screenshot of the message.

I stay tune for your consideration.

Best regards,

Sergio

151 2 / Create an account to join the discussion.
Kelly.Chen
Follow / 5 Jan 2017 at 6:48am / Toad for SQL Server Beta Program
Latest post by on 5 Jan 2017 at 11:08am

Toad for SQL Server Beta build 6.8.0.451 has been posted and is ready...

Expand content
Hello, Toad for SQL Server Beta build 6.8.0.451 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have.

Hello,

Toad for SQL Server Beta build 6.8.0.451 has been posted and is ready for download. Please download it from the beta page and post any comments or suggestions that you may have.

154 1 / Create an account to join the discussion.
s.bertolotti
Follow / 4 Jan 2017 at 10:46am / Toad for SQL Server Beta Program
Latest post by on 4 Jan 2017 at 1:57pm

New beta version of TOAD SS 6.8

Expand content
When do you plan to release a new beta version of TOAD for SQL Server ? Best regards, Sergio

When do you plan to release a new beta version of TOAD for SQL Server ?

Best regards,

Sergio

209 2 / Create an account to join the discussion.
miwebster
Follow / 21 Nov 2016 at 1:09pm / Toad for SQL Server Beta Program
Latest post by on 27 Dec 2016 at 6:49am

Code completion does not work if a union is present

Expand content
If I have the following code: select id from table1 UNION select id from table2 Code complete will not work for table1. Adding ", " after "select id" in the first line brings...

If I have the following code: 

select id from table1

UNION

select id from table2

Code complete will not work for table1.  Adding ", " after "select id" in the first line brings up the list of tables.  It should show a list of columns in tabe 1.  This does work for table2.

Thanks,

Mike Webster

246 2 / Create an account to join the discussion.