3.5 Issue in VSTS for DB Professionals

BryantBryant Posts: 20
edited July 20, 2007 1:02PM in SQL Prompt Previous Versions
SQL Prompt 3.5 tries to help me out with a CREATE TABLE script but throws an exception when I try to use TAB or ENTER to auto-complete the data type of a column. I am working in a SQL Server 2005 project using VSTS for Database Professionals (aka Data Dude).

Example (try to auto-complete with the UNIQUEIDENTIFIER type in the following script):
CREATE TABLE [dbo].[Leagues]
(
	league_id   UNI
Exception info (probably overkill but it's better to have it and not need it than the other way around):

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Specified cast is not valid.
at EnvDTE.EditPoint.Delete(Object PointOrCount)
at RedGate.SQLPrompt.CommonVS.Editor.VSScriptProvider._1(IEnumerable`1 )
at RedGate.SQLPrompt.CommonVS.Editor.VSScriptProvider.ApplyChanges(ICompletionFragments fragments)
at RedGate.SqlPrompt.Engine.SqlPromptEngine._1(ICompletionFragments )
at RedGate.SqlPrompt.Engine.SqlPromptEngine.ApplyCompletionFor(ICandidate candidate, CompletionModifier modifier, CompletionKey key)
at RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase.Complete(CompletionModifier cm, CompletionKey ck)
at RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase.Complete(CompletionKey ck)
at RedGate.SQLPrompt.CommonVS.Editor.VSEditorWindow.OnTextViewTab(VSTextView sender, HandledEventArgs e)
at RedGate.SQLPrompt.CommonVS.Editor.VSTextView.Exec(Guid& pguidCmdGroup, UInt32 nCmdID, UInt32 nCmdexecopt, IntPtr pvaIn, IntPtr pvaOut)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
Microsoft.VisualStudio.CommonIDE
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.CommonIDE/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommonIDE.dll
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
Microsoft.Practices.RecipeFramework.VisualStudio
Assembly Version: 1.0.60429.0
Win32 Version: 1.0.60613.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Microsoft.Practices.RecipeFramework.VisualStudio.DLL
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
Microsoft.VisualStudio.Shell.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
Microsoft.Practices.RecipeFramework
Assembly Version: 1.0.60429.0
Win32 Version: 1.0.60613.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Microsoft.Practices.RecipeFramework.DLL
Microsoft.Practices.RecipeFramework.VisualStudio.Common
Assembly Version: 1.0.60429.0
Win32 Version: 1.0.60613.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Microsoft.Practices.RecipeFramework.VisualStudio.Common.DLL
Microsoft.Practices.Common
Assembly Version: 1.0.60429.0
Win32 Version: 1.0.60613.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Microsoft.Practices.Common.DLL
Microsoft.Practices.ComponentModel
Assembly Version: 1.0.60429.0
Win32 Version: 1.0.60613.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Microsoft.Practices.ComponentModel.DLL
Microsoft.Practices.RecipeFramework.Common
Assembly Version: 1.0.60429.0
Win32 Version: 1.0.60613.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Microsoft.Practices.RecipeFramework.Common.DLL
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
Mvp.Xml
Assembly Version: 2.0.2158.1055
Win32 Version: 2.0.2158.1055
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Mvp.Xml.DLL
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
Microsoft.VisualStudio
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 built by: RTM
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
Microsoft.VisualStudio.Designer.Interfaces
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
System.Drawing.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
RPCoreWhidbey
Assembly Version: 1.0.0.90
Win32 Version: 1.0.0.90
CodeBase: file:///C:/Program%20Files/SlickEdit%20Gadgets/RPCoreWhidbey.dll
LoggingWhidbey
Assembly Version: 1.0.0.4
Win32 Version: 1.0.0.4
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/LoggingWhidbey/1.0.0.4__bf81d2044fa6b642/LoggingWhidbey.dll
Microsoft.Practices.EnterpriseLibrary.Common
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Practices.EnterpriseLibrary.Common/2.0.0.0__bf81d2044fa6b642/Microsoft.Practices.EnterpriseLibrary.Common.dll
Microsoft.Practices.EnterpriseLibrary.Logging
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Practices.EnterpriseLibrary.Logging/2.0.0.0__bf81d2044fa6b642/Microsoft.Practices.EnterpriseLibrary.Logging.dll
Microsoft.Practices.ObjectBuilder
Assembly Version: 1.0.51205.0
Win32 Version: 1.0.51205.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Practices.ObjectBuilder/1.0.51205.0__bf81d2044fa6b642/Microsoft.Practices.ObjectBuilder.dll
EnvDTE
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
Microsoft.Practices.EnterpriseLibrary.ExceptionHandling
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Practices.EnterpriseLibrary.ExceptionHandling/2.0.0.0__bf81d2044fa6b642/Microsoft.Practices.EnterpriseLibrary.ExceptionHandling.dll
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
Microsoft.VisualStudio.CommandBars
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.CommandBars/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommandBars.dll
RedGate.SQLPrompt.VSUI
Assembly Version: 3.5.0.323
Win32 Version: 3.5.0.323
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.VSUI.dll
RedGate.SQLPrompt.CommonVS
Assembly Version: 3.5.0.323
Win32 Version: 3.5.0.323
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonVS.DLL
Extensibility
Assembly Version: 7.0.3300.0
Win32 Version: 7.00.9466
CodeBase: file:///C:/WINDOWS/assembly/GAC/Extensibility/7.0.3300.0__b03f5f7f11d50a3a/Extensibility.dll
RedGate.SqlPrompt.Engine
Assembly Version: 3.5.0.323
Win32 Version: 3.5.0.323
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.DLL
Microsoft.VisualStudio.TextManager.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
RedGate.SQLPrompt.CommonUI
Assembly Version: 3.5.0.323
Win32 Version: 3.5.0.323
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.CommonUI.DLL
log4net
Assembly Version: 1.2.10.0
Win32 Version: 1.2.10.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/log4net.DLL
RedGate.Licensing.Client
Assembly Version: 1.3.3.2
Win32 Version: 1.3.3.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Licensing.Client.DLL
RedGate.SQL.Shared
Assembly Version: 6.0.0.95
Win32 Version: 6.0.0.95
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQL.Shared.DLL
RedGate.Shared.Utils
Assembly Version: 6.0.0.95
Win32 Version: 6.0.0.95
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.Shared.Utils.DLL
EnvDTE80
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE80/8.0.0.0__b03f5f7f11d50a3a/EnvDTE80.dll
RedGate.SQLPrompt.vsmso
Assembly Version: 8.0.0.0
Win32 Version: 8.0.0.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLPrompt.vsmso.DLL
RedGate.SQLPrompt.VSUI.resources
Assembly Version: 3.5.0.323
Win32 Version: 3.5.0.323
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/en/RedGate.SQLPrompt.VSUI.resources.dll
CustomMarshalers
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
RedGate.SqlPrompt.Engine.Gatekeeper
Assembly Version: 3.5.0.323
Win32 Version: 3.5.0.323
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SqlPrompt.Engine.Gatekeeper.DLL
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
RedGate.SQLCompare.Engine
Assembly Version: 5.8.1.31
Win32 Version: 5.8.1.31
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.Engine.DLL
Ankh
Assembly Version: 1.0.1.2736
Win32 Version: 1.0.1.2736
CodeBase: file:///C:/Program%20Files/AnkhSVN/Ankh.dll
NSvn.Core
Assembly Version: 1.0.1.2736
Win32 Version:
CodeBase: file:///C:/Program%20Files/AnkhSVN/NSvn.Core.DLL
Ankh.UI
Assembly Version: 1.0.1.2736
Win32 Version: 1.0.1.2736
CodeBase: file:///C:/Program%20Files/AnkhSVN/Ankh.UI.DLL
Utils
Assembly Version: 1.0.1.2736
Win32 Version: 1.0.1.2736
CodeBase: file:///C:/Program%20Files/AnkhSVN/Utils.DLL
dusutuk_
Assembly Version: 1.0.1.2736
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
NSvn.Common
Assembly Version: 1.0.1.2736
Win32 Version: 1.0.1.2736
CodeBase: file:///C:/Program%20Files/AnkhSVN/NSvn.Common.DLL
AnkhUserControlHostLib
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/AnkhSVN/AnkhUserControlHostLib.DLL
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
Microsoft.VisualC
Assembly Version: 8.0.0.0
Win32 Version: 8.00.50727.42
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualC/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualC.dll
5qrxl9m3
Assembly Version: 1.0.1.2736
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Microsoft.VisualStudio.TeamSystem.DataPackage
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.330
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.TeamSystem.DataPackage.DLL
Microsoft.Build.Engine
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 built by: QFE
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Build.Engine/2.0.0.0__b03f5f7f11d50a3a/Microsoft.Build.Engine.dll
Microsoft.Build.Framework
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 built by: RTM
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Build.Framework/2.0.0.0__b03f5f7f11d50a3a/Microsoft.Build.Framework.dll
Microsoft.VisualStudio.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Design/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Design.dll
Microsoft.VisualStudio.Shell.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell.Design/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Design.dll
Microsoft.VisualStudio.QualityTools.Tips.TuipPackage
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.Tips.TuipPackage.DLL
Microsoft.VisualStudio.QualityTools.Common
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.Common.DLL
Microsoft.VisualStudio.QualityTools.Vsip
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.Vsip.DLL
Microsoft.VisualStudio.QualityTools.Tips.UnitTest.Tip
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.Tips.UnitTest.Tip.DLL
Microsoft.VisualStudio.QualityTools.Tips.OrderedTest.Tip
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.Tips.OrderedTest.Tip.DLL
Microsoft.VisualStudio.QualityTools.Resource
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.QualityTools.Resource/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.QualityTools.Resource.dll
Microsoft.VisualStudio.QualityTools.Tips.ManualTest.Tip
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.Tips.ManualTest.Tip.DLL
Microsoft.VisualStudio.QualityTools.Tips.GenericTest.Tip
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.Tips.GenericTest.Tip.DLL
Microsoft.VisualStudio.QualityTools.Tips.ManualTest.ObjectModel
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.Tips.ManualTest.ObjectModel.DLL
Microsoft.VisualStudio.QualityTools.TMI
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.TMI.DLL
Microsoft.VisualStudio.QualityTools.TestCaseManagement
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.TestCaseManagement.DLL
Microsoft.VisualStudio.QualityTools.CodeCoverage
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.CodeCoverage.DLL
Microsoft.VisualStudio.TeamSystem.Common
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.TeamSystem.Common.DLL
Microsoft.VisualStudio.Debugger.Interop
Assembly Version: 8.0.1.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Debugger.Interop/8.0.1.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Debugger.Interop.dll
Microsoft.VisualStudio.QualityTools.CMI
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.QualityTools.CMI.DLL
Microsoft.VisualStudio.ProjectAggregator
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.ProjectAggregator/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.ProjectAggregator.dll
Microsoft.Build.Tasks
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 built by: QFE
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Build.Tasks/2.0.0.0__b03f5f7f11d50a3a/Microsoft.Build.Tasks.dll
Microsoft.Build.Utilities
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 built by: RTM
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Build.Utilities/2.0.0.0__b03f5f7f11d50a3a/Microsoft.Build.Utilities.dll
Microsoft.VSSDK.PowerToy.EventToaster
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VSSDK.PowerToy.EventToaster.DLL
vyumq4t4
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Microsoft.VSSDK.PowerToy.VcCodeSnippets
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VSSDK.PowerToy.VcCodeSnippets.DLL
Microsoft.VisualStudio.TextManager.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.8.0.dll
Microsoft.MSXML
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.MSXML/8.0.0.0__b03f5f7f11d50a3a/Microsoft.MSXML.dll
CodeSmith.VisualStudio.Package
Assembly Version: 4.0.0.0
Win32 Version: 4.0.2.1774
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CodeSmith.VisualStudio.Package/4.0.0.0__9fd61cdb91609a7a/CodeSmith.VisualStudio.Package.dll
CodeSmith.Engine
Assembly Version: 4.0.0.0
Win32 Version: 4.0.2.1774
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CodeSmith.Engine/4.0.0.0__9fd61cdb91609a7a/CodeSmith.Engine.dll
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
CodeSmith.Gui
Assembly Version: 4.0.0.0
Win32 Version: 4.0.2.1774
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CodeSmith.Gui/4.0.0.0__9fd61cdb91609a7a/CodeSmith.Gui.dll
4ba0onld
Assembly Version: 4.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Microsoft.VisualStudio.WCFSvcConfigEditor
Assembly Version: 3.0.0.0
Win32 Version: 3.0.4530.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.WCFSvcConfigEditor.DLL
EditorGadgetsWhidbey
Assembly Version: 1.0.0.90
Win32 Version: 1.0.0.90
CodeBase: file:///C:/Program%20Files/SlickEdit%20Gadgets/EditorGadgetsWhidbey.dll
SubclassedEditorWhidbey
Assembly Version: 1.0.2553.29930
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/SlickEdit%20Gadgets/SubclassedEditorWhidbey.DLL
Microsoft.VisualStudio.WCPCommonServices
Assembly Version: 3.0.0.0
Win32 Version: 3.0.4530.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.WCPCommonServices.DLL
Microsoft.VisualStudio.TemplateWizardInterface
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.TemplateWizardInterface/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TemplateWizardInterface.dll
gv6wg7hk
Assembly Version: 1.0.60429.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Microsoft.Practices.WizardFramework
Assembly Version: 1.0.60429.0
Win32 Version: 1.0.60613.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Microsoft.Practices.WizardFramework.DLL
COM2InteropEmit
Assembly Version: 0.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
StanPackage
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762 built by: SP(DDBLD307-dlab)
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Team%20Tools/Static%20Analysis%20Tools/stanpackage.dll
msvcm80
Assembly Version: 8.0.50727.762
Win32 Version: 8.00.50727.762
CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700/msvcm80.dll
StanPolicy
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762 built by: SP(DDBLD307-dlab)
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Team%20Tools/Static%20Analysis%20Tools/StanPolicy.dll
Microsoft.VisualStudio.TeamFoundation
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.147
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.VisualStudio.TeamFoundation.DLL
Microsoft.TeamFoundation.Client
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.TeamFoundation.Client/8.0.0.0__b03f5f7f11d50a3a/Microsoft.TeamFoundation.Client.dll
Microsoft.TeamFoundation.Common
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.TeamFoundation.Common/8.0.0.0__b03f5f7f11d50a3a/Microsoft.TeamFoundation.Common.dll
Microsoft.VisualStudio.VCProjectEngine
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 built by: RTM(DDBLD587-dlab)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.VCProjectEngine/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.VCProjectEngine.dll
Microsoft.DataTransformationServices.VsIntegration
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PrivateAssemblies/Microsoft.DataTransformationServices.VsIntegration.DLL
Microsoft.VisualStudio.Modeling.Sdk.DslDesigner
Assembly Version: 8.2.0.0
Win32 Version: 8.1.50727.42
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Modeling.Sdk.DslDesigner/8.2.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Modeling.Sdk.DslDesigner.dll
Microsoft.Practices.RecipeFramework.VisualStudio.Library
Assembly Version: 1.0.60429.0
Win32 Version: 1.0.60613.0
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/PublicAssemblies/Microsoft.Practices.RecipeFramework.VisualStudio.Library.DLL
Microsoft.VisualStudio.TemplateWizard
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/Microsoft.VisualStudio.TemplateWizard.DLL
Microsoft.VisualStudio.TeamSystem.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.330
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.TeamSystem.Data/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TeamSystem.Data.dll
Microsoft.VisualStudio.TeamSystem.Data.Generators
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.330
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.TeamSystem.Data.Generators/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TeamSystem.Data.Generators.dll
Microsoft.WizardFrameworkVS
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/Microsoft.WizardFrameworkVS.DLL
Microsoft.WizardFramework
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/Microsoft.WizardFramework.DLL
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
Microsoft.SqlServer.ConnectionInfo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.VisualStudio.Editors
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Editors/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Editors.dll
Microsoft.VisualStudio.ManagedInterfaces
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.ManagedInterfaces/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.ManagedInterfaces.dll
Microsoft.VisualStudio.VirtualTreeGrid
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.VirtualTreeGrid/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.VirtualTreeGrid.dll
VSLangProj
Assembly Version: 7.0.3300.0
Win32 Version: 7.00.9466
CodeBase: file:///C:/WINDOWS/assembly/GAC/VSLangProj/7.0.3300.0__b03f5f7f11d50a3a/VSLangProj.dll
VsWebSite.Interop
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/WINDOWS/assembly/GAC/VsWebSite.Interop/8.0.0.0__b03f5f7f11d50a3a/VsWebSite.Interop.dll
Microsoft.SqlServer.BatchParser
Assembly Version: 9.0.242.0
Win32 Version: 2005.090.3042.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.BatchParser/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll
RedGate.SQLCompare.ASTParser
Assembly Version: 5.8.1.31
Win32 Version: 5.8.1.31
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203/RedGate.SQLCompare.ASTParser.DLL
Microsoft.VisualStudio.Package.LanguageService
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Package.LanguageService/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Package.LanguageService.dll
Microsoft.VisualStudio.vspGridControl
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1314.00
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/Microsoft.VisualStudio.vspGridControl.DLL
Microsoft.VisualStudio.Data
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/Microsoft.VisualStudio.Data.DLL
CodeSmith.MSBuild
Assembly Version: 4.0.0.0
Win32 Version: 4.0.2.1774
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/CodeSmith.MSBuild/4.0.0.0__9fd61cdb91609a7a/CodeSmith.MSBuild.dll
Microsoft.VSDesigner
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VSDesigner/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VSDesigner.dll
Microsoft.VisualStudio.Data.Interop
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/Microsoft.VisualStudio.Data.Interop.DLL
Microsoft.VisualStudio.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Windows.Forms/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Windows.Forms.dll
Microsoft.XmlEditor
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.762 (SP.050727-7600)
CodeBase: file:///C:/Program%20Files/Microsoft%20Visual%20Studio%208/Common7/IDE/Xml/Microsoft.XmlEditor.dll
Microsoft.VisualStudio.WizardFramework
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.WizardFramework/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.WizardFramework.dll

Comments

  • Bart ReadBart Read Posts: 997 Silver 1
    Hi there,


    Thanks for posting. That's very strange because Data Dude shouldn't be supported at all by SQL Prompt. However, throwing an exception is a pretty nasty way not to support something so we'll make sure this is fixed by the time the final release comes out. Once that happens you'll find that SQL Prompt does not pop up auto-completion in the Data Dude editor.

    Sorry for the hassle in the meantime.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • No problem, I just disabled SQL Prompt from the menu and no more exceptions. I must admit though, I was a little disappointed when it looked like it was going to work and then didn't. :cry:

    Any chance we'll have Data Dude support in an upcoming release? I can't use the standard database projects (even if I wanted to) because AnkhSVN chokes on them and we use Subversion for source control.
  • Bart ReadBart Read Posts: 997 Silver 1
    Hi there,


    Unfortunately not. I touch on this briefly in this blog post:

    http://www.simple-talk.com/community/bl ... 33882.aspx

    We took a decision some months back that for commercial reasons we were not going to support Data Dude in SQL Prompt 3.5, although from a technical point of view it wouldn't be terribly difficult to add full support.

    Maybe in the future that will change but I can't see it happening in the near term. As with a lot of things, if enough people asked for it we might reconsider so I can't rule it out, but for now unfortunately the answer is no.

    Sorry I can't be more help right now.


    Kind regards,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.