One-to-Many Relationships

• Eroshenko

  Old Hand

  Points: 377

  More actions

  August 28, 2001 at 9:46 am

  #77695

  Is it possible to create relationship between 2 tables from different databases in SQL SERVER 2000 ?

  Thanx

• Brian Knight

  One Orange Chip

  Points: 27249

  More actions

  August 28, 2001 at 9:51 am

  #417837

  Unlike other DBMS's SQL Server cannot do this through DRI. To enforce this type of RI, you will have to use triggers.

  Brian Knight

  bknight@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bknight

  Brian Knight
  Free SQL Server Training Webinars