Hi All,
I have two Databases on a MS SQl 7.0 Server. On one of the tables in Database A, I can put any number of triggers on this table and it hold it resident. However on Database B, when I go to attach a third trigger to the table it overwrites the last. It won't allow me to add three onto the table. Its like the maximum for the table is two. Is this a configuration issue?? as version 7 should let you attach numerous triggers.
Does anyone have an idea of why this occurs??
Regards
Anthony
I have two Databases on a MS SQl 7.0 Server. On one of the tables in Database A, I can put any number of triggers on this table and it hold it resident. However on Database B, when I go to attach a third trigger to the table it overwrites the last. It won't allow me to add three onto the table. Its like the maximum for the table is two. Is this a configuration issue?? as version 7 should let you attach numerous triggers.
Does anyone have an idea of why this occurs??
Regards
Anthony