trigger on sysobjects
Posted on 1998-04-20
the system allows creation of triggers on sysobjects table. this works fine when one does changes to the sysobjects table after setting 'allow updates' option on. however, the trigger does not fire, when let's say you compile a procedure, which also goes through dropping and recreating a procedure. i am wondering about the difference in two scenarios.