USE [IMGDBUAT]

GO

/****** Object: Table [FYIADM].[FYI_MONITOR] Script Date: 06/01/2010 11:01:18 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [FYIADM].[FYI_MONITOR](

[FYI_RKEY] [int] NOT NULL,

[FYI_SERVICE_TYPE] [varchar](32) NOT NULL,

[FYI_SERVICE_SUBTYP] [varchar](255) NULL,

[FYI_PRIORITY]...

also currently the table has 78 rows.

here is from the log...

Same query. A simple one at that.

2010-06-01 04:04:52.03 spid4s Deadlock encountered .... Printing deadlock information

2010-06-01 04:04:52.03 spid4s ...

I have those flags and can see the deadlock. The issue is the lock escalation. If it would just lock the row when update or delete all would...