How can we help you today? How can we help you today?

SQL Prompt manages to bring down SSMS/.NET IDE

I have both VS.NET IDE (database project) and SSMS open (could be editing same file from either side)

First of all in VS.NET IDE (I have default connection using SQL Server Authentication) it failed to prompt me to enter credentials to connect to the sql server when I open a file. Instead SQL Prompt used to give me a error message every time I open a .sql file in VS.NET IDE "SQL Prompt - Unable to cache database objects" I figured I needed to use the Connect Database option once before it can work. So, fine, I entered the credentials and it cached the database objects shortly, successfully.
But it failed to give me any suggestions when I am in VS.NET IDE. Well, at least I do not get that nagging error message any more. If it does not work in VS.NET and does not give me a message every time I open a .sql file I am ok with that in BETA version. :) In full working version, though, I would expect it to work without fail and prompt me for credentials once, instead of me going and choosing a option to connect manually.

However, it SQL Prompt in SSMS did not like that idea that I am using .NET IDE as well. It gave me following error message. and I can not get away from it by clicking OK or Cancel. It simply presented that error message again and again. Finally, I had to end SSMS Process :(
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SQLPrompt.CommonUI.Editor.EditorViewBase.GetLineForLocation(Point point)
at RedGate.SQLPrompt.CommonUI.Editor.EditorViewBase.GetPositionForLocation(Point point)
at RedGate.SQLPrompt.CommonUI.Editor.EditorViewBase.a(Object , MouseEventArgs )
at am.a(MouseEventArgs )
at am.a(Object , EventArgs )
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
AppIDPackage
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Microsoft.SqlServer.SqlTools.VSIntegration
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6071
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.10.6070
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
SqlWorkbench.Interfaces
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
Microsoft.SqlServer.SqlTDiagM
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
Microsoft.SqlServer.Instapi
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
Microsoft.VisualStudio.Shell.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
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.SqlServer.Management.SDK.SqlStudio
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.DLL
SQLEditors
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL
Microsoft.VisualStudio.TextManager.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.10.6070
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
SqlMgmt
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
Microsoft.SqlServer.Management.UserSettings
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UserSettings.DLL
EnvDTE
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
Microsoft.SqlServer.Management.Sdk.Sfc
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Sdk.Sfc/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Management.Reports
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Reports.DLL
RedGate.SQLPrompt.SSMSUI
Assembly Version: 4.0.1.2
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SQLPrompt.SSMSUI.dll
RedGate.SQLPrompt.CommonVS
Assembly Version: 4.0.1.2
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/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.CommonUI
Assembly Version: 4.0.1.2
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SQLPrompt.CommonUI.DLL
RedGate.SqlPrompt.Engine
Assembly Version: 4.0.1.2
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Engine.DLL
RedGate.SqlPrompt.Metadata
Assembly Version: 4.0.1.2
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Metadata.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%204/RedGate.SQLPrompt.vsmso.DLL
log4net
Assembly Version: 1.2.10.0
Win32 Version: 1.2.10.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/log4net.DLL
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
RedGate.Shared.Utils
Assembly Version: 7.1.0.39
Win32 Version: 7.1.0.39
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.Shared.Utils.DLL
RedGate.Licensing.Client
Assembly Version: 2.7.0.3
Win32 Version: 2.7.0.3
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.Licensing.Client.DLL
OptionsUIOptionsdcee9f4633d645369aabb34eb07da24b
Assembly Version: 0.0.0.0
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Metadata.dll
ISymWrapper
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/ISymWrapper/2.0.0.0__b03f5f7f11d50a3a/ISymWrapper.dll
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
OptionsEngineOptions89e64174352d423fb0d7922f1a640586
Assembly Version: 0.0.0.0
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Metadata.dll
OptionsLayoutOptions69847c5bb2b3456f8d57317f8c445458
Assembly Version: 0.0.0.0
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Metadata.dll
EnvDTE80
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE80/8.0.0.0__b03f5f7f11d50a3a/EnvDTE80.dll
System.Data.SqlXml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll
System.Xml.Xsl.CompiledQuery.1
Assembly Version: 0.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll
CustomMarshalers
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
RedGate.Update.Client
Assembly Version: 2.1.0.4
Win32 Version: 2.1.0.4
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.Update.Client.DLL
RedGate.Refactoring.ComAddIn
Assembly Version: 1.3.0.207
Win32 Version: 1.3.0.207
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.ComAddIn.dll
RedGate.Refactoring.AddIn-100
Assembly Version: 1.3.0.207
Win32 Version: 1.3.0.207
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.AddIn-100.DLL
RedGate.Licensing.Client
Assembly Version: 2.6.0.64
Win32 Version: 2.6.0.64
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Licensing.Client.DLL
RedGate.Refactoring.vsmso
Assembly Version: 8.0.0.0
Win32 Version: 8.0.0.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.vsmso.DLL
RedGate.SQLCompare.Rewriter
Assembly Version: 7.0.1.29
Win32 Version: 7.0.1.29
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.Rewriter.DLL
RedGate.SQLCompare.ASTParser
Assembly Version: 7.0.1.29
Win32 Version: 7.0.1.29
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.ASTParser.DLL
ActiproSoftware.Wizard.Net20
Assembly Version: 3.0.125.0
Win32 Version: 3.0.125.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/ActiproSoftware.Wizard.Net20.DLL
RedGate.SQLCompare.Engine
Assembly Version: 7.0.1.29
Win32 Version: 7.0.1.29
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.SQLCompare.Engine.DLL
ObjectExplorer
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
Microsoft.VisualStudio
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 built by: QFE
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
System.Drawing.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.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
ConnectionDlg
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
Microsoft.SqlServer.Management.Controls
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Controls.DLL
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
Microsoft.SqlServer.RegSvrEnum
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
Microsoft.SqlServer.Management.SqlStudio.Explorer
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.Explorer.DLL
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
Microsoft.SqlServer.ConnectionInfo
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Management.RegisteredServers
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Management.RegisteredServers/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.RegisteredServers.dll
Microsoft.SqlServer.SqlClrProvider
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlClrProvider/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlClrProvider.dll
kkrjbewz
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Microsoft.SqlServer.SString
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SString/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SString.dll
hpfd7wjv
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
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.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
Microsoft.SqlServer.Smo
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.SqlEnum
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll
Microsoft.SqlServer.BatchParserClient
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.BatchParserClient/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParserClient.dll
Microsoft.SqlServer.BatchParser
Assembly Version: 10.0.0.0
Win32 Version: 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.BatchParser/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll
msvcm80
Assembly Version: 8.0.50727.3053
Win32 Version: 8.00.50727.3053
CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.3053_x-ww_b80fa8ca/msvcm80.dll
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
Microsoft.DataWarehouse
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.DLL
Microsoft.SqlServer.GridControl
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.GridControl/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.GridControl.dll
Microsoft.SqlServer.Dmf
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Dmf/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Dmf.dll
Microsoft.SqlServer.PolicyEnum
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.PolicyEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.PolicyEnum.dll
RedGate.Refactoring.AddIn.ServicePack2-100
Assembly Version: 1.3.0.207
Win32 Version: 1.3.0.207
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Refactoring.AddIn.ServicePack2-100.DLL
ObjectExplorerReplication
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorerReplication.DLL
Microsoft.DataWarehouse.SQM
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
Microsoft.SqlServer.Sqm
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Sqm.DLL
Microsoft.SqlServer.Management.SqlStudio
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SqlStudio.DLL
olnag2gp
Assembly Version: 10.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
Microsoft.SqlServer.Management.MultiServerConnection
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Management.MultiServerConnection/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.MultiServerConnection.dll
RadLangSvc
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/RadLangSvc.DLL
Microsoft.VisualStudio.Package.LanguageService
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Package.LanguageService/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Package.LanguageService.dll
Microsoft.SqlServer.SqlParser
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlParser.DLL
Microsoft.VisualStudio.TextManager.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.8.0.dll
RedGate.SqlPrompt.Parser
Assembly Version: 4.0.1.2
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Parser.DLL
bxvdwjvu
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
mwy8akac
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
OptionsAllOptionsf7f303359c394d3ca23caf91d616fca6
Assembly Version: 0.0.0.0
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Metadata.dll
RedGate.SQLCompare.ASTParser
Assembly Version: 7.1.0.184
Win32 Version: 7.1.0.184
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SQLCompare.ASTParser.DLL
RedGate.SqlPrompt.Cache
Assembly Version: 4.0.1.2
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Cache.DLL
RedGate.SqlPrompt.PageReader
Assembly Version: 4.0.1.2
Win32 Version: 4.0.1.2
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.PageReader.DLL
RedGate.SQLCompare.Engine
Assembly Version: 7.1.0.184
Win32 Version: 7.1.0.184
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SQLCompare.Engine.DLL
Microsoft.VisualStudio.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1826 (QFE.050727-1800)
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.1826 (QFE.050727-1800)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell.Design/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Design.dll
Microsoft.SqlServer.DataStorage
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DataStorage/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.DataStorage.dll
Microsoft.SqlServer.Types
Assembly Version: 10.0.0.0
Win32 Version: 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Types/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Types.dll
RedGate.Shared.Utils
Assembly Version: 7.0.0.67
Win32 Version: 7.0.0.67
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor%201/RedGate.Shared.Utils.DLL
Microsoft.SqlServer.Management.Data.Interop
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Data.Interop.DLL
Microsoft.SqlServer.Management.DataTools.Interop
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.DataTools.Interop.DLL
Microsoft.SqlServer.Management.DataTools
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.DataTools.DLL
Microsoft.SqlServer.Management.Data
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Data.DLL
Microsoft.SqlServer.Management.ConnectionUI.Dialog
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.ConnectionUI.Dialog.DLL
Microsoft.SqlServer.Management.ConnectionUI
Assembly Version: 10.0.0.0
Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100
Raghu
0

Comments

3 comments

Sort by
  • Raghu
    I think, I figured it out.

    This is nothing to do with interaction of SQL Prompt and VS.NET IDE and SSMS at same time. And it is not specific to SSMS. It is happening in VS.NET IDE as well.

    It is split the editing area into separate sections to edit two different portions of the same file is causing this.

    What is bad is even when I turn off SQL Prompt (going to Options->Use SQL Prompt check that off) it happens. :evil:

    I think it is totally unacceptable behavior and deal breaker to have even BETA testing going on for me. I am forced to rollback to earlier version of SQL Prompt. I can not live with "not be able to" edit multiple sections of the same file in single code window. :cry:
    Raghu
    0
  • tanya
    Hi Raghu,

    Sincere apologies for the inconvenience caused. We are looking into this issue and I will keep you posted with updates.

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0
  • tanya
    Hello,

    I just wanted to let you know that this issue has been fixed and the fix will be available in the release build.
    We anticipate to release the product by early August:)

    Thanks,
    Tanya
    Project Manager
    Red Gate Software Ltd
    tanya
    0

Add comment

Please sign in to leave a comment.