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

Exception: ' ' is an invalid name.

I got this after I deleted a line from my query and then pressed the up arrow several times.

The line I deleted is the line that starts with "LEFT OUTER JOIN CCH.dbo.APP_COL" in the first half of the IF statement.

I deleted the line by placing cursor in col-0 of the above mentioned line, then pressing down arrow+shift, then delete.
See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ArgumentOutOfRangeException: The supplied name must contain a non-empty object name. '           ' is an invalid name.
Parameter name: name
   at RedGate.Util.EventHandlerSet.Fire(Object eventKey, Object sender, EventArgs args)
   at RedGate.Util.EventHandlerSet._1.Fire(Object eventKey, Object sender, EventArgs args)
   at _43._1(CaretPosition , CaretPosition )
   at _43.set_CaretPosition(CaretPosition value)
   at RedGate.SqlPrompt.Engine.SqlPromptEngine.set_CaretPosition(CaretPosition value)
   at _12._4(Object , EventArgs )
   at _10.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.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AppIDPackage
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.SqlServer.SqlTools.VSIntegration
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.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
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.SqlServer.SqlTDiagM
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
----------------------------------------
Microsoft.DataWarehouse.SQM
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
----------------------------------------
Microsoft.SqlServer.Instapi
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
----------------------------------------
RedGate.Refactoring.AddIn
    Assembly Version: 1.0.0.604
    Win32 Version: 1.0.0.604
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor/RedGate.Refactoring.AddIn.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.42 (RTM.050727-4200)
    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.0.4054
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.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
----------------------------------------
SqlWorkbench.Interfaces
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
----------------------------------------
RedGate.SQLCompare.Engine
    Assembly Version: 5.7.0.430
    Win32 Version: 5.7.0.430
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor/RedGate.SQLCompare.Engine.DLL
----------------------------------------
ActiproSoftware.Wizard.Net20
    Assembly Version: 3.0.121.0
    Win32 Version: 3.0.121.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor/ActiproSoftware.Wizard.Net20.DLL
----------------------------------------
RedGate.SQLCompare.Rewriter
    Assembly Version: 5.7.0.430
    Win32 Version: 5.7.0.430
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor/RedGate.SQLCompare.Rewriter.DLL
----------------------------------------
ObjectExplorer
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
----------------------------------------
ConnectionDlg
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
----------------------------------------
SqlMgmt
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
----------------------------------------
Microsoft.SqlServer.RegSvrEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
----------------------------------------
RedGate.SQLPrompt.SSMSUI
    Assembly Version: 3.0.0.300
    Win32 Version: 3.0.0.300
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLPrompt.SSMSUI.dll
----------------------------------------
RedGate.SQLPrompt.CommonUI
    Assembly Version: 3.0.0.300
    Win32 Version: 3.0.0.300
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLPrompt.CommonUI.DLL
----------------------------------------
RedGate.SQL.Shared
    Assembly Version: 5.3.0.1
    Win32 Version: 5.3.0.1
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQL.Shared.DLL
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
RedGate.SqlPrompt.Engine.Gatekeeper
    Assembly Version: 3.0.0.300
    Win32 Version: 3.0.0.300
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SqlPrompt.Engine.Gatekeeper.DLL
----------------------------------------
RedGate.SqlPrompt.Engine
    Assembly Version: 3.0.0.300
    Win32 Version: 3.0.0.300
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SqlPrompt.Engine.DLL
----------------------------------------
RedGate.SQLCompare.Engine
    Assembly Version: 5.3.0.13
    Win32 Version: 5.3.0.13
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLCompare.Engine.DLL
----------------------------------------
RedGate.Shared.Utils
    Assembly Version: 5.3.0.1
    Win32 Version: 5.3.0.1
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.Shared.Utils.DLL
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Management
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Microsoft.SqlServer.ConnectionInfo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
----------------------------------------
Microsoft.SqlServer.SmoEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    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.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Microsoft.SqlServer.Smo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
Microsoft.SqlServer.SqlEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll
----------------------------------------
Microsoft.SqlServer.BatchParser
    Assembly Version: 9.0.242.0
    Win32 Version: 2005.090.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.BatchParser/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll
----------------------------------------
msvcm80
    Assembly Version: 8.0.50608.0
    Win32 Version: 8.00.50727.42
    CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd/msvcm80.dll
----------------------------------------
ObjectExplorerReplication
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorerReplication.DLL
----------------------------------------
SQLEditors
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL
----------------------------------------
SqlManagerUI
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlManagerUi.DLL
----------------------------------------
Microsoft.AnalysisServices
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.dll
----------------------------------------
Microsoft.SqlServer.CustomControls
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.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.SqlServer.DlgGrid
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DlgGrid/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DlgGrid.dll
----------------------------------------
Microsoft.SqlServer.GridControl
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1399.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.GridControl/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.GridControl.dll
----------------------------------------
System.Web
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
RedGate.SQLCompare.ASTParser
    Assembly Version: 3.0.0.300
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLCompare.ASTParser.DLL
----------------------------------------
Microsoft.VisualStudio.Shell
    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/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
