User profile for AndyIrving – Support

Activity overview Badges (0) Posts (5) Comments (8)

Comments

this is a slightly different error but i can at least reproduce it: first, CREATE TABLE test (blah INT) then ctrl+shift+d to refresh cache then type the following: INSERT INTO dbo.test ( blah ) OUTPUT i at which point, the candidate list will come up with INSERTED, so you chose it, then hit . so you now have the column blah (from table test) coming up in the candidate list. select it then hit enter, and you get the below: 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.Metadata.Utils.BasicTreeNodeUtils.<FindDescendants>d__0`1.MoveNext() at RedGate.SqlPrompt.Parser.CandidateCompleter.a(IColumnCandidate , IBasicTreeNode ) at RedGate.SqlPrompt.Parser.CandidateCompleter.ShouldQualify(IEngineOptions options, IBasicTreeNode node, ServerType serverType, IDbObject obj, ICandidate CandidateToQualifyWith, Boolean ignoreNodeQualification) at RedGate.SqlPrompt.Parser.CandidateCompleter.CompleteQualifiedColumn(IEngineOptions options, IBasicTreeNode node, IColumnCandidate candidate, Boolean ignoreNodeQualification, Boolean forceQualification) at RedGate.SqlPrompt.Parser.CandidateCompleter.CompleteQualifiedColumn(IEngineOptions options, IBasicTreeNode node, IColumnCandidate candidate) at RedGate.SqlPrompt.Cache.Candidates.ColumnCandidate.GetCompletionText(IEngineOptions engineOptions, LayoutOptions layoutOptions, IBasicTreeNode node) at RedGate.SqlPrompt.Metadata.Candidates.CandidateBase.GetCompletionFragment(IEngineOptions engineOptions, LayoutOptions layoutOptions, IBasicTreeNode node, Int32 startIndex, Int32 endIndex) at RedGate.SqlPrompt.Engine.NewEngine.Suggestions.GetCompletionFragment(ICandidate candidate, EngineOptions options, LayoutOptions layoutOptions, Int32 startIndex, Int32 endIndex) at RedGate.SqlPrompt.Engine.PromptEngineEmulator.ApplyCompletionFor(ICandidate candidate, Selection selection, CompletionKey completionKey) at RedGate.SQLPrompt.CommonUI.Editor.EditorWindowBase.Complete(CompletionKey ck, Boolean& nobbleTheCompletionKey) at RedGate.SQLPrompt.CommonVS.Editor.VSEditorWindow.a(Boolean , HandledEventArgs ) at RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor.Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.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.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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.24 ((Katmai_PCU_ISM_DEV10).080923-0837 ) 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 Microsoft.SqlServer.Management.Sdk.Sfc Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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 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.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 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 OptionsUIOptions6d60b3099c394b429ba5126bbccf72eb 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 OptionsEngineOptionsc9dbc4487f0a44d7bee756f31470c1fa 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 OptionsLayoutOptions5255b2daeb574682a057a87f0bfd3c32 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 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 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 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 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 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 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.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 SqlInternals.AllocationInfo.Addin Assembly Version: 1.0.3159.38449 Win32 Version: 1.0.3159.38449 CodeBase: file:///C:/Program%20Files/SSMS%20Allocation%20Info%20Add-in/SqlInternals.AllocationInfo.Addin.dll Microsoft.VisualStudio.CommandBars Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.932 (QFE.050727-9300) CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.CommandBars/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommandBars.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 ObjectExplorer Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL SqlMgmt Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Controls.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 Microsoft.SqlServer.Smo Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.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.24 ((Katmai_PCU_ISM_DEV10).080923-0837 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.24 ((Katmai_PCU_ISM_DEV10).080923-0837 ) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlClrProvider/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlClrProvider.dll kkahun2x 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.24 ((Katmai_PCU_ISM_DEV10).080923-0837 ) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SString/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SString.dll joe1hr0f 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.SqlEnum Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.24 ((Katmai_PCU_ISM_DEV10).080923-0837 ) 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.024 ((Katmai_PCU_ISM_DEV10).080923-0837 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.24 ((Katmai_PCU_ISM_DEV10).080923-0837 ) 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 gv7ua7pg 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 SQLEditors Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SQLEditors.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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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.2531.0 ((Katmai_PCU_Main).090329-1015 ) 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 jmexrfge 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 -x0gyjtz 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 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 Microsoft.SqlServer.Management.RegisteredServersUI 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.RegisteredServersUI.DLL System.Security Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll Microsoft.VisualStudio.CommonIDE Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.1826 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.CommonIDE/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.CommonIDE.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.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 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.024 ((Katmai_PCU_ISM_DEV10).080923-0837 ) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Types/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Types.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 RedGate.SqlPrompt.Format Assembly Version: 4.0.1.2 Win32 Version: 4.0.1.2 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%204/RedGate.SqlPrompt.Format.DLL OptionsAllOptions0ca961b370534fc5820c6e81160c2174 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 Microsoft.AnalysisServices.Graphing 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.AnalysisServices.Graphing.DLL Microsoft.SqlServerCe.Client Assembly Version: 3.5.0.0 Win32 Version: 3.5.5692.0 CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server%20Compact%20Edition/v3.5/Tools/Microsoft.SqlServerCe.Client.dll tceimvji 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 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.Scripting 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.Scripting.DLL SqlManagerUI Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlManagerUi.DLL Microsoft.SqlServer.Management.SqlStudio.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.SqlStudio.Controls.DLL Microsoft.AnalysisServices Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices/10.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.dll Microsoft.SqlServer.DlgGrid 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.DlgGrid/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.DlgGrid.dll Microsoft.SqlServer.SmoExtended Assembly Version: 10.0.0.0 Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 ) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoExtended/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SmoExtended.dll System.Web Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3082 (QFE.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll Microsoft.SqlServer.Management.Collector Assembly Version: 10.0.0.0 Win32 Version: 10.0.1600.24 ((Katmai_PCU_ISM_DEV10).080923-0837 ) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Collector/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Collector.dll Microsoft.SqlServer.Management.CollectorEnum Assembly Version: 10.0.0.0 Win32 Version: 10.0.1600.24 ((Katmai_PCU_ISM_DEV10).080923-0837 ) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Management.CollectorEnum/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.CollectorEnum.dll AppIdPackageStandard 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/AppIdPackageStandard.DLL ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. / comments

this is a slightly different error but i can at least reproduce it: first, CREATE TABLE test (blah INT) then ctrl+shift+d to refresh cache then type the following: INSERT INTO dbo.test ( blah ) OUT...

0 votes

i'd just like to confirm the special character behaviour change in V4, it did indeed not sinert the matching character if the next character wasn't whitespace/EOL / comments

i'd just like to confirm the special character behaviour change in V4, it did indeed not sinert the matching character if the next character wasn't whitespace/EOL

0 votes

Yes, the ability to switch directions without a recompare is very important to me also, especially when we're comparing busy production servers etc. I Don't see what was wrong with the arrow method but I don't really mind how you chose to do it as long as its there [image] / comments

Yes, the ability to switch directions without a recompare is very important to me also, especially when we're comparing busy production servers etc. I Don't see what was wrong with the arrow method...

0 votes

I'd like to add my voice to requesting this. there's 2 scenarios where i think this would be beneficial, one is for sure a feature request, but the other is arguably a bug: Create a scalar UDF, perform a sync. then, change the scalar UDF to an inline UDF (keeping the same name). sql compare attempts to alter it, but this doesn't work: Cannot perform alter on 'dbo.testes' because it is an incompatible object type. Here, doing an if exists... drop... create would solve the problem (and yes i know it's the most common scenario!) / comments

I'd like to add my voice to requesting this. there's 2 scenarios where i think this would be beneficial, one is for sure a feature request, but the other is arguably a bug: Create a scalar UDF, per...

0 votes

the first RC seems much faster for me also (build 638) / comments

the first RC seems much faster for me also (build 638)

0 votes

me too, early versions of V4 were similar. / comments

me too, early versions of V4 were similar.

0 votes

Sorry if this sounds a little harsh, but... new in this release is the removal of sql refactor and only some of those features put into sql prompt, plus script as alter? / comments

Sorry if this sounds a little harsh, but... new in this release is the removal of sql refactor and only some of those features put into sql prompt, plus script as alter?

0 votes

agree, this is very frustrating! / comments

agree, this is very frustrating!

0 votes

Total activity: 19
Last activity: February 06, 2025 13:20
Member since: February 04, 2025 14:29

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 6