No, that's it....you answered my question. Thanks

So, this operation occurs when a SQL statement is using the tempdb to process a result set?

I got it to work! I tried it with a static CREATE TABLE statement for the temp table. It looks like the dynamic SQL has a problem generating...

I tried it with a static table and got the same error.

the funny thing is that it was working when using a global temp table, but it would only work for 1 concurrent user. But when I changed it to...

Sorry...

CREATE PROCEDURE dbo.sp_saAccountAging

@AsOfDate datetime,

@CampusID int,

@TermID int = 0,

@StatusIDs varchar(1000),

@ProgramIDs varchar(1000)

AS

Set NoCount On

-- Get the options for the where clause

Declare @WhereClause varchar(1000)

Declare @SQL varchar(2000)

--Select @WhereClause = rtrim(WhereClause)

--...

Here it is. The name of the temp table is #SaAging.

Just to be sure I have it clear, you're saying that the rows are deleted due to a prior command, such as one that invokes a cascade delete with a...

1. We are replicating the stored proc call.

2. Correct. The delete works at the publisher, and when it tries the replicated command at the subscriber, it finds...

Do you really think it's a bottleck? I don't see how a bottleneck could cause the 'row not found at the subscriber' error (unless the error message is misleading)....

These are pretty good sized machines; a Compaq cluster, each server with 8GB RAM. They are connected to a RAID box with 36 drives in RAID 10. It's...

My mistake....the correct error # is 20578.

We are also getting a 20598 error that states "The row was not found at the Subscriber when applying the replicated command."

OK.....I found the answer....the only locks being kept are Schema Stability locks, which don't interfere with other users. So the nolock hint is working.....thanks guys for the info...

There is no UPDATE, DELETE, or INSERT statements. It's a rather simple stored proc, which is why this is so mystifying....

Here is the code:

CREATE PROCEDURE dbo.sp_SaGetFundSourceGLAccount

@SaTransID int,

@Type char(1)

AS

Set...

My question was that I have 2 tables that are being right outer joined in a query. Can I get this join to run as a nested loop? ...