Re: Creating relationships between different databases

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 09:21:49 +0530

>>Does SQL Server supports this kind of operation?<<

Cross database ref. integrity is not supported in SQL Server.

BOL: "FOREIGN KEY constraints can reference only tables within the same database on the same
server. Cross-database referential integrity must be implemented through triggers. For more
information, see CREATE TRIGGER. "

So this can be accomplished through triggers.

See following topic in bol.

"FOREIGN KEY Constraints" 

-- 
Vishal Parkar
vgparkar@yahoo.co.in

Relevant Pages

  • Re: ADO/MDAC on Terminal Server
    ... XP database system to SQL Server 2000. ... front end is running on the Terminal Server. ... MDB file due to fixes and modifications, ... "missing reference" error as the MDB file opens up. ...
    (microsoft.public.data.ado)
  • Re: Desktop SQL Server
    ... It's also hard to provide you with a better reference because you didn't ... uninstalled when the SQL server is installed. ... Server but, according to my reading on this, the Microsoft Jet Engine ... who runs an application that uses the SQL Server will have to uninstall ...
    (microsoft.public.access.externaldata)
  • Re: Wartungsplan schlägt teilweise fehl
    ... aus BOL SIMPLE is the default setting for SQL Server Personal Edition ... Die master-DB hat immer simple. ... Sicherung der Datenbank und alle Sicherungen der Tranaktionslogs. ... Lesestoff dazu im "SQL Server 2000 Operations Guide": ...
    (microsoft.public.de.sqlserver)
  • Re: Indexed Views
    ... >> wrong or the functionality was added with the SP's) ... The BOL information was wrong in the RTM version. ... SQL Server Documentation Team ... > "Tom Moreau" wrote in message ...
    (microsoft.public.sqlserver.server)
  • SQL Server/ADO/XP problem "query cannot be executed"
    ... This is a request for help fixing a SQL Server 2000/ADO problem on Windows ... When I open one of these projects in VB6, the reference to msado27.tlb is ... Most people trying to help are treating it as an installation issue, ...
    (microsoft.public.sqlserver.programming)
Quantcast