Can anyone give me some tips on how to best maintain referential integrity
across databases? I have multiple databases whose tables contain foreign
keys referencing primary keys in other database tables. I want to make sure
that a deletion cannot occur if tables in other databases are referencing
the record to be deleted. In other words, I don't want to orphan these records.

I was thinking of using triggers, but not sure if this is best.