Deadlock Problem

I don't know what newsgroup to post this to so I'm posting it to both.

I'm receiving sporadic deadlock problems. I get messages which look like
the following:

"Transaction (Process ID 57) was deadlocked on {lock} resources with
another process and has been chosen as the deadlock victim. Rerun the
transaction."

Running sp_lock I got the following result where dbid=7 is the tempdb and
dbid=2 is production database. Could somebody help to figure out what is
causing the problem? Thanks.

--
spid dbid ObjId IndId Type Resource Mode Status
-- -- ---- -- -- ------ --- --
52 7 1682105033 1 KEY (1f011e8335e0) X GRANT
52 7 0 0 DB S GRANT
52 2 6 0 TAB IX GRANT
52 7 1682105033 1 KEY (8001c4b164c8) X GRANT
52 2 1 0 TAB IX GRANT
52 7 1682105033 1 KEY (29017a63888f) X GRANT
52 7 1682105033 1 KEY (32016b668443) X GRANT
52 7 1682105033 1 KEY (ee00d5371f7f) X GRANT
52 2 3 0 TAB IX GRANT
52 2 2 0 TAB IX GRANT
52 2 3 2 KEY (a302626a12e7) X GRANT
52 2 12 0 TAB IX GRANT
52 7 1682105033 1 KEY (3801b739ef66) X GRANT
52 7 1682105033 1 KEY (1d01c2dc5ec5) X GRANT
52 7 1682105033 1 KEY (2301a63ce3aa) X GRANT
52 2 9 0 TAB IX GRANT
52 2 11 0 TAB IX GRANT
52 7 1682105033 1 KEY (ec000968745a) X GRANT
52 7 1682105033 1 KEY (dd00c43213b3) X GRANT
52 7 1682105033 1 KEY (f800b1d7a210) X GRANT
52 7 1682105033 1 KEY (e300a0d2aedc) X GRANT
52 7 1682105033 1 KEY (2c010f86392c) X GRANT
52 7 1682105033 1 KEY (84017c0eb282) X GRANT
52 7 1682105033 1 KEY (df00186d7896) X GRANT
52 7 1682105033 1 KEY (e9007c8dc5f9) X GRANT
52 7 1682105033 1 KEY (8601a051d9a7) X GRANT
52 7 1682105033 1 KEY (2e01d3d95209) X GRANT
52 7 1682105033 1 KEY (f2006d88c935) X GRANT
52 7 1682105033 1 KEY (31010a1c251a) X GRANT
52 7 1682105033 1 KEY (e4007917d9cf) X GRANT
52 7 1682105033 1 KEY (da001df764a0) X GRANT
52 7 1682105033 1 KEY (9801b4cec95d) X GRANT
52 7 1682105033 1 KEY (f7006812d503) X GRANT
52 7 1682105033 1 KEY (2b01d6434e3f) X GRANT
52 7 1682105033 1 KEY (92016891a278) X GRANT
52 7 1682105033 1 KEY (e600a548b2ea) X GRANT
52 7 1682105033 1 KEY (f500b44dbe26) X GRANT
52 7 1682105033 1 KEY (2001c74642f3) X GRANT
52 7 1682105033 1 KEY (8e01d02e7432) X GRANT
52 7 1682105033 1 KEY (2601a3a6ff9c) X GRANT
52 7 1682105033 1 KEY (e000c1a80f85) X GRANT
52 7 1682105033 1 KEY (3501b2a3f350) X GRANT
52 7 1682105033 1 KEY (24017ff994b9) X GRANT
52 7 1682105033 1 KEY (1a011b1929d6) X GRANT
52 7 1682105033 1 KEY (8c010c711f17) X GRANT
52 7 1682105033 1 KEY (f1000cf2686c) X GRANT
52 7 1682105033 1 KEY (eb00d0ad0349) X GRANT
52 7 1682105033 1 KEY (37016efc9875) X GRANT
52 7 1682105033 1 KEY (d500b7ba981d) X GRANT
52 7 1682105033 1 KEY (c600a6bf94d1) X GRANT
52 7 1682105033 1 KEY (7d01c12b78fe) X GRANT
52 2 0 0 PAG 1:79 X GRANT
52 7 1682105033 1 KEY (d7006be5f338) X GRANT
52 7 1682105033 1 KEY (7f011d7413db) X GRANT
52 7 1682105033 1 KEY (c4007ae0fff4) X GRANT
52 7 1682105033 1 KEY (cb00d35a2572) X GRANT
52 2 99 0 RID 1:89:0 X GRANT
52 2 0 0 EXT 1:88 X GRANT
52 2 3 2 KEY (780254519c13) X GRANT
52 7 1682105033 1 KEY (bf001b9a5ead) X GRANT
52 2 0 0 PAG 1:80 X GRANT
52 7 1682105033 1 KEY (d1000f054e57) X GRANT
52 2 0 0 EXT 1:80 X GRANT
52 7 1682105033 1 KEY (c000c25f29be) X GRANT
52 2 99 0 RID 1:80:0 X GRANT
52 7 1682105033 1 KEY (bd00c7c53588) X GRANT
52 2 3 2 KEY (9a01d4bbc633) X GRANT
52 2 0 0 PAG 1:88 X GRANT
52 2 0 0 PAG 1:89 X GRANT
52 7 1682105033 1 KEY (cc000a9f5261) X GRANT
52 7 1682105033 1 KEY (ce00d6c03944) X GRANT
52 7 1682105033 1 KEY (ba001e00429b) X GRANT
52 7 1682105033 1 KEY (d2006e7fef0e) X GRANT
52 7 1682105033 1 KEY (c9007f7ae3c2) X GRANT
52 7 1682105033 1 KEY (7a0118ee0fed) X GRANT
52 7 1682105033 1 KEY (c300a32588e7) X GRANT
52 7 1682105033 1 KEY (d800b220842b) X GRANT
52 2 1 3 KEY (05007a9d7c37) X GRANT
52 2 3 2 KEY (c40246be5c01) X GRANT
52 2 3 2 KEY (0403abfc7b7d) X GRANT
52 7 673593638 0 TAB IX GRANT
52 2 1 3 KEY (eb00018f10cf) X GRANT
52 7 1682105033 1 KEY (6001cd749469) X GRANT
52 7 1682105033 1 KEY (b500be7f68bc) X GRANT
52 2 3 1 KEY (1000a9668803) X GRANT
52 7 1682105033 1 KEY (a600af7a6470) X GRANT
52 7 1682105033 1 KEY (b70062200399) X GRANT
52 7 1682105033 1 KEY (6b01dc7198a5) X GRANT
52 2 3 1 KEY (13009b965634) X GRANT
52 7 1682105033 1 KEY (9a0017c5b23a) X GRANT
52 7 1682105033 1 KEY (a40073250f55) X GRANT
52 2 3 1 KEY (12007539e326) X GRANT
52 2 3 1 KEY (0d0047c93d11) X GRANT
52 7 1682105033 1 KEY (7101002ef380) X GRANT
52 2 3 1 KEY (0600cd86356c) X GRANT
52 7 1682105033 1 KEY (ab00da9fd5d3) X GRANT
52 7 1682105033 1 KEY (770164ce4eef) X GRANT
52 7 1682105033 1 KEY (b10006c0bef6) X GRANT
52 2 3 1 KEY (07002329807e) X GRANT
52 7 1682105033 1 KEY (5a01112bff4c) X GRANT
52 7 1682105033 1 KEY (640175cb4223) X GRANT
52 2 3 1 KEY (0900ff76eb5b) X GRANT
52 7 1682105033 1 KEY (7501b89125ca) X GRANT
52 7 1682105033 1 KEY (a000cb9ad91f) X GRANT
52 7 1682105033 1 KEY (6601a9942906) X GRANT
52 2 3 1 KEY (0c0011d95e49) X GRANT
52 7 1682105033 1 KEY (ac00035aa2c0) X GRANT
52 7 1682105033 1 KEY (6301ac0e3530) X GRANT
52 7 1682105033 4 PAG 1:14687 IX GRANT
52 7 1682105033 1 KEY (7801bd0b39fc) X GRANT
52 7 1682105033 1 KEY (5d01c8ee885f) X GRANT
52 2 3 1 KEY (1800d9192596) X GRANT
52 7 1682105033 1 KEY (7201615452d9) X GRANT
52 2 3 2 KEY (d501bbd6d318) X GRANT
52 7 1682105033 1 KEY (ae00df05c9e5) X GRANT
52 2 3 1 KEY (150037b69084) X GRANT
52 7 1682105033 1 KEY (690170515e15) X GRANT
52 7 1682105033 1 KEY (5f0114b1e37a) X GRANT
52 7 1682105033 1 KEY (6e01d9eb8493) X GRANT
52 7 1682105033 1 KEY (b20067ba1faf) X GRANT
52 7 1682105033 1 KEY (a90076bf1363) X GRANT
52 7 1682105033 1 KEY (9f00125fae0c) X GRANT
52 7 1682105033 1 KEY (6c0105b4efb6) X GRANT
52 7 1682105033 1 KEY (a300aae07846) X GRANT
52 7 1682105033 1 KEY (9d00ce00c529) X GRANT
52 7 1682105033 1 KEY (b800bbe5748a) X GRANT
52 7 1682105033 1 KEY (fa0014329401) X GRANT
52 7 1682105033 1 KEY (490173a6782e) X GRANT
52 7 1682105033 1 KEY (520162a374e2) X GRANT
52 7 1682105033 1 KEY (5801befc1fc7) X GRANT
52 7 1682105033 1 KEY (4301aff9130b) X GRANT
52 7 1682105033 1 KEY (4c010643c98d) X GRANT
52 7 1682105033 1 KEY (3a0112dcd977) X GRANT
52 2 3 2 KEY (2f02bcae25ba) X GRANT
52 7 1682105033 1 KEY (4e01da1ca2a8) X GRANT
52 7 1682105033 1 KEY (510103d9d5bb) X GRANT
52 7 1682105033 1 KEY (3f011746c541) X GRANT
52 7 1682105033 1 KEY (4b01df86be9e) X GRANT
52 7 1682105033 1 KEY (3d01cb19ae64) X GRANT
52 7 1682105033 1 KEY (4001ce83b252) X GRANT
52 7 1682105033 1 KEY (4601aa630f3d) X GRANT
52 7 1682105033 1 KEY (fd00cdf7e312) X GRANT
52 2 3 2 KEY (800230bd9a6a) X GRANT
52 7 1682105033 1 KEY (5501bb6603f1) X GRANT
52 7 1682105033 1 KEY (ff0011a88837) X GRANT
52 7 1682105033 1 KEY (4401763c6418) X GRANT
52 2 3 2 KEY (5e037595f99f) X GRANT
52 7 1682105033 1 KEY (5701673968d4) X GRANT
52 7 1682105033 1 KEY (0e01dcf2efde) X GRANT
52 7 1682105033 1 KEY (0c0100ad84fb) X GRANT
52 7 1682105033 1 KEY (1801b81252b1) X GRANT
52 7 1682105033 1 KEY (0301a9175e7d) X GRANT
52 7 1682105033 1 KEY (090175483558) X GRANT
52 7 1682105033 1 KEY (1201644d3994) X GRANT
52 7 1682105033 1 KEY (040170d2296e) X GRANT
52 7 1682105033 1 KEY (170161d725a2) X GRANT
52 7 1682105033 1 KEY (0601ac8d424b) X GRAN3 1
KEY (cd0058922cd8) X GRANT
52 7 1682105033 1 KEY (bb004c0d3c22) X GRANT
52 7 1682105033 1 KEY (cf0084cd47fd) X GRANT
52 7 1682105033 1 KEY (7b014ae37154) X GRANT
52 2 3 2 KEY (8501d81941e4) X GRANT
52 7 1682105033 1 KEY (c8002d779d7b) X GRANT
52 7 1682105033 1 KEY (d3003c7291b7) X GRANT
52 7 1682105033 1 KEY (d900e02dfa92) X GRANT
52 7 1682105033 1 KEY (c200f128f65e) X GRANT
52 7 1682105033 1 KEY (c700f4b2ea68) X GRANT
52 7 1682105033 1 KEY (7c0193260647) X GRANT
52 7 1682105033 1 KEY (d400e5b7e6a4) X GRANT
52 7 1682105033 1 KEY (7e014f796d62) X GRANT
52 7 1682105033 1 KEY (c50028ed814d) X GRANT
52 7 1410104064 0 TAB IX GRANT
52 7 1682105033 1 KEY (d60039e88d81) X GRANT
52 7 1682105033 1 KEY (d0005d0830ee) X GRANT
52 7 1682105033 1 KEY (be0049972014) X GRANT
52 7 1682105033 1 KEY (ca0081575bcb) X GRANT
52 7 2050106344 8 KEY (cc00054873c4) X GRANT
52 7 1682105033 1 KEY (bc0095c84b31) X GRANT
52 7 1682105033 1 KEY (c10090525707) X GRANT
52 7 1682105033 1 KEY (160133da5b1b) X GRANT
52 7 1682105033 1 KEY (050122df57d7) X GRANT
52 7 1682105033 1 KEY (1401ef85303e) X GRANT
52 7 1682105033 1 KEY (0701fe803cf2) X GRANT
52 2 3 2 KEY (de0193ef7558) X GRANT
52 7 1682105033 1 KEY (01019a60819d) X GRANT
52 7 1682105033 1 KEY (0a018b658d51) X GRANT
52 7 1682105033 1 KEY (1001573ae674) X GRANT
52 7 50099219 1 PAG 1:90498 IX GRANT
52 7 1682105033 1 KEY (0f018eff9167) X GRANT
52 7 1682105033 1 KEY (0d0152a0fa42) X GRANT
52 7 1682105033 1 KEY (0201fb1a20c4) X GRANT
52 7 1682105033 1 KEY (1901ea1f2c08) X GRANT
52 7 1682105033 1 KEY (13013640472d) X GRANT
52 7 1682105033 1 KEY (080127454be1) X GRANT
52 2 3 2 KEY (49013c8cc935) X GRANT
52 7 1682105033 4 KEY (3a02e19bb855) X GRANT
52 7 1682105033 1 KEY (7901ef064745) X GRANT
52 7 1682105033 1 KEY (5c019ae3f6e6) X GRANT
52 7 1682105033 1 KEY (6201fe034b89) X GRANT
52 2 3 1 KEY (0800464e3cc6) X GRANT
52 2 3 2 KEY (de002759ba96) X GRANT
52 7 1682105033 1 KEY (ad005157dc79) X GRANT
52 7 2050106344 8 PAG 1:2966 IX GRANT
52 2 3 1 KEY (0a009a1157e3) X GRANT
52 7 1682105033 1 KEY (5e0146bc9dc3) X GRANT
52 2 3 1 KEY (0b0074bee2f1) X GRANT
52 7 1682105033 1 KEY (6801225c20ac) X GRANT
52 7 1682105033 1 KEY (730133592c60) X GRANT
52 7 1682105033 1 KEY (af008d08b75c) X GRANT
52 7 1682105033 1 KEY (9e004052d0b5) X GRANT
52 7 1410104064 1 KEY (3a0081b928d8) X GRANT
52 7 1682105033 1 KEY (a80024b26dda) X GRANT
52 2 2 1 KEY (05002c802609) X GRANT
52 7 1682105033 1 KEY (6f018be6fa2a) X GRANT
52 7 1682105033 1 KEY (b30035b76116) X GRANT
52 7 673593638 1 PAG 1:76168 IX GRANT
52 2 3 1 KEY (1400fef1ea8c) X GRANT
52 7 1682105033 1 KEY (9c009c0dbb90) X GRANT
52 2 3 1 KEY (0f00cc0134bb) X GRANT
52 7 1682105033 1 KEY (b900e9e80a33) X GRANT
52 7 1682105033 1 KEY (a200f8ed06ff) X GRANT
52 7 1682105033 1 KEY (6d0157b9910f) X GRANT
52 2 3 1 KEY (1100105e5f9e) X GRANT
52 2 3 1 KEY (0e0022ae81a9) X GRANT
52 7 1682105033 1 KEY (a700fd771ac9) X GRANT
52 7 1682105033 1 KEY (61019f79ead0) X GRANT
52 7 1682105033 1 KEY (b400ec721605) X GRANT
52 7 1682105033 1 KEY (a500212871ec) X GRANT
52 7 1682105033 1 KEY (9b0045c8cc83) X GRANT
52 7 1682105033 1 KEY (700152238d39) X GRANT
52 7 50099219 3 KEY (46016960a15e) X GRANT
52 7 1682105033 1 KEY (b600302d7d20) X GRANT
52 7 1682105033 1 KEY (6a018e7ce61c) X GRANT
52 7 1682105033 1 KEY (b00054cdc04f) X GRANT
52 7 1682105033 1 KEY (650127c63c9a) X GRANT
52 2 3 1 KEY (19006021f20b) X GRANT
52 7 1682105033 1 KEY (5b01432681f5) X GRANT
52 7 1682105033 1 KEY (aa008892ab6a) X GRANT
52 7 1682105033 1 KEY (760136c33056) X GRANT
52 7 1682105033 1 KEY (6701fb9957bf) X GRANT
52 2 3 1 KEY (160052d12c3c) X GRANT
52 7 1682105033 1 KEY (7401ea9c5b73) X GRANT
52 2 3 1 KEY (1700bc7e992e) X GRANT
52 7 1682105033 1 KEY (a1009997a7a6) X GRANT
52 7 1682105033 1 KEY (4a018d8bc027) X GRANT
52 7 1682105033 1 KEY (3e01454bbbf8) X GRANT
52 7 1682105033 1 KEY (500151d4ab02) X GRANT
52 7 1682105033 1 KEY (41019c8ecceb) X GRANT
52 7 1682105033 1 KEY (3c019914d0dd) X GRANT
52 7 1682105033 1 KEY (5401e96b7d48) X GRANT
52 7 1682105033 1 KEY (4701f86e7184) X GRANT
52 7 1682105033 1 KEY (fc009ffa9dab) X GRANT
52 7 1682105033 1 KEY (56013534166d) X GRANT
52 7 1682105033 1 KEY (fe0043a5f68e) X GRANT
52 7 1682105033 1 KEY (450124311aa1) X GRANT
52 7 1682105033 1 KEY (530130ae0a5b) X GRANT
52 7 1682105033 1 KEY (480121ab0697) X GRANT
52 7 1682105033 1 KEY (fb00463feab8) X GRANT
52 7 1682105033 1 KEY (4201fdf46db2) X GRANT
52 2 3 2 KEY (df03a1fef4db) X GRANT
52 7 1682105033 1 KEY (5901ecf1617e) X GRANT
52 7 1682105033 1 KEY (4d01544eb734) X GRANT
52 7 1682105033 1 KEY (4f018811dc11) X GRANT
52 7 1682105033 1 KEY (3b0140d1a7ce) X GRANT
52 7 1682105033 1 KEY (e000f6c2cd84) X GRANT
52 7 1682105033 1 KEY (350185c93151) X GRANT
52 7 1682105033 1 KEY (260194cc3d9d) X GRANT
52 7 1682105033 1 KEY (eb00e7c7c148) X GRANT
52 7 1682105033 1 KEY (370159965a74) X GRANT
52 2 2 1 KEY (eb0035a95436) X GRANT
52 7 1682105033 1 PAG 1:114462 IX GRANT
52 7 1682105033 1 PAG 1:114461 IX GRANT
52 7 1682105033 1 PAG 1:114460 IX GRANT
52 7 1682105033 1 KEY (1a012c73ebd7) X GRANT
52 7 1682105033 1 KEY (2401489356b8) X GRANT
52 7 1682105033 1 KEY (f1003b98aa6d) X GRANT
52 7 1682105033 1 KEY (f7005f781702) X GRANT
52 7 1682105033 1 KEY (2b01e1298c3e) X GRANT
52 7 1682105033 1 KEY (830192a10790) X GRANT
52 7 1682105033 1 KEY (31013d76e71b) X GRANT
52 7 1682105033 1 KEY (da002a9da6a1) X GRANT
52 7 1682105033 1 KEY (e4004e7d1bce) X GRANT
52 7 1682105033 1 KEY (f50083277c27) X GRANT
52 7 1682105033 1 KEY (2001f02c80f2) X GRANT
52 7 1682105033 1 KEY (e600922270eb) X GRANT
52 7 1682105033 1 KEY (89014efe6cb5) X GRANT
52 7 1682105033 1 KEY (2c0138ecfb2d) X GRANT
52 7 1682105033 1 KEY (e30097b86cdd) X GRANT
52 2 3 2 KEY (7a0171442aa8) X GRANT
52 7 1682105033 1 KEY (dd00f358d1b2) X GRANT
52 7 1682105033 1 KEY (97015a617c4f) X GRANT
52 7 1682105033 1 KEY (f80086bd6011) X GRANT
52 7 1682105033 1 KEY (2e01e4b39008) X GRANT
52 7 1682105033 1 KEY (f2005ae20b34) X GRANT
52 7 1682105033 1 KEY (e9004be707f8) X GRANT
52 7 1682105033 1 KEY (df002f07ba97) X GRANT
52 7 1682105033 1 KEY (9501863e176a) X GRANT
52 7 1682105033 1 KEY (32015c0c4642) X GRANT
52 7 1682105033 1 KEY (ee00e25ddd7e) X GRANT
52 7 1682105033 1 KEY (29014d094a8e) X GRANT
52 7 50099219 3 PAG 1:102217 IX GRANT
52 7 1682105033 1 KEY (1f0129e9f7e1) X GRANT
52 7 1682105033 1 KEY (8001f3dba6c9) X GRANT
52 7 1682105033 1 KEY (91013e81c120) X GRANT
52 7 1682105033 1 KEY (ec003e02b65b) X GRANT
52 7 1682105033 1 KEY (2301915621ab) X GRANT
52 7 1682105033 1 KEY (380180532d67) X GRANT
52 7 1682105033 1 KEY (1d01f5b69cc4) X GRANT
52 7 1682105033 1 KEY (8b01e2deaa05) X GRANT
52 7 1682105033 1 KEY (7a012f84cdec) X GRANT
52 7 1682105033 1 KEY (c900481021c3) X GRANT
52 7 1682105033 1 KEY (d20059152d0f) X GRANT
52 7 1682105033 1 KEY (d800854a462a) X GRANT
52 7 1682105033 1 KEY (c300944f4ae6) X GRANT
52 7 1682105033 1 KEY (cc003df59060) X GRANT
52 7 1682105033 1 KEY (ba00296a809a) X GRANT
52 2 3 2 KEY (7703885db1d2) X GRANT
52 7 1682105033 1 KEY (ce00e1aafb45) X GRANT
52 7 1682105033 1 KEY (d100386f8c56) X GRANT
52 7 1682105033 1 KEY (bf002cf09cac) X GRANT
52 7 1682105033 1 KEY (cb00e430e773) X GRANT
52 7 1682105033 1 KEY (bd00f0aff789) X GRANT
52 7 1682105033 1 KEY (c000f535ebbf) X GRANT
52 2 3 2 KEY (7402670da95e) X GRANT
52 7 1682105033 1 KEY (c60091d556d0) X GRANT
52 7 1682105033 1 KEY (7d01f641baff) X GRANT
52 7 1682105033 1 KEY (d50080d05a1c) X GRANT
52 2 3 2 KEY (c302741d5036) X GRANT
52 7 1682105033 1 KEY (7f012a1ed1da) X GRANT
52 7 1682105033 1 KEY (c4004d8a3df5) X GRANT
52 7 1682105033 1 KEY (d7005c8f3139) X GRANT
52 2 3 2 KEY (ac02bc94c621) X GRANT
52 2 3 2 KEY (f300c206222d) X GRANT
52 7 1682105033 1 KEY (9f0025356c0d) X GRANT
52 7 1682105033 1 KEY (a90041d5d162) X GRANT
52 7 1682105033 1 KEY (6e01ee814692) X GRANT
52 7 1682105033 1 KEY (b20050d0ddae) X GRANT
52 2 3 2 KEY (6002954276f1) X GRANT
52 7 1682105033 1 KEY (9d00f96a0728) X GRANT
52 7 1682105033 1 KEY (b8008c8fb68b) X GRANT
52 7 1682105033 1 KEY (a3009d8aba47) X GRANT
52 7 1682105033 1 KEY (6c0132de2db7) X GRANT
52 2 3 2 KEY (6b0259d33037) X GRANT
52 7 1682105033 1 KEY (78018a61fbfd) X GRANT
52 7 1682105033 1 KEY (5d01ff844a5e) X GRANT
52 7 1682105033 1 KEY (63019b64f731) X GRANT
52 7 1682105033 1 KEY (ac00343060c1) X GRANT
52 2 3 2 KEY (9102a999d45e) X GRANT
52 7 1682105033 1 KEY (5f0123db217b) X GRANT
52 7 2050106344 1 KEY (92006b88f750) X GRANT
52 2 369592555 0 TAB Sch-M GRANT
52 7 1682105033 1 KEY (6901473b9c14) X GRANT
52 7 1682105033 1 KEY (7201563e90d8) X GRANT
52 2 0 0 IDX IDX: 2:369592555 X GRANT
52 7 1682105033 1 KEY (ae00e86f0be4) X GRANT
52 7 1682105033 1 KEY (b10031aa7cf7) X GRANT
52 7 1682105033 1 KEY (640142a18022) X GRANT
52 7 1682105033 1 KEY (5a0126413d4d) X GRANT
52 7 1682105033 1 KEY (ab00edf517d2) X GRANT
52 7 1682105033 1 KEY (770153a48cee) X GRANT
52 7 1682105033 1 KEY (66019efeeb07) X GRANT
52 7 1682105033 1 KEY (75018ffbe7cb) X GRANT
52 7 1682105033 1 KEY (a000fcf01b1e) X GRANT
52 2 3 2 KEY (8e01830bf507) X GRANT
52 7 1682105033 1 KEY (a6009810a671) X GRANT
52 7 1682105033 1 KEY (6001fa1e5668) X GRANT
52 7 1682105033 1 KEY (b5008915aabd) X GRANT
52 7 1682105033 1 KEY (a400444fcd54) X GRANT
52 7 1682105033 1 KEY (710137443181) X GRANT
52 7 1682105033 1 KEY (b700554ac198) X GRANT
52 7 2050106344 7 PAG 1:98203 IX GRANT
52 7 1682105033 1 KEY (6b01eb1b5aa4) X GRANT
52 7 1682105033 1 KEY (55018c0cc1f0) X GRANT
52 7 1682105033 1 KEY (46019d09cd3c) X GRANT
52 7 1682105033 1 KEY (fd00fa9d2113) X GRANT
52 7 1682105033 1 KEY (57015053aad5) X GRANT
52 7 1682105033 1 KEY (ff0026c24a36) X GRANT
52 7 1682105033 1 KEY (44014156a619) X GRANT
52 7 1682105033 1 KEY (4b01e8ec7c9f) X GRANT
52 7 1682105033 1 KEY (3f01202c0740) X GRANT
52 7 1682105033 1 KEY (510134b317ba) X GRANT
52 7 1682105033 1 KEY (4001f9e97053) X GRANT
52 7 1682105033 1 KEY (9a009d6ba7a4) X GRANT
52 7 1682105033 1 KEY (3d01fc736c65) X GRANT
52 7 1682105033 1 KEY (4c0131290b8c) X GRANT
52 7 1682105033 1 KEY (4e01ed7660a9) X GRANT
52 7 1682105033 1 KEY (3a0125b61b76) X GRANT
52 7 1682105033 1 KEY (520155c9b6e3) X GRANT
52 7 1682105033 1 KEY (490144ccba2f) X GRANT
52 7 1682105033 1 KEY (fa0023585600) X GRANT
52 7 1682105033 1 KEY (43019893d10a) X GRANT
52 7 1682105033 1 KEY (58018996ddc6) X GRANT
52 7 1682105033 1 KEY (0001ff073d25) X GRANT
52 7 1682105033 1 KEY (0b01ee0231e9) X GRANT
52 7 1682105033 1 KEY (1101325d5acc) X GRANT
52 7 1682105033 1 KEY (170156bde7a3) X GRANT
52 7 1682105033 0 TAB IX GRANT
52 7 1682105033 1 KEY (040147b8eb6f) X GRANT
52 2 3 1 KEY (fb0031b8225d) X GRANT
52 7 1682105033 1 KEY (15018ae28c86) X GRANT
52 7 1682105033 1 KEY (06019be7804a) X GRANT
52 2 3 1 KEY (fe00df17974f) X GRANT
52 2 3 1 KEY (ec00cb8887b5) X GRANT
52 2 3 1 KEY (f20017d7ec90) X GRANT
52 2 3 1 KEY (ed00252732a7) X GRANT
52 7 1682105033 1 KEY (03019e7d9c7c) X GRANT
52 7 1682105033 1 KEY (18018f7890b0) X GRANT
52 7 1682105033 1 KEY (12015327fb95) X GRANT
52 7 1682105033 1 KEY (09014222f759) X GRANT
52 2 3 1 KEY (ef00f9785982) X GRANT
52 7 1682105033 1 KEY (0e01eb982ddf) X GRANT
52 2 3 1 KEY (f600af683ada) X GRANT
52 2 3 1 KEY (f30041c78fc8) X GRANT
52 7 1682105033 1 KEY (0c0137c746fa) X GRANT
52 2 3 1 KEY (f9009d98e4ed) X GRANT
52 2 3 1 KEY (f800733751ff) X GRANT
52 2 3 2 KEY (1f0336d2d087) X GRANT
52 7 257540101 0 PAG 1:21868 IS GRANT
52 2 3 2 KEY (f300e0d5b4b3) X GRANT
52 7 1682105033 4 KEY (8102568ca4b3) X GRANT
52 7 1410104064 1 PAG 1:13905 IX GRANT
52 7 2050106344 0 TAB IX GRANT
52 7 2050106344 1 PAG 1:3650 IX GRANT
52 7 673593638 1 KEY (a200b2578fc8) X GRANT
52 7 1682105033 1 KEY (dc00a155af0b) X GRANT
52 7 1682105033 1 KEY (f900d4b01ea8) X GRANT
52 7 1682105033 1 KEY (e200c5b51264) X GRANT
52 7 1682105033 1 KEY (2d016ae18594) X GRANT
52 7 1682105033 1 KEY (850119690e3a) X GRANT
52 7 1682105033 1 KEY (de007d0ac42e) X GRANT
52 7 1682105033 1 KEY (8701c536651f) X GRANT
52 7 1682105033 1 KEY (e80019ea7941) X GRANT
52 7 1682105033 1 KEY (2f01b6beeeb1) X GRANT
52 7 1682105033 1 KEY (f30008ef758d) X GRANT
52 7 1682105033 1 KEY (1e017be48958) X GRANT
52 7 1682105033 1 KEY (8101a1d6d870) X GRANT
52 7 1682105033 1 KEY (28011f043437) X GRANT
52 7 1682105033 1 KEY (33010e0138fb) X GRANT
52 7 1682105033 1 KEY (ef00b050a3c7) X GRANT
52 7 1682105033 1 KEY (3901d25e53de) X GRANT
52 7 1682105033 1 KEY (1c01a7bbe27d) X GRANT
52 7 1682105033 1 KEY (2201c35b5f12) X GRANT
52 7 1682105033 1 KEY (ed006c0fc8e2) X GRANT
52 2 3 2 KEY (3902a1a9d5ad) X GRANT
52 7 1682105033 1 KEY (8f01b549c88a) X GRANT
52 7 1682105033 1 KEY (2701c6c14324) X GRANT
52 7 1682105033 1 KEY (e100a4cfb33d) X GRANT
52 7 1682105033 1 KEY (3401d7c44fe8) X GRANT
52 7 1682105033 1 KEY (25011a9e2801) X GRANT
52 7 1682105033 1 KEY (8d016916a3af) X GRANT
52 7 1682105033 1 KEY (1b017e7e956e) X GRANT
52 7 1682105033 1 KEY (f0006995d4d4) X GRANT
52 7 1682105033 1 KEY (ea00b5cabff1) X GRANT
52 7 1682105033 1 KEY (36010b9b24cd) X GRANT
52 7 1682105033 1 KEY (30016f7b99a2) X GRANT
52 7 1682105033 1 KEY (e5001c706577) X GRANT
52 7 1682105033 1 KEY (db007890d818) X GRANT
52 2 1 1 KEY (05000f9d1a73) X GRANT
52 7 1682105033 1 KEY (8201c0ac7929) X GRANT
52 7 1682105033 1 KEY (f6000d7569bb) X GRANT
52 7 1682105033 1 KEY (9901d1a975e5) X GRANT
52 7 1682105033 1 KEY (2a01b324f287) X GRANT
52 7 1682105033 1 KEY (93010df61ec0) X GRANT
52 7 1682105033 1 KEY (e700c02f0e52) X GRANT
52 7 1682105033 1 KEY (f400d12a029e) X GRANT
52 7 1682105033 1 KEY (2101a221fe4b) X GRANT
52 7 1682105033 1 KEY (ca00b63d99ca) X GRANT
52 7 1682105033 1 KEY (be007efde215) X GRANT
52 7 1682105033 1 KEY (d0006a62f2ef) X GRANT
52 7 1682105033 1 KEY (c100a7389506) X GRANT
52 7 2034106287 1 KEY (3a0081b928d8) X GRANT
52 7 1682105033 1 KEY (bc00a2a28930) X GRANT
52 7 2034106287 5 PAG 1:70821 IX GRANT
52 2 3 2 KEY (2c01a841bccd) X GRANT
52 7 1682105033 1 KEY (d400d2dd24a5) X GRANT
52 7 1682105033 1 KEY (c700c3d82869) X GRANT
52 2 1 1 KEY (eb00748f768b) X GRANT
52 7 1682105033 1 KEY (7c01a44cc446) X GRANT
52 7 1682105033 1 KEY (d6000e824f80) X GRANT
52 7 1682105033 1 KEY (7e017813af63) X GRANT
52 7 1682105033 1 KEY (c5001f87434c) X GRANT
52 7 1682105033 1 KEY (d3000b1853b6) X GRANT
52 7 1682105033 1 KEY (c8001a1d5f7a) X GRANT
52 7 1682105033 1 KEY (7b017d89b355) X GRANT
52 7 1682105033 1 KEY (c200c642345f) X GRANT
52 7 1682105033 1 KEY (d900d7473893) X GRANT
52 7 1682105033 1 KEY (cd006ff8eed9) X GRANT
52 7 1682105033 1 KEY (cf00b3a785fc) X GRANT
52 7 2034106287 1 PAG 1:70803 IX GRANT
52 7 1682105033 1 KEY (bb007b67fe23) X GRANT
52 7 1682105033 1 KEY (1901dd75ee09) X GRANT
52 7 1682105033 1 KEY (0201cc70e2c5) X GRANT
52 2 3 1 KEY (ff00662f40d2) X GRANT
52 2 3 1 KEY (fc0054df9ee5) X GRANT
52 7 1682105033 1 KEY (0801102f89e0) X GRANT
52 7 1682105033 1 KEY (1301012a852c) X GRANT
52 2 3 1 KEY (fd00ba702bf7) X GRANT
52 7 1682105033 1 KEY (0f01b9955366) X GRANT
52 2 3 2 KEY (c60169c5ef78) X GRANT
52 7 1682105033 1 KEY (0d0165ca3843) X GRANT
52 2 3 1 KEY (f500ca0f8662) X GRANT
52 7 1682105033 1 KEY (0101ad0a439c) X GRANT
52 2 3 1 KEY (f40024a03370) X GRANT
52 7 1682105033 1 KEY (100160502475) X GRANT
52 2 3 1 KEY (f7001650ed47) X GRANT
52 2 3 1 KEY (fa00f8ff5855) X GRANT
52 7 1682105033 1 KEY (0a01bc0f4f50) X GRANT
52 7 1682105033 1 KEY (050115b595d6) X GRANT
52 2 3 1 KEY (f0009c1fe53a) X GRANT
52 2 3 1 KEY (f10072b05028) X GRANT
52 2 3 1 KEY (ee0040408e1f) X GRANT
52 7 1682105033 1 KEY (160104b0991a) X GRANT
52 7 1682105033 1 KEY (0701c9eafef3) X GRANT
52 7 1682105033 1 KEY (1401d8eff23f) X GRANT
52 2 0 0 IDX IDX: 2:17591301: X GRANT
52 2 17591301 0 TAB Sch-M GRANT
52 7 1682105033 1 KEY (aa00bff8696b) X GRANT
52 7 1682105033 1 KEY (760101a9f257) X GRANT
52 7 1682105033 1 KEY (b00063a7024e) X GRANT
52 7 1682105033 1 KEY (5b01744c43f4) X GRANT
52 7 1682105033 1 KEY (650110acfe9b) X GRANT
52 7 1682105033 1 KEY (7401ddf69972) X GRANT
52 7 1682105033 1 KEY (a100aefd65a7) X GRANT
52 7 1682105033 1 KEY (6701ccf395be) X GRANT
52 7 1682105033 1 KEY (6101a81328d1) X GRANT
52 7 1682105033 1 KEY (b400db18d404) X GRANT
52 7 1682105033 1 KEY (a700ca1dd8c8) X GRANT
52 7 1682105033 1 KEY (b6000747bf21) X GRANT
52 7 1682105033 1 KEY (6a01b916241d) X GRANT
52 2 3 2 KEY (1e02c762ac84) X GRANT
52 7 1682105033 1 KEY (9b0072a20e82) X GRANT
52 7 1682105033 1 KEY (a5001642b3ed) X GRANT
52 7 1682105033 1 KEY (700165494f38) X GRANT
52 7 1682105033 1 KEY (6f01bc8c382b) X GRANT
52 7 1682105033 1 KEY (b30002dda317) X GRANT
52 7 1682105033 1 KEY (a80013d8afdb) X GRANT
52 7 1682105033 1 KEY (9e00773812b4) X GRANT
52 2 3 2 KEY (d9015b3a7642) X GRANT
52 7 1682105033 1 KEY (6d0160d3530e) X GRANT
52 2 3 2 KEY (580364db66a7) X GRANT
52 7 1682105033 1 KEY (a200cf87c4fe) X GRANT
52 7 1682105033 1 KEY (9c00ab677991) X GRANT
52 7 1682105033 1 KEY (b900de82c832) X GRANT
52 7 1682105033 1 KEY (ad00663d1e78) X GRANT
52 7 1682105033 1 KEY (6201c9698988) X GRANT
52 7 2034106287 0 TAB IX GRANT
52 7 1682105033 1 KEY (7901d86c8544) X GRANT
52 7 1682105033 1 KEY (5c01ad8934e7) X GRANT
52 7 1682105033 1 KEY (73010433ee61) X GRANT
52 7 1682105033 1 KEY (af00ba62755d) X GRANT
52 7 50099219 1 KEY (460104986f4d) X GRANT
52 7 1682105033 1 KEY (68011536e2ad) X GRANT
52 7 1682105033 1 KEY (5e0171d65fc2) X GRANT
52 7 1682105033 1 KEY (4d0163247535) X GRANT
52 7 1682105033 1 KEY (3b0177bb65cf) X GRANT
52 7 1682105033 1 KEY (4f01bf7b1e10) X GRANT
52 7 1682105033 1 KEY (fb00715528b9) X GRANT
52 7 1682105033 1 KEY (480116c1c496) X GRANT
52 7 1682105033 1 KEY (530107c4c85a) X GRANT
52 7 1682105033 1 KEY (5901db9ba37f) X GRANT
52 7 1682105033 1 KEY (4201ca9eafb3) X GRANT
52 7 1682105033 1 KEY (4701cf04b385) X GRANT
52 7 1682105033 1 KEY (fc00a8905faa) X GRANT
52 7 1682105033 1 KEY (5401de01bf49) X GRANT
52 7 1682105033 1 KEY (fe0074cf348f) X GRANT
52 7 1682105033 1 KEY (4501135bd8a0) X GRANT
52 7 1682105033 1 KEY (5601025ed46c) X GRANT
52 7 1682105033 1 KEY (500166be6903) X GRANT
52 7 1682105033 1 KEY (3e01722179f9) X GRANT
52 7 1682105033 1 KEY (4a01bae10226) X GRANT
52 7 1682105033 1 KEY (3c01ae7e12dc) X GRANT
52 2 3 2 KEY (d9016c0803f6) X GRANT
52 2 3 2 KEY (dd01651473d6) X GRANT
52 7 1682105033 1 KEY (4101abe40eea) X GRANT
--What you really need is the actual TSQL that is causing the problem.
To get more useful info, you could use profiler and monitor directly for
deadlocks, or these trace flags:
DBCC TRACEON(1204,1205,3605,-1)
The above flags will enter the actual relevant TSQL in the SQL log.
HTH,
Paul Ibison