How to do an update only if it will not be blocked by a lock ?

Hi,
I've got a stored proc called concurrently with different parameters.
In this proc, I would like to update a row of a statistic table but ONLY if
the update statement will not be blocked by a lock.
Is there any way to achieve this in SQL2000 ?Hi
> In this proc, I would like to update a row of a statistic table but ONLY i
f
> the update statement will not be blocked by a lock.
When one resource is blocked then you can't any way update except wait for
the resourse.If you dont want to wait for the resource then you can terminat
e
it through code. well you can set Lockout time and also check whether the
sproc is taking more time than that so that you can simply log the error
instead of waiting.
I f it is a deadlock then sql server returns Error: 1204 which you can catch
in @.@.error and take procedure to logical end.
If I understand you correctly, you want to avoid contention on a resourse so
that others can have access to the table.
We can sugget better answer only when we know fully what's problem is. Post
detailed problem
--
Regards
R.D
--Knowledge gets doubled when shared
"SoftLion" wrote:

> Hi,
> I've got a stored proc called concurrently with different parameters.
> In this proc, I would like to update a row of a statistic table but ONLY i
f
> the update statement will not be blocked by a lock.
> Is there any way to achieve this in SQL2000 ?
>
>|||Ok I've done this (we are inside a transaction):
SET XACT_ABORT OFF
SET LOCK_TIMEOUT 0
UPDATE MyTable WITH (ROWLOCK) SET ...
SET LOCK_TIMEOUT -1
SET XACT_ABORT ON
And it seems to work.
The only thing, I got an error in the query analyser when the update has
been aborted, but I think it can be safely ignored.