User profile for PaulLach – Support

Activity overview Badges (0) Posts (4) Comments (4)

Activity overview

Latest activity by PaulLach

Unhandled Error When Creating A Stored Proc W/O Naming It

I was creating a stored procedure and had not yet decided on a name and had typed in the following: CREATE PROCEDURE [DSC].[] AS SET NOCOUNT ON; After this, everything I tried to do raised the foll...

1 follower 1 comment 0 votes

Support For 2 Suggestions Raised By Others

Having read through many of the comments that people have already posted, I would like to add my support to the following: 1. Do not popup suggestions when I am typing in a comment!!! If someone w...

1 follower 1 comment 0 votes

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: / comments

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

0 votes

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

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

0 votes

The candidate list also pops-up when typing literal strings (inside single quotes). I would ask that if you get SQL Prompt to recognize when it is inside a comment section you would also teach it to recognize when it is inside a literal string. / comments

The candidate list also pops-up when typing literal strings (inside single quotes). I would ask that if you get SQL Prompt to recognize when it is inside a comment section you would also teach it ...

0 votes

As you work your way to the right of the screen the popup window goes off the screen. I would be happy to send you a screen snapshot as an e-mail attachment, but I am not going to set it up with a url. / comments

As you work your way to the right of the screen the popup window goes off the screen. I would be happy to send you a screen snapshot as an e-mail attachment, but I am not going to set it up with a...

0 votes

Suggestion For Indenting Option

Please consider adding an indenting option that would indent by the number of characters in the keyword that caused the indenting to occur plus 1 (for the trailing space). An example would be: IF ...

1 follower 1 comment 0 votes

Suggestion For From Clause Formatting Option

Please consider offering a formatting option for the FROM section to do the following: - align the word JOIN in all rows - align the word ON in all rows - align the right-most character in the rela...

2 followers 2 comments 0 votes

Total activity: 11
Last activity: February 05, 2025 22:46
Member since: February 05, 2025 09:54

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