Hi,

I checked the traces I have, and the two statements are the only ones listed with those transactionid's so I assume there are no other statements within the transactions.

Would this...

Hi,

here is the code for the two procedures, they are quite simple.

CREATE PROCEDURE [dbo].[LGNCC_EVP_UpdateStatus]

(

@aObjectID VARCHAR(255),

@aEventType NUMERIC(2),

@aOperation NUMERIC(2),

@aOldStatus NUMERIC(1),

@aNewStatus NUMERIC(1),

@aAttempts NUMERIC(3),

@aModifiedBy VARCHAR(100)

)

AS

BEGIN

UPDATE LGNCC_PUBLISHEDEVENT SET Status = @aNewStatus, Attempts = @aAttempts,

LastModifiedBy =...

All,

There is no differences, I process it once it gets 1.1 million records, as soon as it finished I process it again I get 1.4 million records, then I process...

All,

Just replicated on a SQL Server 2005 SP2 system, could not replicate it on SP4.

Thanks

Ronnie

Hi,

I tried to replicate this issue on one of our internal servers so I created a new database with the collation set to SQL_LATAN1_GENERAL_CP1_CI_AS but could not replicate it.

So...

Thanks,

I will ask the customer DBA to do that.

Ronnie

No its a table:

CREATE TABLE [dbo].[IMPORTINSTVERSION](

[INSTANCEID] [numeric](18, 0) NOT NULL,

[IMPORTNAME] [varchar](50) NOT NULL,

[IMPORTBUNDLEID] [numeric](18, 0) NOT NULL

)

The procedure does not generate the exceptions on other customer databases, just with one...

Here is a copy of the code:

CREATE PROCEDURE [dbo].[GetImptInstByNameID]

@aImportNameVARCHAR(100),

@aInstanceIDNUMERIC(18),

@aId NUMERIC(18) OUTPUT

AS

SET @aId = -1

BEGIN

SELECT @aId = IMPORTBUNDLEID

FROM IMPORTINSTVERSION

WHERE IMPORTNAME = @aImportName

AND INSTANCEID = @aInstanceID

END

There is no cursor.

Thanks

Ronnie

Hi,

We will investigate the queue length.

Thanks

Ronnie

Hi,

I analyze the traces using the RML Utility, and we have a standard trace template we use for our application. It is just this is the first time these statements...