I have an OLEDB connection that is pulling phantom records from time to time because of an inability to set an isolation level (I think) because our shop does not use transactions.
Is there another way I could do this? I thought doing a "select...for update" might make the OLEDB process wait for a good intent lock but it doesnt seem to work.
Is there another way I could do this? I thought doing a "select...for update" might make the OLEDB process wait for a good intent lock but it doesnt seem to work.