Viewing 4 posts - 1 through 5 (of 5 total)
spid3...
spid3Wait-for graph
spid3
spid3RID: 12:1:71827:36 CleanCnt:1 Mode: X Flags: 0x2
spid3Node:1
spid3
spid3Owner:0x56e46c60 Mode: X Flg:0x0...
July 6, 2007 at 2:55 am
In VB code this there is an object corresponding to this table and that object is part of a very big Object with lots of Objects( each table for each...
July 6, 2007 at 2:30 am
yea it is having a clustered index on (SysID, Trans_no, Location_ID).
July 6, 2007 at 12:39 am
Suresh thakns for ur reply ... but I don't have begin and commint tran in my SP. Also the code is VB 5.0, a VB 6.0 service is accessing it.
July 5, 2007 at 11:13 pm
Viewing 4 posts - 1 through 5 (of 5 total)