Hi Sergey,

Too bad, would have been nice.

I haven't used triggers much.

You wouldn't have an example of such a trigger?

>Hi Peter,
>
>SQL Server doesn't support cross databases persistent relationships. You'll have to use triggers for RI in such case.
>
>
>>Let's assume the table table Currencies, stored with similar system-wide global info tables in one database, GlobalStuff.
>>
>>It would be nice to be able to create persistent relationships to this table from different databases, but the diagram designer only shows tables from the current database.
>>
>>