Toad for SQL Server Beta Program Community

Toad for SQL Server - Beta Forum

dauduong
Follow / 10 Apr 2018 at 12:59pm / Toad for SQL Server Beta Program
Latest post by on 18 Jul 2018 at 7:40am

OPENJSON(JSON_QUERY( Syntax Error

Expand content
cross apply openjson(json_query ********************************************************************** Exception Information ********************************************************************** Exception...

cross apply openjson(json_query

**********************************************************************
Exception Information
**********************************************************************
Exception: System.Xml.XmlException
Message  : 'punctuation' is an unexpected token. Expecting white space. Line 102, position 63.
Stack Trace:
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.ParseAttributes()
   at System.Xml.XmlTextReaderImpl.ParseElement()
   at System.Xml.XmlTextReaderImpl.ParseElementContent()
   at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
   at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at System.Xml.XmlDocument.LoadXml(String xml)
   at Quest.QP5.Piece.ParseInfo(ParseInfoFlag flags)
   at Quest.Toad.CodeInsight.BaseDialect.ChunkParseInfoToTokenList(IParsable chunk)
   at Quest.Toad.CodeInsight.BaseDialect.ObjectAtCursor(IConnection connection, IParserChunk chunk, Int32 offset, String defaultSchema, Boolean filtering)
   at Quest.Toad.Editor.EditorControl.GetTrlAtCursor()
   at Quest.Toad.Editor.EditorForm.RefreshTrlMenuBackground()

**********************************************************************
NOTE:  We are eliminating automatic support case creation by email.  Before sending your Support Bundle, ensure your subject line includes an opened CaseID:### or a Service Request ID:###.  Without the CaseID or Service Request ID your Support Bundle request will be declined.

The quickest way to open a new service request is through our online Support Portal support.quest.com/Manage-Service-Request.

You can also contact Support for assistance to create a new case, please visit support.quest.com/.../contact-technical-support.  Post case creation you will continue to have all communication options available including email, phone, or through the Support Portal to manage the lifecycle of your case.


**********************************************************************
Support Bundle: Toad for SQL Server 6.9.0.225 Beta Version (64 bit)
4/10/2018 9:11:23 PM
**********************************************************************

**********************************************************************
System Information
**********************************************************************
Operating System
  Microsoft Windows 10 Pro 10.0.16299 AMD64
  Manufacturer: Microsoft Corporation
  Computer Name: DESKTOP-C7NIV02
  Windows Directory: C:\WINDOWS

Computer System
  Computer Manufacturer Name: Microsoft Corporation
  Computer Model: Surface Pro
  System Type: x64-based PC
  Total Physical Memory: 16,700,484 KB
  Domain: WORKGROUP
  User Name: DESKTOP-C7NIV02\datau

System Processor
  Manufacturer: GenuineIntel
  Computer Processor: Intel64 Family 6 Model 142 Stepping 9
  CPU Speed: 2.496 GHz
  L2 Cache Size: 1 KB

System Bios
  BIOS: 233.2110.770
  BIOS Version: MSFT   - 0

System Time Zone
  Time Zone: (UTC+10:00) Canberra, Melbourne, Sydney

Video Controller
  Name: Intel(R) Iris(TM) Plus Graphics 640
  Processor: Intel(R) Iris(TM) Graphics Family
  Mode: 2736 x 1824 x 4294967296 colors
  Video Ram: 1,048,576 KB
  PNP Device ID: PCI\VEN_8086&DEV_5926&SUBSYS_00261414&REV_06\3&11583659&0&10
  Status: OK

Environment Variables
  SystemDrive = C:
  ProgramFiles(x86) = C:\Program Files (x86)
  ProgramW6432 = C:\Program Files
  ChocolateyInstall = C:\ProgramData\chocolatey
  PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 142 Stepping 9, GenuineIntel
  TMP = C:\Users\datau\AppData\Local\Temp
  PROCESSOR_ARCHITECTURE = AMD64
  Path = C:\Program Files\Docker\Docker\Resources\bin;C:\ProgramData\Anaconda3;C:\ProgramData\Anaconda3\Library\mingw-w64\bin;C:\ProgramData\Anaconda3\Library\usr\bin;C:\ProgramData\Anaconda3\Library\bin;C:\ProgramData\Anaconda3\Scripts;C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Microsoft MPI\Bin\;C:\ProgramData\Boxstarter;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\ProgramData\chocolatey\bin;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\;C:\Program Files\Git\cmd;C:\Program Files\nodejs\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Common Files\Patricia;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files\JSONEdit;C:\Users\datau\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Microsoft VS Code\bin;C:\Users\datau\AppData\Roaming\npm;C:\Users\datau\AppData\Roaming\Dashlane\5.7.0.16178\bin\Firefox_Extension\{442718d9-475e-452a-b3e1-fb1ee16b8e9f}\components;C:\Users\datau\AppData\Roaming\Dashlane\5.7.0.16178\ucrt;C:\Users\datau\AppData\Local\GitHubDesktop\bin;C:\Program Files\SQL Operations Studio\bin;C:\Users\datau\AppData\Roaming\Dashlane\5.10.0.18444\bin\Firefox_Extension\{442718d9-475e-452a-b3e1-fb1ee16b8e9f}\components;C:\Users\datau\AppData\Roaming\Dashlane\5.10.0.18444\ucrt
  USERPROFILE = C:\Users\datau
  PROCESSOR_REVISION = 8e09
  ChocolateyLastPathUpdate = Thu Mar 15 22:15:23 2018
  FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
  FPS_BROWSER_USER_PROFILE_STRING = Default
  LOGONSERVER = \\DESKTOP-C7NIV02
  TEMP = C:\Users\datau\AppData\Local\Temp
  DASHLANE_DLL_DIR = C:\Users\datau\AppData\Roaming\Dashlane\5.10.0.18444\bin\Firefox_Extension\{442718d9-475e-452a-b3e1-fb1ee16b8e9f}\components;C:\Users\datau\AppData\Roaming\Dashlane\5.10.0.18444\ucrt
  USERNAME = datau
  SystemRoot = C:\WINDOWS
  MSMPI_BIN = C:\Program Files\Microsoft MPI\Bin\
  OneDrive = C:\Users\datau\OneDrive
  USERDOMAIN_ROAMINGPROFILE = DESKTOP-C7NIV02
  CommonProgramFiles = C:\Program Files\Common Files
  __COMPAT_LAYER = GdiDPIScaling DPIUnaware
  ProgramData = C:\ProgramData
  HOMEPATH = \Users\datau
  COMPUTERNAME = DESKTOP-C7NIV02
  ALLUSERSPROFILE = C:\ProgramData
  CommonProgramW6432 = C:\Program Files\Common Files
  FSHARPINSTALLDIR = C:\Program Files (x86)\Microsoft SDKs\F#\4.1\Framework\v4.0\
  SESSIONNAME = Console
  ESET_OPTIONS =                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
  HOMEDRIVE = C:
  windir = C:\WINDOWS
  NUMBER_OF_PROCESSORS = 4
  OS = Windows_NT
  ProgramFiles = C:\Program Files
  ComSpec = C:\WINDOWS\system32\cmd.exe
  PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
  JAVA_HOME = C:\Program Files\Java\jre-10
  PSModulePath = C:\Users\datau\Documents\WindowsPowerShell\Modules
  APPDATA = C:\Users\datau\AppData\Roaming
  USERDOMAIN = DESKTOP-C7NIV02
  PROCESSOR_LEVEL = 6
  asl.log = Destination=file
  LOCALAPPDATA = C:\Users\datau\AppData\Local
  CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
  PUBLIC = C:\Users\Public

**********************************************************************
Connection Information
**********************************************************************
Current Connection:
  (local) (DESKTOP-C7NIV02\datau), master
  Microsoft SQL Server database
  Server version 14.0.1000.169
  Connected since 4/10/2018 9:09:19 PM
  0 of 2 connections in pool active
********************************************************************************
SQL Server Registry Information - 2005 Debugging Configuration
********************************************************************************
HKEY_CLASSES_ROOT\CLSID\{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}
   = PSFactoryBuffer
   HKEY_CLASSES_ROOT\CLSID\{87BC18DB-C8B3-11D5-AE96-00B0D0E93CC1}\InprocServer32
      = C:\Program Files\Common Files\Microsoft Shared\SQL Debugging\ssdebugps.dll
      ThreadingModel= Both
      ( FileVersion:2011.0110.2100.060 ((SQL11_RTM).120210-1917 )       InternalName:SSDEBUGPS      CompanyName:Microsoft Corporation )

registry key not found.
registry key not found.
registry key not found.
registry key not found.
registry key not found.
registry key not found.

********************************************************************************
@@Version
********************************************************************************
14.0.1000.169


**********************************************************************
Loaded Assemblies
**********************************************************************
  Accessibility, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Accessibility\v4.0_4.0.0.0__b03f5f7f11d50a3a\Accessibility.dll
  ActiproSoftware.Docking.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Docking.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.Docking.WinForms.dll
  ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll
  ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll
  Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
  BouncyCastle.Crypto, Version=1.7.4114.6375, Culture=neutral, PublicKeyToken=0e99375e54769942 C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\BouncyCastle.Crypto.dll
  DevExpress.BonusSkins.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.BonusSkins.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.BonusSkins.v17.2.dll
  DevExpress.Data.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Data.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.Data.v17.2.dll
  DevExpress.Mvvm.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Mvvm.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.Mvvm.v17.2.dll
  DevExpress.Printing.v17.2.Core, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Printing.v17.2.Core\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.Printing.v17.2.Core.dll
  DevExpress.RichEdit.v17.2.Core, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.RichEdit.v17.2.Core\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.RichEdit.v17.2.Core.dll
  DevExpress.Utils.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.Utils.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.Utils.v17.2.dll
  DevExpress.XtraBars.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraBars.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.XtraBars.v17.2.dll
  DevExpress.XtraEditors.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraEditors.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.XtraEditors.v17.2.dll
  DevExpress.XtraGrid.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraGrid.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.XtraGrid.v17.2.dll
  DevExpress.XtraLayout.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraLayout.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.XtraLayout.v17.2.dll
  DevExpress.XtraPrinting.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraPrinting.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.XtraPrinting.v17.2.dll
  DevExpress.XtraReports.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraReports.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.XtraReports.v17.2.dll
  DevExpress.XtraTreeList.v17.2, Version=17.2.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\DevExpress.XtraTreeList.v17.2\v4.0_17.2.4.0__b88d1754d700e49a\DevExpress.XtraTreeList.v17.2.dll
  FastData, Version=6.0.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\FastData.dll
  Ionic.Zip, Version=1.9.1.5, Culture=neutral, PublicKeyToken=edbe51ad942a3f5c C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Ionic.Zip.dll
  ManagedQP5, Version=5.2.5.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\managedqp5.dll
  MetadataViewProxies_6c25dccc-19a4-4721-806a-e42b36c7c2ac, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
  Microsoft.GeneratedCode, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null Location is not supported for given Assembly
  Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Microsoft.SqlServer.Types.dll
  Microsoft.VisualStudio.Diagnostics.ServiceModelSink, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Diagnostics.ServiceModelSink\v4.0_4.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Diagnostics.ServiceModelSink.dll
  mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscorlib.dll
  PresentationCore, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_64\PresentationCore\v4.0_4.0.0.0__31bf3856ad364e35\PresentationCore.dll
  PresentationFramework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.dll
  PresentationFramework.Aero2, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\PresentationFramework.Aero2\v4.0_4.0.0.0__31bf3856ad364e35\PresentationFramework.Aero2.dll
  Quest.Common.Forms, Version=4.1.0.5, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Common.Forms.dll
  Quest.Compare.Common, Version=4.1.0.5, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Compare.Common.dll
  Quest.FastETL, Version=7.2.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Quest.FastETL.dll
  Quest.NamedPipeRPC, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Quest.NamedPipeRPC.dll
  Quest.PersistentCache, Version=3.0.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Quest.PersistentCache.dll
  Quest.Reactive, Version=2.3.0.11, Culture=neutral, PublicKeyToken=adaba824f513af5f C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Quest.Reactive.dll
  Quest.Schema.Common.ComparePlugin, Version=4.2.0.25, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.Common.ComparePlugin.dll
  Quest.Schema.Common.Interfaces, Version=4.2.0.25, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.Common.Interfaces.dll
  Quest.Schema.Common.Snapshot, Version=4.2.0.25, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.Common.Snapshot.dll
  Quest.Schema.Common.ToadPlugin.Interfaces, Version=4.2.0.25, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.Common.ToadPlugin.Interfaces.dll
  Quest.Schema.Common.UI, Version=4.2.0.25, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.Common.UI.dll
  Quest.Schema.Common.UI.Interfaces, Version=4.2.0.25, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.Common.UI.Interfaces.dll
  Quest.Schema.MSSQL.ComparePlugin, Version=4.2.0.40, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.MSSQL.ComparePlugin.dll
  Quest.Schema.MSSQL.Interfaces, Version=4.2.0.40, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.MSSQL.Interfaces.dll
  Quest.Schema.MSSQL.Snapshot, Version=4.2.0.40, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.MSSQL.Snapshot.dll
  Quest.Schema.MSSQL.ToadPlugin.Interfaces, Version=4.2.0.40, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.MSSQL.ToadPlugin.Interfaces.dll
  Quest.Schema.MSSQL.UI, Version=4.2.0.40, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Schema.MSSQL.UI.dll
  Quest.Shared, Version=4.1.0.5, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Shared.dll
  Quest.Shared.WPF, Version=4.1.0.5, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\Quest.Shared.WPF.dll
  Quest.ToadCommunication, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Quest.ToadCommunication.dll
  Quest.ToadGeneral, Version=7.0.10.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Quest.ToadGeneral.dll
  Quest.VersionControl, Version=7.8.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Quest.VersionControl.dll
  QuestElevation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\QuestElevation.exe
  QuickGraph, Version=3.6.61114.0, Culture=neutral, PublicKeyToken=f3fb40175eec2af3 C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\Compare\Schema\QuickGraph.dll
  SMDiagnostics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\SMDiagnostics\v4.0_4.0.0.0__b77a5c561934e089\SMDiagnostics.dll
  System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll
  System.ComponentModel.Composition, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.Composition\v4.0_4.0.0.0__b77a5c561934e089\System.ComponentModel.Composition.dll
  System.ComponentModel.DataAnnotations, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ComponentModel.DataAnnotations\v4.0_4.0.0.0__31bf3856ad364e35\System.ComponentModel.DataAnnotations.dll
  System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll
  System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll
  System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll
  System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Data.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Data.Linq.dll
  System.DirectoryServices.AccountManagement, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.DirectoryServices.AccountManagement\v4.0_4.0.0.0__b77a5c561934e089\System.DirectoryServices.AccountManagement.dll
  System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll
  System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll
  System.IdentityModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.IdentityModel\v4.0_4.0.0.0__b77a5c561934e089\System.IdentityModel.dll
  System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Management\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Management.dll
  System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Numerics\v4.0_4.0.0.0__b77a5c561934e089\System.Numerics.dll
  System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll
  System.Runtime.Serialization.Formatters.Soap, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll
  System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel\v4.0_4.0.0.0__b77a5c561934e089\System.ServiceModel.dll
  System.ServiceModel.Internals, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceModel.Internals\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Internals.dll
  System.ServiceProcess, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.ServiceProcess\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.ServiceProcess.dll
  System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_64\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll
  System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\WINDOWS\Microsoft.Net\assembly\GAC_64\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll
  System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Web.Extensions\v4.0_4.0.0.0__31bf3856ad364e35\System.Web.Extensions.dll
  System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll
  System.Workflow.ComponentModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Workflow.ComponentModel\v4.0_4.0.0.0__31bf3856ad364e35\System.Workflow.ComponentModel.dll
  System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089\System.Xaml.dll
  System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll
  System.Xml.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.Linq.dll
  Toad, Version=8.5.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\toad.exe
  ToadAutomation, Version=5.0.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\Automation\ToadAutomation.dll
  ToadCore, Version=8.5.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\ToadCore.dll
  ToadDiff, Version=6.0.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\Core\ToadDiff.dll
  ToadLocalDBProvider, Version=4.5.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\LocalDB\ToadLocalDBProvider.dll
  ToadMySQLProvider, Version=8.5.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\MySQL\ToadMySQLProvider.dll
  ToadPlugin, Version=6.0.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\ToadPlugin.dll
  ToadSqlServer, Version=6.9.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\ToadSqlServer.dll
  ToadSqlServerProvider, Version=6.9.0.225, Culture=neutral, PublicKeyToken=ef645eb5653fd56a C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\Plugins\SqlServer\ToadSqlServerProvider.dll
  UIAutomationClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\UIAutomationClient\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationClient.dll
  UIAutomationProvider, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\UIAutomationProvider\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationProvider.dll
  UIAutomationTypes, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\UIAutomationTypes\v4.0_4.0.0.0__31bf3856ad364e35\UIAutomationTypes.dll
  WindowsBase, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\WindowsBase\v4.0_4.0.0.0__31bf3856ad364e35\WindowsBase.dll
  WindowsFormsIntegration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\WindowsFormsIntegration\v4.0_4.0.0.0__31bf3856ad364e35\WindowsFormsIntegration.dll
  QP5, Version=5.325.18054.42268, C:\Program Files\Quest Software\Toad for SQL Server Beta 6.9\qp5.dll
**********************************************************************
Licensing
**********************************************************************
Freeware

59 1 / Create an account to join the discussion.
MetteS
Follow / 23 Jun 2017 at 9:15am / Toad for SQL Server Beta Program
Latest post by on 4 Jun 2018 at 9:59am

IN MEMORY tables show 2 or 3 times in explorer

Expand content
SQL Server 2016 with newest beta SQL Server . All tables with IN MEMORY option shows up 2 or more times in the object explorer regards Mette

SQL Server 2016 with newest beta SQL Server .

All tables with IN MEMORY option shows up 2 or more times in the object explorer

regards

Mette

502 3 / Create an account to join the discussion.
michael

Toad For SQL Server 6.9.0.296 Beta have been post.

Expand content
Hello , Toad For SQL Server 6.9.0.296 Beta have been post. Download Link: https://community.toadworld.com/products/toad-for-sql-server/toad_for_sql_server_beta_program/ Thanks, TSS Team

Hello ,

Toad For SQL Server 6.9.0.296 Beta have been post.

Download Link:  https://community.toadworld.com/products/toad-for-sql-server/toad_for_sql_server_beta_program/

Thanks,

TSS Team

62 0 / Create an account to join the discussion.
kaplan.dani
Follow / 23 Apr 2018 at 5:53pm / Toad for SQL Server Beta Program
Latest post by on 24 Apr 2018 at 2:24pm

POOR 4K compatability

Expand content
Toad looks very bad on a 4K resolution. It looks like you're not obeying windows enlargement feature This is how a dialog looks when I open it on a 4K monitor:

Toad looks very bad on a 4K resolution.

It looks like you're not obeying windows enlargement feature 

This is how a dialog looks when I open it on a 4K monitor:

67 1 / Create an account to join the discussion.
michael
Follow / 29 Mar 2018 at 7:05am / Toad for SQL Server Beta Program
Latest post by on 29 Mar 2018 at 1:47pm

Toad for SQL Server Beta build 6.9.0.225 is now available

Expand content
Hello, Toad for SQL Server Beta build 6.9.0.225 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.225 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:

ID                   Summary

=========   ===================================

TSS-1521    [SubCase]-Data Compare made wrong key mapping

TSS-1514    Exception when refreshing all

TSS-1513    SQL Azure - error show when click Create like Index or Alter Index in OE

TSS-1512    SQL Azure - error shows when click OE - Programmability tab

TSS-1510    SQL Server provider is slow to load tables

ToadforSQLServer Team

182 2 / Create an account to join the discussion.
mitchell.sacks_234

Beta Extension?

Expand content
Hi, The current beta is expired, is there a way to extend it?

Hi, 

The current beta is expired, is there a way to extend it?

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

285 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

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

190 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

211 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

376 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

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

160 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

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

309 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

995 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

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

567 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

959 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

731 1 / Create an account to join the discussion.