When you run the sp that is logged by profiler it fails due to the double quotes.

In SQL 2000 though no double quotes show up? only single quotes as it...

set ANSI_NULLS ON

set QUOTED_IDENTIFIER OFF

go

ALTER PROCEDURE [dbo].[OCRCMGetInvalidProductId]

(

@ProductId varchar(4000)='',

@StartDt datetime,

@EndDt datetime,

@StoreId varchar(36),

@output varchar(8000) output

)

AS

IF(LEN(@ProductId) > 0)

SELECT @output = coalesce(@output + ',' , '') + col

FROM

(

SELECT DISTINCT...

Phil,

We do have some activity on the destination DB during that time however, we are unable to isolate or stop users from accessing the DB during that time.

Would there be...

I had the exact same error... restarting SQl Server Agent fixed the issue.

FYI

🙂