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

Bug with Formatting Sql containing Comments

I have a .sql text file that contains a simple SQL statement where I have commented out a portion of the where clause.

I open the .sql file in Mgt Studio and choose "Lay Out Sql". I then get the error listed below.

There are 27 lines in the .sql file, but if you remove the commented line, there are 26. I'm guessing this is the 26 mentioned in the error.

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

************** Exception Text **************
System.ArgumentOutOfRangeException: Invalid 0-based line index: 26. The following error was reported:

Invalid line index: 26.
Parameter name: lineIndex
Actual value was 26. ---> System.ArgumentOutOfRangeException: Invalid line index: 26.
Parameter name: lineIndex
Actual value was 26.
   at _40._1(Int32 , Int32 , _39 )
   at _40._1(Int32 )
   at _40._2(Int32 )
   --- End of inner exception stack trace ---
   at _40._2(Int32 )
   at _40._1(CaretPosition , Boolean )
   at _24..ctor(_40 lines, IScriptProvider provider, CaretPosition current, CaretPosition statementBegin, CaretPosition nextStatement)
   at _24..ctor(_40 lines, IScriptProvider provider, CaretPosition current, CaretPosition statementBegin)
   at _24..ctor(_40 lines, IScriptProvider provider, CaretPosition current)
   at _43.set_CaretPosition(CaretPosition value)
   at _43.InsertIntoScript(String fragment, CaretPosition insertionPosition, CaretPosition caretPosition)
   at _43.ReplaceInScript(String fragment, CaretPosition startInsertionPosition, CaretPosition endInsertionPosition, CaretPosition caretPosition)
   at RedGate.SqlPrompt.Engine.SqlPromptEngine.ReplaceInScript(String fragment, CaretPosition startInsertionPosition, CaretPosition endInsertionPosition, CaretPosition caretPosition)
   at _12.OnChangeLineText(TextLineChange[] pTextLineChange, Int32 fLast)


************** 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
----------------------------------------
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
----------------------------------------
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.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.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
----------------------------------------
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
----------------------------------------
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
----------------------------------------
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.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.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.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
----------------------------------------
RedGate.SQLCompare.ASTParser
    Assembly Version: 5.7.0.430
    Win32 Version: 5.7.0.430
    CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Refactor/RedGate.SQLCompare.ASTParser.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.
rjpaulsen
0

Comments

3 comments

Sort by
  • JonathanWatts
    Hi there,

    Thanks for your feedback. Unfortunately it looks like SQL Prompt has reacted badly to the SQL Refactor Lay out. If it is possible can you email the script that you were refactoring at the time to jonathan dot watts at red-gate dot com?

    Regards,

    Jonathan
    JonathanWatts
    0
  • rjpaulsen
    This is the contents of the file I was dealing with. If I paste the following into a new query window in Sql Mgt I get the same error as soon as I do the paste.

    If I un-comment the comment in the WHERE clause and then paste the query it works just fine. Definatly has something to do with the comment.

    If I mess up the formatting, then choose "Lay Out Sql" the formatting is correct, and then I get the error again.

    If I delete the "--" while in Sql Mgt then all is well. Add the comment back by typing "--" and the error pops up again.

    I had previously posted about how the missing CR/LF causes errors with comments.

    Get me your email and I can send you the original file if you want it.
    DECLARE @DATEA DateTime ;
SET @DATEA = '7/01/2006'
-- DECLARE @DATEB DateTime ;
-- SET @DATEB = '8/01/2006'

USE SiteSecurity_Secure

SELECT  dbo.OrganizationClasses.OrgClassCode,
        o.OrgName,
        COUNT(s.SearchID) AS CountOfSearchID
FROM    dbo.BatchLog b WITH ( nolock ) 
        INNER JOIN dbo.SearchLog s WITH ( nolock ) ON b.BatchID = s.BatchID 
        INNER JOIN dbo.SearchItems si WITH ( nolock ) ON s.SearchID = si.SearchID 
        INNER JOIN dbo.Organizations o WITH ( nolock ) ON b.OrgID = o.OrgID 
        INNER JOIN dbo.Organization_To_OrganizationClass WITH ( nolock ) ON o.OrgID = dbo.Organization_To_OrganizationClass.OrgID
        INNER JOIN dbo.OrganizationClasses WITH ( nolock ) ON dbo.Organization_To_OrganizationClass.OrgClassID = dbo.OrganizationClasses.OrgClassID
WHERE   s.SearchLogStatus <> 'E'
        AND b.BatchStatus <> 'E'
        AND ( si.ItemTypeID = 2 )
        -- AND ( b.CreateDate < @DATEB )
        AND ( b.CreateDate >= @DATEA )
GROUP BY
        dbo.OrganizationClasses.OrgClassCode,
        o.OrgName
ORDER BY
        dbo.OrganizationClasses.OrgClassCode,
        o.OrgName
    rjpaulsen
    0
  • rjpaulsen
    1. Open the original Sql.

    2. Choose "Lay Out Sql"

    3. Get lineIndex exception, click contine.

    4. Comment out USE statement.

    5. Choose "Lay Out Sql"

    6. Get lineIndex exception, click contine.

    7. Remove "--"

    8. Choose "Lay Out Sql", No Error

    9. Un-Comment USE statement

    10. Choose "Lay Out Sql", No Error

    11. Put "--" back.

    12. Choose "Lay Out Sql", No Error

    In the end I have the same Sql statements, except there is no error. The only text I add/remove is the comment lines before the USE statement and in the WHERE clause.

    After running the first "Lay Out Sql" I get this:
    LINE 1: USE SiteSecurity_Secure
LINE 2: 
LINE 3: SELECT  dbo.OrganizationClasses.OrgClassCode, [+ rest of the file, Including entire WHERE clase]

    After going through the above procedure I get this:
    LINE 1: USE SiteSecurity_Secure
LINE 2: 
LINE 3: SELECT  dbo.OrganizationClasses.OrgClassCode, [+ rest of file, up to the comment in the WHERE clause
LINE 4:         -- AND ( b.CreateDate < @DATEB ) [+ remainder of file]
    rjpaulsen
    0

Add comment

Please sign in to leave a comment.