Page 2 of 2

Posted: Thu Nov 06, 2008 7:21 pm
by chulett
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'.

Posted: Mon Nov 24, 2008 12:59 pm
by bcarlson
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.