Actually, after looking through my code, I found the problem - it looks like I overlooked a piece of code that actually does a number of updates and and potential...

Here are some of the examples of the delete functions:

#1

Execution Tree

--------------

Clustered Index Delete(OBJECT[Advance].[dbo].[!! SQL !!$Work Order Material].[!! SQL !!$Work Order Material$0]), WHERE

Unfortuantely I can't post the routine - it written in the Navision database language (a subset of pascal) and it does the sql formatting itself. It's basically a routine...

Build # is:

Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)

I have two separate machines, but using the same windows user name firing off the task.