----------------------------------------
Microsoft.VisualStudio.Package.LanguageService
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Package.LanguageService/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Package.LanguageService.dll
----------------------------------------
Microsoft.SqlServerCe.Client
    Assembly Version: 9.0.242.0
    Win32 Version: 3.0.5207.0
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServerCe.Client.DLL
----------------------------------------
Microsoft.SqlServer.DataStorage
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.2047.00
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DataStorage/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DataStorage.dll
----------------------------------------
Microsoft.VisualStudio.DataTools.Interop
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.DataTools.Interop.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%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.Data.Interop.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%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.Data.DLL
----------------------------------------
Microsoft.VisualStudio.DataTools
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.DataTools.DLL
----------------------------------------
Microsoft.Data.ConnectionUI.Dialog
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.Data.ConnectionUI.Dialog.DLL
----------------------------------------
Microsoft.Data.ConnectionUI
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.Data.ConnectionUI.DLL
----------------------------------------
System.Data.OracleClient
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data.OracleClient/2.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
----------------------------------------
System.Security
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.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.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.VisualStudio.vspSmoEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1314.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.vspSmoEnum.DLL
----------------------------------------
Microsoft.VisualStudio.vspConnectionInfo
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1314.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.vspConnectionInfo.DLL
----------------------------------------
Microsoft.VisualStudio.vspSqlEnum
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1314.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.vspSqlEnum.DLL
----------------------------------------
Microsoft.VisualStudio.vspBatchParser
    Assembly Version: 9.0.242.0
    Win32 Version: 2005.090.1314.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.vspBatchParser.DLL
----------------------------------------
Microsoft.VisualStudio.vspGridControl
    Assembly Version: 9.0.242.0
    Win32 Version: 9.00.1314.00
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.VisualStudio.vspGridControl.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
----------------------------------------
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
----------------------------------------
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.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Microsoft.VisualStudio.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.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
----------------------------------------

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



ALTER PROCEDURE [dbo].[Reference_CodeTables_Listing]
    @AdminMode int

AS

    IF (@AdminMode=0)
    BEGIN
	    SELECT  ref_tbl.LookupID,
			    TBL.TBL_COD,
                COL.COL_COD,
                TBL.TBL_TXT,
                COL.COL_TXT,
			    1 AS IsAssigned,
			    ref_tbl.OriginSystem,
               APP_COL.DES_TXT
        FROM    Reference_CodeTables ref_tbl
                    INNER JOIN CCH.dbo.TBL TBL ON ref_tbl.TBL_COD = TBL.TBL_COD
					    INNER JOIN CCH.dbo.COL COL ON TBL.TBL_IDN = COL.TBL_IDN AND ref_tbl.COL_COD = COL.COL_COD

                    LEFT OUTER JOIN CCH.dbo.APP_COL APP_COL ON APP_COL.NAM_COD = ref_tbl.COL_COD AND APP_COL.LOC_TXT = ref_tbl.TBL_COD

        WHERE   IsVisible = 1
        ORDER BY
                TBL.TBL_COD, 
                TBL.TBL_TXT,
                COL.COL_TXT
    	
    END
    ELSE
    BEGIN
        SELECT  CASE WHEN ref_tbl.LookupID IS NOT NULL THEN 
                       ref_tbl.LookupID ELSE 0 END AS LookupID,
                TBL.TBL_COD,
                COL.COL_COD,
                TBL.TBL_TXT,
                COL.COL_TXT,
                CASE WHEN ref_tbl.LookupID IS NOT NULL THEN 1 ELSE 0 END AS IsAssigned,
                CASE WHEN ref_tbl.OriginSystem IS NOT NULL THEN 
	            ref_tbl.OriginSystem  ELSE 'AllSystems' END AS OriginSystem,
                DES_TXT
        FROM    CCH.dbo.TBL TBL 
                        INNER JOIN CCH.dbo.COL COL ON TBL.TBL_IDN = COL.TBL_IDN 
                            LEFT OUTER JOIN Reference_CodeTables ref_tbl ON ref_tbl.TBL_COD = TBL.TBL_COD AND ref_tbl.COL_COD = COL.COL_COD

                    LEFT OUTER JOIN CCH.dbo.APP_COL APP_COL ON APP_COL.NAM_COD = ref_tbl.COL_COD AND APP_COL.LOC_TXT = ref_tbl.TBL_COD
        ORDER BY
                TBL.TBL_COD, 
                TBL.TBL_TXT,
                COL.COL_TXT
    END
rjpaulsen
0

Comments

1 comment

Sort by
  • Bart Read
    Thanks very much for this. We'll have a look and see if we can reproduce it. I suspect I may already have fixed this earlier in the week as we'd found a similar issue here.
    Cheers,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.