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. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
