Hi can any of you tell me how I can achieve the same or atleast mimic the behaviour.
What i want to achieve is that there are two independent tasks each having no clue of the others existence and one of the tasks reads from a table and the other deletes and writes into this table. I want the delete and write to occur only when there are no reads being performed.
With the current configuration my task runs into a deadlock and sql kills the latter task.
Thanks in advance.