McSQL (3/25/2013)
You can try disabling page locks for the index your query is using maybe and then try the UPDLOCK clause to make sure the row still gets locked;ALTER INDEX <INDEX_NAME>
SET (
ALLOW_PAGE_LOCKS = OFF
)
GO
I would recommend not touching the locking hints on tables (allow page locks, allow row locks or lock escalation) as they can have some side effects including various operations failing, SQL running out of lock memory or even more serious problems than that. There are very few good reasons to change the locking options on indexes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability