Hi Todd,

deadlocks aren't during insert,

I have a table A(IDA, ColA)  and a table B(IDB, FKA, ColB) which reference table A through a FK FKA.

My deadlock appears when I...

Hi,

hope it will help you

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

declare @TblName sysname

set @tblName = 'Your table name'

-- show identity col name

select syscolumns.name from sysobjects

inner join syscolumns on sysobjects.id = syscolumns.id

where sysobjects.name =...

Sorry, I post my thread onto wrong forum, I post it into SQL Server 7, 2000 administration.

Hi, we have a similar problem under windows 2000 sp4 with SQL Server standard sp4 onto a muti processor server.

The problem was due to a server option under processor tab -> "Use...