Resolve Locking

i've a SQL2000 server and SQLserver CE installed, also i've about 100 reps having a palm with them, entering a data through a developed software, then make a daily connection to make synchronization and send their data to the server.
most of thes reps make the synchronization at the same time each day, so most of them get the error message of Deadlock on a resource of process ID...
how can i resolve this issue and what is the most appropriate type of locking i can use to prevent this issue?

thanks in advanceCarefully selecting transaction isolation level is important here. But what's more obvious is the presence of reverse object reference that is the main cause of deadlocks. You need to analyze data access order and see where you introduce something like this:

User1 holds a lock on TableA and tries to access (place a lock) on TableB
User2 holds a lock on TableB and tries to access (place a lock) on TableA

If changing data access order is not feasible, you need to introduce a more tight transactional control and take full advantage of atomicity, which will take care of deadlock situations.

Request for extension

I would like to take full control of the entering of parameters, providing my
own UI for that, and would like to somehow extend the reporting framework.
Could you add an extension point for gathering of parameters? Is ther some
other way to do it?There is no way to extend or override the report server controls, but
you could make a web service call to GetReportParameters to find the
parameters for a report, thier type, thier dependencies, and thier
valid values. This would give you enough information to dynamically
build a UI to gather parameter information.
Once you have the parameter values you can pass them along in a URL to
the report server, or in the web service method Render to get the
report displayed.
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Sat, 23 Oct 2004 10:09:04 -0700, "John Waters"
<JohnWaters@.discussions.microsoft.com> wrote:
>I would like to take full control of the entering of parameters, providing my
>own UI for that, and would like to somehow extend the reporting framework.
>Could you add an extension point for gathering of parameters? Is ther some
>other way to do it?