Specified argument was out of the range of valid values

• 
  I received this error message as well:
  
  See the end of this message for details on invoking
  just-in-time (JIT) debugging instead of this dialog box.
  
  ************** Exception Text **************
  System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
  Parameter name: ordinalPosition
  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 _43.RemoveFromScript(CaretPosition startPosition, CaretPosition endPosition, 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.1399.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.1399.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.1399.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.1399.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.1399.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.1399.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.1399.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.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.CustomControls
  Assembly Version: 9.0.242.0
  Win32 Version: 9.00.1399.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.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.1399.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.1399.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.1399.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.1399.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

  ---

  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

  ---

  SQLEditors
  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/SQLEditors.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.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

  ---

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

  PaulLach September 11, 2006 12:01

  - 0 +
• 
  Just to add a little more information, it seems that this error occurs when I attempt to backspace or cut all or part of an "END" that is a part of a BEGIN/END pair.
  
  If it is of any help, the log contains the following:
  
  m_SortedDatabases contains 0 databases in RefreshColumnCandidates()
  SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 0
  SqlPromptEngine: Script info before setting script provider
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 0
  ScriptModel: Line count (from script provider) = 0
  ScriptModel: Script length = 0
  ScriptModel: End position (from script provider) = Line: -1; Column: -1
  ScriptModel: Last line length (from lines collection) = -1
  ScriptModel: Caret position: Line: 0; Column: 0
  SqlPromptEngine: Script info after setting script provider
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 0
  ScriptModel: Line count (from script provider) = 1
  ScriptModel: Script length = 0
  ScriptModel: End position (from script provider) = Line: 0; Column: 0
  ScriptModel: Last line length (from lines collection) = -1
  ScriptModel: Caret position: Line: 0; Column: 0
  SqlPromptEngine: Inserting "set ANSI_NULLS ON
  set QUOTED_IDENTIFIER ON
  go
  
  
  ALTER PROCEDURE [QTT].[ESS_SaveObservationImage] @StationID int, @MeasurementIdentifier nvarchar(100),
  @CameraID int, @ImageID int,
  @ObservationDateTimeInUTC datetime, @ReadingImage varbinary(max)
  AS
  SET NOCOUNT ON
  /*=====================================================================================================================
  **
  ** Purpose: To save a single image.
  **
  ** Return value: Always returns 0
  **
  ** Date Author Description
  **

  ---

  ---

  ---

  ** 08/97/06 P. Lach Initial coding
  **
  =====================================================================================================================*/
  DECLARE @ReturnValue int
  
  SET @ReturnValue = 0
  
  -- This stored procedure is just a shell at this point.
  
  -- TO DO: Develop the code for this stored procedure.
  
  RETURN (@ReturnValue)
  
  "
  SqlPromptEngine: Insertion position: Line: 0; Column: 0
  SqlPromptEngine: Requested caret position after insertion: Line: 31; Column: 0
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 0
  ScriptModel: Line count (from script provider) = 32
  ScriptModel: Script length = 0
  ScriptModel: End position (from script provider) = Line: 31; Column: 0
  ScriptModel: Last line length (from lines collection) = -1
  ScriptModel: Caret position: Line: 0; Column: 0
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 31
  ScriptModel: Line count (from script provider) = 32
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 31; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 31; Column: 0
  Building up static candidates for [SSISQL01].[QTT_Maestro]
  Found 44 tables
  Found 1983 candidates in total
  m_SortedDatabases contains 1 databases in RefreshColumnCandidates()
  m_SortedDatabases contains 1 databases in RefreshColumnCandidates()
  m_SortedDatabases contains 0 databases in RefreshColumnCandidates()
  SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 0
  SqlPromptEngine: Script info before setting script provider
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 0
  ScriptModel: Line count (from script provider) = 0
  ScriptModel: Script length = 0
  ScriptModel: End position (from script provider) = Line: -1; Column: -1
  ScriptModel: Last line length (from lines collection) = -1
  ScriptModel: Caret position: Line: 0; Column: 0
  SqlPromptEngine: Script info after setting script provider
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 0
  ScriptModel: Line count (from script provider) = 1
  ScriptModel: Script length = 0
  ScriptModel: End position (from script provider) = Line: 0; Column: 0
  ScriptModel: Last line length (from lines collection) = -1
  ScriptModel: Caret position: Line: 0; Column: 0
  SqlPromptEngine: Inserting "USE [QTT_Maestro]
  GO
  /****** Object: StoredProcedure [QTT].[ESS_SaveObservationsUsingXML] Script Date: 09/11/2006 10:46:06 ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  
  
  
  CREATE PROCEDURE [QTT].[ESS_SaveObservationsUsingXML] @Observations xml, @OutputOptionFlags int = 0
  AS
  SET NOCOUNT ON
  /*=====================================================================================================================
  **
  ** Purpose: To save a set of observations that are in the xml parameter @Observations.
  **
  ** @OutputOptionFlags bit values: 1 = resultset of error counts
  ** 2 = resultset of individual errors
  **
  ** Return value: Always returns 0
  **
  ** Date Author Description
  **

  ---

  ---

  ---

  ** 08/07/06 P. Lach Initial coding
  ** 08/31/06 P. Lach Added concept of StationID_SourceID
  **
  =====================================================================================================================*/
  DECLARE @ReturnValue int, @DocHandle int, @RemoteProcessingUnitID int, @StationID_SourceID int;
  DECLARE @Status_BadReadingIndex int, @Status_BadDate int, @Status_ReadingNotNumeric int;
  DECLARE @Status_UnknownIdentifier int, @Status_InitializingValue int, @Status_LessThanMinimum int;
  DECLARE @Status_GreaterThanMaximum int, @Status_UnexpectedMeasurement int, @Status_ExpectedButNotWanted int;
  DECLARE @Status_UnknownStationID int;
  DECLARE @ShowErrorCounts int, @ShowIndividualErrors int
  DECLARE @Status_DuplicateData int, @Status_ChangedData int, @Status_NewData int;
  DECLARE @MiscData nvarchar(2000);
  
  SET @ReturnValue = 0;
  
  SET @ShowErrorCounts = 1;
  SET @ShowIndividualErrors = 2;
  
  SET @Status_BadReadingIndex = 1;
  SET @Status_BadDate = 2;
  SET @Status_ReadingNotNumeric = 3;
  SET @Status_UnknownIdentifier = 4;
  SET @Status_InitializingValue = 5;
  SET @Status_LessThanMinimum = 6;
  SET @Status_GreaterThanMaximum = 7;
  SET @Status_UnknownStationID = 8;
  SET @Status_UnexpectedMeasurement = 9;
  SET @Status_ExpectedButNotWanted = 10;
  SET @Status_DuplicateData = 101;
  SET @Status_ChangedData = 102;
  SET @Status_NewData = 103;
  
  SET @MiscData = [QTT].[GetMiscData]('StationID_SourceID');
  IF ISNUMERIC(@MiscData) = 1
  BEGIN
  SET @StationID_SourceID = CAST(@MiscData AS int);
  END
  ELSE
  BEGIN
  SET @StationID_SourceID = 0;
  END
  
  
  DECLARE @Work TABLE (RecordID int NOT NULL IDENTITY (1, 1),
  StationID int NULL,
  StationID_SourceID int NULL,
  GroupName nvarchar(50) NULL,
  MeasurementName nvarchar(50) NULL,
  ReadingIndex nvarchar(20) NULL,
  WhenOccurred nvarchar(30) NULL,
  Reading nvarchar(20) NULL,
  PRIMARY KEY CLUSTERED (RecordID)
  );
  
  DECLARE @Work2 TABLE (RecordID int NOT NULL,
  StationID int NULL,
  StationID_SourceID int NULL,
  -- RemoteProcessingUnitID int NULL,
  CollectorIdentifier nvarchar(100) NULL,
  ReadingIndex int NULL,
  WhenOccurred datetime NULL,
  Reading int NULL,
  InputUnitOfMeasureID int NULL,
  NumberOfImpliedDecimalPlaces int NULL,
  MeasurementID int NULL,
  ExpectedMeasurementID int NULL,
  StatusCode int NOT NULL,
  PRIMARY KEY CLUSTERED (RecordID)
  );
  
  DECLARE @Station TABLE (StationID int NOT NULL,
  StationID_SourceID int NOT NULL,
  RemoteProcessingUnitID int NULL,
  PRIMARY KEY CLUSTERED (StationID, StationID_SourceID)
  );
  /*
  ** Import the data in the XML document into the @Work table variable.
  */
  EXEC sp_xml_preparedocument @DocHandle OUTPUT, @Observations;
  
  INSERT INTO @Work (StationID, StationID_SourceID, GroupName, MeasurementName, ReadingIndex, WhenOccurred, Reading)
  SELECT StationID, StationID_SourceID, GroupName, MeasurementName, ReadingIndex, WhenOccurred, Reading
  FROM OPENXML (@DocHandle, '/qtt.ess.station/observations/group/obs', 1)
  WITH (StationID int '../../@stationid',
  StationID_SourceID int '../../@sourceid',
  GroupName nvarchar(50) '../@ID',
  MeasurementName nvarchar(50) '@ID',
  ReadingIndex nvarchar(20) '@index',
  WhenOccurred nvarchar(20) '@timestamp',
  Reading nvarchar(20) '.'
  );
  
  EXEC sp_xml_removedocument @DocHandle;
  /*
  ** Copy the raw data from @Work into @Work2 converting the data as necessary
  ** and setting the status based on how the data looks.
  */
  INSERT INTO @Work2 (RecordID, StationID, StationID_SourceID,
  CollectorIdentifier, ReadingIndex, WhenOccurred, Reading, StatusCode)
  SELECT RecordID, StationID, StationID_SourceID,
  GroupName + '.' + MeasurementName,
  CASE WHEN ISNUMERIC(ReadingIndex) = 1
  THEN CAST(ReadingIndex AS int)
  ELSE (-1)
  END,
  CASE WHEN ISNUMERIC(WhenOccurred) = 1
  THEN DATEADD(ss, CAST(WhenOccurred AS int), '01/01/1970')
  ELSE CAST('01/01/1900' AS datetime)
  END,
  CASE WHEN ISNUMERIC(Reading) = 1
  THEN CAST(Reading AS int)
  ELSE 0
  END,
  CASE WHEN ISNUMERIC(ReadingIndex) = 0
  THEN @Status_BadReadingIndex
  WHEN ISNUMERIC(WhenOccurred) = 0
  THEN @Status_BadDate
  WHEN ISNUMERIC(Reading) = 0
  THEN @Status_ReadingNotNumeric
  ELSE @Status_UnknownIdentifier
  END
  FROM @Work;
  /*
  ** Identify the RemoteProcessingUnitID from the StationID and the StationID_SourceID
  */
  INSERT INTO @Station ([StationID], [StationID_SourceID], [RemoteProcessingUnitID])
  SELECT [StationID], ISNULL([StationID_SourceID], 0), NULL
  FROM @Work2
  GROUP BY [StationID], [StationID_SourceID];
  
  UPDATE @Station
  SET [RemoteProcessingUnitID] = [StationID]
  FROM @Station s INNER JOIN [QTT].[RemoteProcessingUnit] rpu ON rpu.[RemoteProcessingUnitID] = s.[StationID]
  WHERE s.[StationID_SourceID] = @StationID_SourceID;
  
  UPDATE @Station
  SET [RemoteProcessingUnitID] = e.[RemoteProcessingUnitID]
  FROM @Station s INNER JOIN [QTT].[External_RPU] e ON e.[StationID] = s.[StationID]
  AND e.[StationID_SourceID] = s.[StationID_SourceID]
  WHERE s.[StationID_SourceID] <> @StationID_SourceID
  AND s.[RemoteProcessingUnitID] IS NULL;
  
  UPDATE @Work2
  SET [StatusCode] = @Status_UnknownStationID
  FROM @Work2 w INNER JOIN @Station s ON s.[StationID] = w.[StationID]
  AND s.[StationID_SourceID] = w.[StationID_SourceID]
  AND s.[RemoteProcessingUnitID] IS NULL
  /*
  ** Lookup the InputUnitOfMeasureID and MeasurementID using the CollectorIdentifier.
  ** We also set the status to an error condition if the reading is not good or
  ** we set the status to @Status_UnexpectedMeasurement in preparation for the next step.
  */
  UPDATE @Work2
  SET InputUnitOfMeasureID = mci.InputUnitOfMeasureID,
  NumberOfImpliedDecimalPlaces = mci.NumberOfImpliedDecimalPlacesInXML,
  MeasurementID = mci.MeasurementID,
  StatusCode = CASE WHEN w.Reading = mci.[InitializingValue]
  THEN @Status_InitializingValue
  WHEN w.Reading < m.[MinimumValidValue]
  THEN @Status_LessThanMinimum
  WHEN w.reading > m.[MaximumValidValue]
  THEN @Status_GreaterThanMaximum
  ELSE @Status_UnexpectedMeasurement
  END
  FROM @Work2 w INNER JOIN [QTT].[MeasurementCollectorIdentifier] mci ON mci.CollectorIdentifier = w.CollectorIdentifier
  INNER JOIN [QTT].[Measurement] m ON m.[MeasurementID] = mci.[MeasurementID]
  WHERE w.StatusCode = @Status_UnknownIdentifier;
  /*
  ** Lookup the ExpectedMeasurementID using the StationID, the MeasurementID, and the ReadingIndex.
  */
  UPDATE @Work2
  SET ExpectedMeasurementID = em.[ExpectedMeasurementID],
  StatusCode = CASE WHEN em.IsActive = 1
  THEN @Status_NewData
  ELSE @Status_ExpectedButNotWanted
  END
  FROM @Work2 w INNER JOIN @Station s ON s.[StationID] = w.[StationID]
  AND s.[StationID_SourceID] = w.[StationID_SourceID]
  INNER JOIN [QTT].[RemoteProcessingUnit] rpu ON rpu.[RemoteProcessingUnitID] = s.[RemoteProcessingUnitID]
  INNER JOIN [QTT].[RPU_Equipment] e ON e.[RemoteProcessingUnitID] = rpu.[RemoteProcessingUnitID]
  INNER JOIN [QTT].[ExpectedMeasurement] em ON em.[RPU_EquipmentID] = e.[RPU_EquipmentID]
  AND em.[MeasurementID] = w.[MeasurementID]
  AND em.[MeasurementIndex] = w.[ReadingIndex]
  WHERE w.StatusCode = @Status_UnexpectedMeasurement;
  /*
  ** Adjust any readings that are not expressed in the unit of measure we want to store it in or whose number of
  ** implied decimal places is different than what we want to store.
  */
  IF EXISTS ( SELECT w.RecordID
  FROM @Work2 w INNER JOIN [QTT].[Measurement] m ON m.[MeasurementID] = w.[MeasurementID]
  WHERE w.StatusCode = @Status_NewData
  AND (w.InputUnitOfMeasureID <> m.StorageUnitOfMeasureID
  OR w.NumberOfImpliedDecimalPlaces <> m.NumberOfImpliedDecimalPlaces
  )
  )
  BEGIN
  UPDATE @Work2
  SET Reading = QTT.ConvertReading(w.Reading,
  w.InputUnitOfMeasureID, m.StorageUnitOfMeasureID,
  w.NumberOfImpliedDecimalPlaces, m.NumberOfImpliedDecimalPlaces)
  FROM @Work2 w INNER JOIN [QTT].[Measurement] m ON m.[MeasurementID] = w.[MeasurementID]
  WHERE w.StatusCode = @Status_NewData
  AND (w.InputUnitOfMeasureID <> m.StorageUnitOfMeasureID
  OR w.NumberOfImpliedDecimalPlaces <> m.NumberOfImpliedDecimalPlaces
  )
  END
  
  -- SELECT * FROM @Work;
  /*
  ** All datetime values in the xml document are expressed as number of seconds after 01/01/1970 (including the "WhenOccurred"
  ** value that we converted above). We want to store the datetime readings as the number of seconds relative to the WhenObserved"
  ** datetime such that a reading that is before the WhenObserved datetime (which it should be) will be a negative number.
  ** by doing this we can reconstruct the number by using the DATEADD function as follows:
  **
  ** datetime = DATEADD(ss, Reading, WhenObserved)
  */
  IF EXISTS ( SELECT w.RecordID
  FROM @Work2 w INNER JOIN [QTT].[Measurement] m ON m.[MeasurementID] = w.[MeasurementID]
  INNER JOIN [QTT].[UnitOfMeasure] uom ON uom.[UnitOfMeasureID] = m.[StorageUnitOfMeasureID]
  AND uom.[ShortDesc] = 'datetime'
  WHERE w.StatusCode = @Status_NewData
  )
  BEGIN
  UPDATE @Work2
  SET Reading = DATEDIFF(ss, w.WhenOccurred, DATEADD(ss, CAST(w.Reading AS int), '01/01/1970'))
  FROM @Work2 w INNER JOIN [QTT].[Measurement] m ON m.[MeasurementID] = w.[MeasurementID]
  INNER JOIN [QTT].[UnitOfMeasure] uom ON uom.[UnitOfMeasureID] = m.[StorageUnitOfMeasureID]
  AND uom.[ShortDesc] = 'datetime'
  WHERE w.StatusCode = @Status_NewData
  END
  /*
  ** Identify data records that contain data that we already have in the database.
  */
  IF EXISTS ( SELECT w.RecordID
  FROM @Work2 w INNER JOIN [QTT].[Observation] o ON o.[ExpectedMeasurementID] = w.[ExpectedMeasurementID]
  AND o.[WhenObserved] = w.[WhenOccurred]
  WHERE w.StatusCode = @Status_NewData
  AND w.Reading = o.Reading
  )
  BEGIN
  UPDATE @Work2
  SET StatusCode = @Status_DuplicateData
  FROM @Work2 w INNER JOIN [QTT].[Observation] o ON o.[ExpectedMeasurementID] = w.[ExpectedMeasurementID]
  AND o.[WhenObserved] = w.[WhenOccurred]
  WHERE w.StatusCode = @Status_NewData
  AND w.Reading = o.Reading;
  END
  /*
  ** Identify data records that contain data that represents a change from what we already have in the database.
  */
  IF EXISTS ( SELECT w.RecordID
  FROM @Work2 w INNER JOIN [QTT].[Observation] o ON o.[ExpectedMeasurementID] = w.[ExpectedMeasurementID]
  AND o.[WhenObserved] = w.[WhenOccurred]
  WHERE w.StatusCode = @Status_NewData
  AND w.Reading <> o.Reading
  )
  BEGIN
  UPDATE @Work2
  SET StatusCode = @Status_ChangedData
  FROM @Work2 w INNER JOIN [QTT].[Observation] o ON o.[ExpectedMeasurementID] = w.[ExpectedMeasurementID]
  AND o.[WhenObserved] = w.[WhenOccurred]
  WHERE w.StatusCode = @Status_NewData
  AND w.Reading <> o.Reading;
  
  UPDATE [QTT].[Observation]
  SET Reading = w.Reading
  FROM @Work2 w INNER JOIN [QTT].[Observation] o ON o.[ExpectedMeasurementID] = w.[ExpectedMeasurementID]
  AND o.[WhenObserved] = w.[WhenOccurred]
  WHERE w.StatusCode = @Status_ChangedData;
  END
  /*
  ** Add any new data to the Observation table.
  */
  INSERT INTO [QTT].[Observation] (ExpectedMeasurementID, WhenObserved, Reading)
  SELECT [ExpectedMeasurementID], [WhenOccurred], [Reading]
  FROM @Work2
  WHERE StatusCode = @Status_NewData;
  /*
  ** Save audit trail information
  */
  /*
  ** Update any existing XML_ImportAudit records
  */
  IF EXISTS (SELECT a.[RemoteProcessingUnitID]
  FROM @Station s INNER JOIN [QTT].[XML_ImportAudit] a ON a.[StationID] = s.[StationID]
  AND a.[StationID_SourceID] = s.[StationID_SourceID]
  )
  BEGIN
  UPDATE [QTT].[XML_ImportAudit]
  SET [RemoteProcessingUnitID] = s.[RemoteProcessingUnitID],
  [LastImportDate] = CURRENT_TIMESTAMP,
  [HowMany] = a.[HowMany] + 1
  FROM @Station s INNER JOIN [QTT].[XML_ImportAudit] a ON a.[StationID] = s.[StationID]
  AND a.[StationID_SourceID] = s.[StationID_SourceID]
  END
  /*
  ** Add any new XML_ImportAudit records
  */
  IF EXISTS (SELECT s.[StationID]
  FROM @Station s LEFT OUTER JOIN [QTT].[XML_ImportAudit] a ON a.[StationID] = s.[StationID]
  AND a.[StationID_SourceID] = s.[StationID_SourceID]
  WHERE a.[StationID] IS NULL
  )
  BEGIN
  INSERT INTO [QTT].[XML_ImportAudit](StationID, StationID_SourceID, RemoteProcessingUnitID,
  FirstImportDate, LastImportDate, HowMany)
  SELECT s.[StationID], s.[StationID_SourceID], s.[RemoteProcessingUnitID],
  CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 1
  FROM @Station s LEFT OUTER JOIN [QTT].[XML_ImportAudit] a ON a.[StationID] = s.[StationID]
  AND a.[StationID_SourceID] = s.[StationID_SourceID]
  WHERE a.[StationID] IS NULL;
  END
  /*
  ** Delete any existing XML_MostRecentImportErrors for the RPU's for whom we are importing data.
  */
  IF EXISTS (SELECT s.[RemoteProcessingUnitID]
  FROM @Station s INNER JOIN [QTT].[XML_MostRecentImportErrors] ie ON ie.[RemoteProcessingUnitID] = s.[RemoteProcessingUnitID]
  WHERE s.[RemoteProcessingUnitID] IS NOT NULL
  )
  BEGIN
  DELETE FROM [QTT].[XML_MostRecentImportErrors]
  FROM @Station s INNER JOIN [QTT].[XML_MostRecentImportErrors] ie ON ie.[RemoteProcessingUnitID] = s.[RemoteProcessingUnitID]
  WHERE s.[RemoteProcessingUnitID] IS NOT NULL;
  END
  /*
  ** Save any records that have an error condition.
  */
  IF EXISTS (SELECT w.[RecordID]
  FROM @Work2 w2 INNER JOIN @Work w ON w.[RecordID] = w2.[RecordID]
  WHERE w2.[StatusCode] IN (@Status_BadReadingIndex,
  @Status_BadDate,
  @Status_ReadingNotNumeric,
  @Status_UnknownIdentifier,
  @Status_LessThanMinimum,
  @Status_GreaterThanMaximum,
  @Status_UnexpectedMeasurement
  )
  )
  BEGIN
  INSERT INTO [QTT].[XML_MostRecentImportErrors](RemoteProcessingUnitID, RecordID, StationID, StationID_SourceID,
  GroupName, MeasurementName, ReadingIndex, WhenOccurred, Reading,
  StatusCode, StatusText)
  SELECT s.[RemoteProcessingUnitID], w.[RecordID], s.[StationID], s.[StationID_SourceID],
  w.[GroupName], w.[MeasurementName], w.[ReadingIndex], w.[WhenOccurred], w.[Reading], w2.[StatusCode],
  CASE StatusCode WHEN @Status_BadReadingIndex THEN 'Reading index was not numeric'
  WHEN @Status_BadDate THEN 'When observed date was not a date'
  WHEN @Status_ReadingNotNumeric THEN 'Reading was not numeric'
  WHEN @Status_UnknownIdentifier THEN 'Unknown identifier'
  WHEN @Status_InitializingValue THEN 'Reading is the initializing value'
  WHEN @Status_LessThanMinimum THEN 'Reading is less than the minimum allowed'
  WHEN @Status_GreaterThanMaximum THEN 'Reading is greater than the maximum allowed'
  WHEN @Status_UnknownStationID THEN 'Unknown station ID (RPU ID)'
  WHEN @Status_UnexpectedMeasurement THEN 'Unexpected measurement'
  WHEN @Status_ExpectedButNotWanted THEN 'Expected but not wanted'
  WHEN @Status_DuplicateData THEN 'Duplicate data'
  WHEN @Status_ChangedData THEN 'Changed data'
  WHEN @Status_NewData THEN 'New data'
  ELSE 'Unknown status'
  END
  FROM @Work2 w2 INNER JOIN @Work w ON w.[RecordID] = w2.[RecordID]
  INNER JOIN @Station s ON s.[StationID] = w2.[StationID]
  AND s.[StationID_SourceID] = w2.[StationID_SourceID]
  
  WHERE w2.[StatusCode] IN (@Status_BadReadingIndex,
  @Status_BadDate,
  @Status_ReadingNotNumeric,
  @Status_UnknownIdentifier,
  @Status_LessThanMinimum,
  @Status_GreaterThanMaximum,
  @Status_UnexpectedMeasurement
  );
  END
  /*
  ** Diagnostic output
  */
  IF @OutputOptionFlags & @ShowErrorCounts > 0
  BEGIN
  SELECT RIGHT(SPACE(10) + CAST(COUNT(RecordID) AS varchar), 10) AS [How Many],
  StatusCode,
  CASE StatusCode WHEN @Status_BadReadingIndex THEN 'Reading index was not numeric'
  WHEN @Status_BadDate THEN 'When observed date was not a date'
  WHEN @Status_ReadingNotNumeric THEN 'Reading was not numeric'
  WHEN @Status_UnknownIdentifier THEN 'Unknown identifier'
  WHEN @Status_InitializingValue THEN 'Reading is the initializing value'
  WHEN @Status_LessThanMinimum THEN 'Reading is less than the minimum allowed'
  WHEN @Status_GreaterThanMaximum THEN 'Reading is greater than the maximum allowed'
  WHEN @Status_UnknownStationID THEN 'Unknown station ID (RPU ID)'
  WHEN @Status_UnexpectedMeasurement THEN 'Unexpected measurement'
  WHEN @Status_ExpectedButNotWanted THEN 'Expected but not wanted'
  WHEN @Status_DuplicateData THEN 'Duplicate data'
  WHEN @Status_ChangedData THEN 'Changed data'
  WHEN @Status_NewData THEN 'New data'
  ELSE 'Unknown status'
  END AS [Status]
  FROM @Work2
  GROUP BY StatusCode;
  END
  
  IF @OutputOptionFlags & @ShowIndividualErrors > 0
  BEGIN
  SELECT ie.[RemoteProcessingUnitID], ie.[RecordID], ie.[StationID], ie.[StationID_SourceID], ie.[GroupName],
  ie.[MeasurementName], ie.[ReadingIndex], ie.[WhenOccurred], ie.[Reading], ie.[StatusCode]
  FROM @Station s INNER JOIN [QTT].[XML_MostRecentImportErrors] ie ON ie.[RemoteProcessingUnitID] = s.[RemoteProcessingUnitID]
  ORDER BY ie.[RemoteProcessingUnitID], ie.[RecordID]
  END
  
  RETURN (@ReturnValue);
  
  
  
  
  
  
  
  "
  SqlPromptEngine: Insertion position: Line: 0; Column: 0
  SqlPromptEngine: Requested caret position after insertion: Line: 438; Column: 0
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 0
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 0
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = -1
  ScriptModel: Caret position: Line: 0; Column: 0
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 438; Column: 0
  m_SortedDatabases contains 1 databases in RefreshColumnCandidates()
  m_SortedDatabases contains 1 databases in RefreshColumnCandidates()
  SqlPromptEngine: Setting caret position to: Line: 80; Column: 42
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 438; Column: 0
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 42
  SqlPromptEngine: Replacing text between Line: 80; Column: 24 and Line: 80; Column: 42.
  SqlPromptEngine: Replacement text: "f"
  SqlPromptEngine: Requested caret position after replacement: Line: 80; Column: 25
  SqlPromptEngine: Script info before replacement
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 42
  SqlPromptEngine: Script info after replacement
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24572
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 25
  SqlPromptEngine: Setting caret position to: Line: 80; Column: 25
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24572
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 25
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24572
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 25
  SqlPromptEngine: Replacing text between Line: 80; Column: 24 and Line: 80; Column: 25.
  SqlPromptEngine: Replacement text: "StationID_SourceID"
  SqlPromptEngine: Requested caret position after replacement: Line: 80; Column: 42
  SqlPromptEngine: Script info before replacement
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24572
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 25
  SqlPromptEngine: Script info after replacement
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 42
  SqlPromptEngine: Setting caret position to: Line: 80; Column: 42
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 42
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 42
  SqlPromptEngine: Setting caret position to: Line: 92; Column: 7
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 80; Column: 42
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 92; Column: 7
  SqlPromptEngine: Setting caret position to: Line: 56; Column: 0
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 92; Column: 7
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 56; Column: 0
  SqlPromptEngine: Setting caret position to: Line: 65; Column: 0
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 56; Column: 0
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 65; Column: 0
  SqlPromptEngine: Setting caret position to: Line: 24; Column: 2
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 31
  ScriptModel: Line count (from script provider) = 32
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 31; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 31; Column: 0
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 31
  ScriptModel: Line count (from script provider) = 32
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 31; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 24; Column: 2
  SqlPromptEngine: Setting caret position to: Line: 24; Column: 0
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 31
  ScriptModel: Line count (from script provider) = 32
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 31; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 24; Column: 2
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 31
  ScriptModel: Line count (from script provider) = 32
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 31; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 24; Column: 0
  SqlPromptEngine: Removing script between Line: 24; Column: 0 and Line: 24; Column: 2.
  SqlPromptEngine: Requested caret position after removal: Line: 24; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 31
  ScriptModel: Line count (from script provider) = 32
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 31; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 24; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 31
  ScriptModel: Line count (from script provider) = 32
  ScriptModel: Script length = 1110
  ScriptModel: End position (from script provider) = Line: 31; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 24; Column: 0
  SqlPromptEngine: Inserting "
  "
  SqlPromptEngine: Insertion position: Line: 24; Column: 0
  SqlPromptEngine: Requested caret position after insertion: Line: 25; Column: 0
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 31
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1110
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 24; Column: 0
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 0
  SqlPromptEngine: Setting caret position to: Line: 25; Column: 0
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 0
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 0
  SqlPromptEngine: Inserting "Joe Cullen"
  SqlPromptEngine: Insertion position: Line: 25; Column: 0
  SqlPromptEngine: Requested caret position after insertion: Line: 25; Column: 10
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 0
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1122
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 10
  SqlPromptEngine: Setting caret position to: Line: 25; Column: 10
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1122
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 10
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1122
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 10
  SqlPromptEngine: Removing script between Line: 25; Column: 0 and Line: 25; Column: 10.
  SqlPromptEngine: Requested caret position after removal: Line: 25; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1122
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 10
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 0
  SqlPromptEngine: Setting caret position to: Line: 25; Column: 0
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 0
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 32
  ScriptModel: Line count (from script provider) = 33
  ScriptModel: Script length = 1112
  ScriptModel: End position (from script provider) = Line: 32; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 25; Column: 0
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 64; Column: 5
  SqlPromptEngine: Requested caret position after insertion: Line: 64; Column: 6
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24589
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 65; Column: 0
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24590
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 64; Column: 6
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 63; Column: 10
  SqlPromptEngine: Requested caret position after insertion: Line: 63; Column: 11
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24590
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 64; Column: 6
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24591
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 63; Column: 11
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 62; Column: 5
  SqlPromptEngine: Requested caret position after insertion: Line: 62; Column: 6
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24591
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 63; Column: 11
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24592
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 62; Column: 6
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 61; Column: 2
  SqlPromptEngine: Requested caret position after insertion: Line: 61; Column: 3
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24592
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 62; Column: 6
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24593
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 61; Column: 3
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 60; Column: 5
  SqlPromptEngine: Requested caret position after insertion: Line: 60; Column: 6
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24593
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 61; Column: 3
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24594
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 60; Column: 6
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 59; Column: 10
  SqlPromptEngine: Requested caret position after insertion: Line: 59; Column: 11
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24594
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 60; Column: 6
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24595
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 59; Column: 11
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 58; Column: 5
  SqlPromptEngine: Requested caret position after insertion: Line: 58; Column: 6
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24595
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 59; Column: 11
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24596
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 58; Column: 6
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 57; Column: 2
  SqlPromptEngine: Requested caret position after insertion: Line: 57; Column: 3
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24596
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 58; Column: 6
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24597
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 57; Column: 3
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 56; Column: 2
  SqlPromptEngine: Requested caret position after insertion: Line: 56; Column: 3
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24597
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 57; Column: 3
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24598
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 56; Column: 3
  SqlPromptEngine: Inserting " "
  SqlPromptEngine: Insertion position: Line: 55; Column: 0
  SqlPromptEngine: Requested caret position after insertion: Line: 55; Column: 1
  SqlPromptEngine: Script info before insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24598
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 56; Column: 3
  SqlPromptEngine: Script info after insertion
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24599
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 55; Column: 1
  SqlPromptEngine: Setting caret position to: Line: 55; Column: 0
  SqlPromptEngine: Script info before setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24599
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 55; Column: 1
  SqlPromptEngine: Script info after setting caret position
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24599
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 55; Column: 0
  SqlPromptEngine: Removing script between Line: 64; Column: 0 and Line: 64; Column: 1.
  SqlPromptEngine: Requested caret position after removal: Line: 64; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24599
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 55; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24598
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 64; Column: 0
  SqlPromptEngine: Removing script between Line: 63; Column: 0 and Line: 63; Column: 1.
  SqlPromptEngine: Requested caret position after removal: Line: 63; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24598
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 64; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24597
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 63; Column: 0
  SqlPromptEngine: Removing script between Line: 62; Column: 0 and Line: 62; Column: 1.
  SqlPromptEngine: Requested caret position after removal: Line: 62; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24597
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 63; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24596
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 62; Column: 0
  SqlPromptEngine: Removing script between Line: 61; Column: 0 and Line: 61; Column: 1.
  SqlPromptEngine: Requested caret position after removal: Line: 61; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24596
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 62; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24595
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 61; Column: 0
  SqlPromptEngine: Removing script between Line: 60; Column: 0 and Line: 60; Column: 1.
  SqlPromptEngine: Requested caret position after removal: Line: 60; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24595
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 61; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24594
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 60; Column: 0
  SqlPromptEngine: Removing script between Line: 59; Column: 0 and Line: 59; Column: 1.
  SqlPromptEngine: Requested caret position after removal: Line: 59; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24594
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 60; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24593
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 59; Column: 0
  SqlPromptEngine: Removing script between Line: 58; Column: 0 and Line: 58; Column: 1.
  SqlPromptEngine: Requested caret position after removal: Line: 58; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24593
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 59; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24592
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 58; Column: 0
  SqlPromptEngine: Removing script between Line: 57; Column: 0 and Line: 57; Column: 1.
  SqlPromptEngine: Requested caret position after removal: Line: 57; Column: 0
  SqlPromptEngine: Script info before removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24592
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 58; Column: 0
  SqlPromptEngine: Script info after removal
  ScriptModel: Current script information
  ScriptModel: Line count (from lines collection) = 438
  ScriptModel: Line count (from script provider) = 439
  ScriptModel: Script length = 24591
  ScriptModel: End position (from script provider) = Line: 438; Column: 0
  ScriptModel: Last line length (from lines collection) = 2
  ScriptModel: Caret position: Line: 57; Column:

  PaulLach September 11, 2006 12:12

  - 0 +

Add comment

Please sign in to leave a comment.