Sql Server Locks

Hi All,

We have various processes running symultaniously but no two processes will
access the same record and each process is in a seperate transaction.

The problem is with SQL Server Database Locks.
i.e. if we access any query in two different transactions then one is
getting success and the next one is failing.

Example Scenario:
First process is running for Client "A": This will delete records of
client A and reinserts the same with some data changes
First process is running for Client "B": This will delete records of
client B and reinserts the same with some data changes

In this example the code is same for two clients and the tables accessed
also same. we are tried with out locks and using row locks but nothing is
working.

Suggest us which is the best locking option for this kind of scenarios and
provide us any good links for this kind of scenarios.

With Regards,
Prasad Dannani



.

Relevant Pages

  • Re: Sql Server Locks
    ... Tran and Commit Tran are as close together as possible and the transactions ... > The problem is with SQL Server Database Locks. ... > client A and reinserts the same with some data changes ... > provide us any good links for this kind of scenarios. ...
    (microsoft.public.sqlserver.clients)
  • Re: How to switch off automatic blanking of table views in enterprise manager ?
    ... Optimizing Query Performance - ... SQL Server is essentially a puppet of the client application. ... for) the locks acquired on the server. ... blocking problems involves inspecting the client application. ...
    (comp.databases.ms-sqlserver)
  • Re: Synchronization between 2 PHP threads?
    ... >> means I have to consider multiple threads of the same PHP script running ... > fork a PHP - but that creates a new process, ... Table A is a client table. ... why use discretionary locks over table locks? ...
    (comp.lang.php)
  • Re: Synchronization in .Net Remoting
    ... the related server side object code has been posted. ... > is the related client side code: ... > the locks before doing processing and then release all the locks. ... >>> different locks on different remote objects before performing any real ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Overlapped file locking doesnt work on NT4?
    ... One locks the file then unlocks it, ... each client has to close the file after ... seems to lock and unlock internally? ... Speaking of "contact MSFT", NT4 support has been officially discontinued, ...
    (microsoft.public.win32.programmer.kernel)
Loading