i have a trigger that does an update at the end of a data pull, but if a user is in the record the trigger halts until timeout or until the lock is manually released or the user exits the record.
is there anyway for me to simply say if the update timeout is > 5secs than continue without update? or any other way to over come the issue?
below is the update part of the trigger
update h set h.analysis_c='D/L'
from [line500V7\SAGE].cs3live.scheme.crrethdm h with (rowlock)
join (select returns_log collate Latin1_General_CI_AS as returns_log from dbo.returns_hdr where manifestid=@manifestid) as t1