Hi Frankie

I think this issue has been resolved. One of the tables used in the stored proc didnt have a clustered index on it. Adding a clustered index...

Thanks to everyone who has replied to my question. To answer some of the questions that have been raised:

- The default database isolation level is set to Read Committed

-...

Hi

The WITH (NOLOCK) hint isn't being used in the SELECT statement.

Regards

Mark