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.
>
>