>>Thanks for the info.... I was able to figure out what I had to do. Basically I used a DELETE TRIGGER in the code to shut it down while executing the code.
>
>And how would you get the darn thing back in again?
I only needed it turned off while executing this small program (turned off for speed performance increase - I took care of the referential integrity myself during the deletions). I did not need it turned back on during the execution of the program.
After the program finished, any other programs (or just opening the table), would once again see the trigger and execute it if deletions were performed.
You can restore it if necessary by issuing a
CREATE TRIGGER ON the_table_in_question FOR DELETE AS __ri_DELETE_the_table_in_question()
Tommy
Tommy Tillman A+ NetWork+ MCP