Is there a way that all the triggers associated with a table can be
turned off ? I would like to be able to bulk load a table ( I have to
use inserts not copy ) and I don't want the triggers to fire. Once
loaded I want to turn them back on again. This process will be repeated
quite often ( during the development phase).
I could delete then add them again but I am hoping these is an easier
way.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015