Just forgot to mention: Referencing in previous open/attached databases should also be possible with foreign key constraints, when they will be enforced...
Marc On Thu, 2007-06-21 at 11:57 +0200, Andre du Plessis wrote: >> Is it possible to do this: >> >> Open DB1 >> >> Attatch DB2 >> >> In DB1 have a trigger that does >> >> Insert into DB2. ? >> >> Theoretically it seems possible but we couldn't get it to work. Before I >> investigate further just want to know if it is possible >No. A trigger may only reference objects in it's own database. >You should be getting an error message along the lines of >"cannot reference object in database XXX" when you create >the trigger. > >Dan. > It would be very helpful to have the possibility creating a trigger in DB2 referencing DB1. "Open DB1" "Attach DB2" (DB2 has trigger: "Insert into DB1") Of course, if just "Open DB2" (DB2 has trigger: "Insert into DB1") This would give an error. Marc ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------