Aarvee
Well-known member
Hi !
For purposes of administration and categorisation, I have split the database into multiple portions ( aka different databases ). For example all my masters are in Masters Database whereas all my Transactions are in Transactions Database. I would like to set up a relationship between say a table in transactions database and another table in Masters Database.
Can someone help me how to do this in SQL Server 2000 ?
Thank you in advance for your support and guidance.
Varadarajan R
For purposes of administration and categorisation, I have split the database into multiple portions ( aka different databases ). For example all my masters are in Masters Database whereas all my Transactions are in Transactions Database. I would like to set up a relationship between say a table in transactions database and another table in Masters Database.
Can someone help me how to do this in SQL Server 2000 ?
Thank you in advance for your support and guidance.
Varadarajan R