What's the code that generates this? If the consequence of this is that you're not locking a row when you thought you were then you might end up with nasty race conditions or something further down the line.
I suspect that it is this query that generates the complaint.
SELECT TOP 1 [DataSetInfo].DataSetID FROM [DataSetInfo] INNER JOIN
DataTables ON DataSetInfo.DataSetID = DataTables.DataSetID WHERE
([DataSetInfo].[DataSetID] = 386) AND
(([DataTables].JobReferenceNumber = 1223))
I suspect that it is this query that generates the complaint.
SELECT TOP 1 [DataSetInfo].DataSetID FROM [DataSetInfo] INNER JOIN
DataTables ON DataSetInfo.DataSetID = DataTables.DataSetID WHERE
([DataSetInfo].[DataSetID] = 386) AND
(([DataTables].JobReferenceNumber = 1223))
Wes
In addition, it appears that the following options are present when
these queries are executed: