So... after every insert, delete all records from the table? Doesn't that defeat the whole purpose that this table serves?
Seems to me that's more of a 'gimp' than a 'cleanup'.
Unable to unlock jobs in v8
Moderators: chulett, rschirm, roy
Good point. I am starting a new posting to deal specifically with the trigger or any other methods to remove logical locks from the XMETALOCKINFO table:
Methods for cleaning locks in XMETALOCKINFO table
Brad.
Methods for cleaning locks in XMETALOCKINFO table
Brad.
It is not that I am addicted to coffee, it's just that I need it to survive.