Hello, hope u can help or point me in the right direction
I have 2 Services on our production System
1 Service is Vb6 (not the problem)
2 nd service is on another maching c# (not the problem)
these service insert and update a common Table
that links 2 separate databases (and there tables)
database1 and associated tables
database2 and associated tables
main database table PK
ive set up local running the services 30,000 files both services on separate
machings hitting the same table
this takes place in a Stored Proc
but in Production it locks up the system with a blocking
so web site is usless and internal processing is Useless
In the c#side and proc that i uses ive removed all begin trans, and on the
updates and selects i use (nolock)
and updates use (rowlocks)
still the same problem in production
any ideas would be greatly helpful
thanks
Dave