# 3870 Cannot Alter Triggers that Contain Errors

---

I have occasionally made an error in a configuraton change (Trigger alterations usually) which will usually result in a UE in EDB manager, and then the entire database is basically dead. Even after a machine restart I can't open tables, reverse engineer the DB, drop anything etc.

EDB Manager will still work on other databases (even under the same session), but try to select any object in the database and I get an EDB Error #700. The message tells me where the problem is (in this particular case it is in an After Delete trigger). I had a call to a procedure that took as a parameter an "OLDROW" value, but once I realised that was problematic, I changed both the procedure (so that it didn't require the parameter) and the trigger so it didn't pass it. However the error message seems to think the trigger is trying to call the procedure with the parameter and is saying that there is an invalid number of parameters specified.

In the past, I have managed to fix this problem by simply reinstating the parameter in the procedure so everything is "in sync" and then reversing out the changes in a different order, but this time EDB won't allow me to edit the procedure (when I try I get the #700 error with the trigger message).