Seems a good idea. I did not knew about this, but seems to be the behavior I need.

The only problem I see is that the stored path must be relative...

No, they are more than 2000 triggers (1000+ tables, triggers for insert and delete that record some specific details when some specific conditions are met...)

We will have several database on the same instance, all of them should have the same set of tables, and there is code that references them (triggers on different schemas...