Relationship to table in another DB possible?

Is it possible to create a relationship to a table in another database,
either on the same server or a linked server?
- Dave
Hi
Foreign Keys are not possible across databases, you can create a check
constraint that calls a function (which may prove slow!) or enforce the
constraint in a trigger.
John
"David Slinn" <dslinn@.accesscomm.ca> wrote in message
news:eSZJ5e%23oEHA.1588@.TK2MSFTNGP09.phx.gbl...
> Is it possible to create a relationship to a table in another database,
> either on the same server or a linked server?
> - Dave
>
|||Creating a foreign key across databases is not possible; however, you can
enforce cross-database relationships using triggers.
"David Slinn" <dslinn@.accesscomm.ca> wrote in message
news:eSZJ5e%23oEHA.1588@.TK2MSFTNGP09.phx.gbl...
> Is it possible to create a relationship to a table in another database,
> either on the same server or a linked server?
> - Dave
>

Relationship to table in another DB possible?

Is it possible to create a relationship to a table in another database,
either on the same server or a linked server?
- DaveHi
Foreign Keys are not possible across databases, you can create a check
constraint that calls a function (which may prove slow!) or enforce the
constraint in a trigger.
John
"David Slinn" <dslinn@.accesscomm.ca> wrote in message
news:eSZJ5e%23oEHA.1588@.TK2MSFTNGP09.phx.gbl...
> Is it possible to create a relationship to a table in another database,
> either on the same server or a linked server?
> - Dave
>|||Creating a foreign key across databases is not possible; however, you can
enforce cross-database relationships using triggers.
"David Slinn" <dslinn@.accesscomm.ca> wrote in message
news:eSZJ5e%23oEHA.1588@.TK2MSFTNGP09.phx.gbl...
> Is it possible to create a relationship to a table in another database,
> either on the same server or a linked server?
> - Dave
>

Registered Server v/s Linked Server

Hello All,
What is the difference between a registered server and a linked server? If
in Query Analyzer one can reference objects using fully qualified names in a
linked server like this:
SELECT * FROM LinkedServer.Northwind.dbo.Products
why can't one do the same by registering the remote server (which is in the
same domain) and then referencing it?
Thanks somebody; help please. This has me baffled!
Jerome SmithRegistering servers if for the mmc console and information
that the snap in needs to access the server. A registered
server in the mmc console doesn't know anything about the
other registered servers, just the mmc console does.
With linked servers, the information is for SQL Server
itself so that it can access data or do whatever.
If registering servers automatically allowed the
functionality of linked servers, you'd lose a lot of control
over security, distributed queries, etc.
-Sue
On Wed, 12 Nov 2003 22:51:58 -0400, "Jerome Smith"
<jerosmith@.hotmail.com> wrote:
>Hello All,
>What is the difference between a registered server and a linked server? If
>in Query Analyzer one can reference objects using fully qualified names in a
>linked server like this:
>SELECT * FROM LinkedServer.Northwind.dbo.Products
>why can't one do the same by registering the remote server (which is in the
>same domain) and then referencing it?
>Thanks somebody; help please. This has me baffled!
>Jerome Smith
>|||Thanks Sue,
Now I still have the question: what is the purpose of registering servers?
What can one do with registered servers?
Thanks again.
Jerome
"Sue Hoegemeier" <Sue_H@.nomail.please> escribió en el mensaje
news:u4p7rvko25h1l9e4objkancqto2q2395qr@.4ax.com...
> Registering servers if for the mmc console and information
> that the snap in needs to access the server. A registered
> server in the mmc console doesn't know anything about the
> other registered servers, just the mmc console does.
> With linked servers, the information is for SQL Server
> itself so that it can access data or do whatever.
> If registering servers automatically allowed the
> functionality of linked servers, you'd lose a lot of control
> over security, distributed queries, etc.
> -Sue
> On Wed, 12 Nov 2003 22:51:58 -0400, "Jerome Smith"
> <jerosmith@.hotmail.com> wrote:
> >Hello All,
> >
> >What is the difference between a registered server and a linked server?
If
> >in Query Analyzer one can reference objects using fully qualified names
in a
> >linked server like this:
> >
> >SELECT * FROM LinkedServer.Northwind.dbo.Products
> >
> >why can't one do the same by registering the remote server (which is in
the
> >same domain) and then referencing it?
> >
> >Thanks somebody; help please. This has me baffled!
> >
> >Jerome Smith
> >
>
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.536 / Virus Database: 331 - Release Date: 03-11-03|||So that you can manage all the registered servers through
one mmc console using Enterprise Manager. A registered
server gives you access through Enterprise Manager.
-Sue
On Sat, 15 Nov 2003 00:19:11 -0400, "Jerome Smith"
<jsmith@.gauss.cl> wrote:
>Thanks Sue,
>Now I still have the question: what is the purpose of registering servers?
>What can one do with registered servers?
>Thanks again.
>Jerome
>"Sue Hoegemeier" <Sue_H@.nomail.please> escribió en el mensaje
>news:u4p7rvko25h1l9e4objkancqto2q2395qr@.4ax.com...
>> Registering servers if for the mmc console and information
>> that the snap in needs to access the server. A registered
>> server in the mmc console doesn't know anything about the
>> other registered servers, just the mmc console does.
>> With linked servers, the information is for SQL Server
>> itself so that it can access data or do whatever.
>> If registering servers automatically allowed the
>> functionality of linked servers, you'd lose a lot of control
>> over security, distributed queries, etc.
>> -Sue
>> On Wed, 12 Nov 2003 22:51:58 -0400, "Jerome Smith"
>> <jerosmith@.hotmail.com> wrote:
>> >Hello All,
>> >
>> >What is the difference between a registered server and a linked server?
>If
>> >in Query Analyzer one can reference objects using fully qualified names
>in a
>> >linked server like this:
>> >
>> >SELECT * FROM LinkedServer.Northwind.dbo.Products
>> >
>> >why can't one do the same by registering the remote server (which is in
>the
>> >same domain) and then referencing it?
>> >
>> >Thanks somebody; help please. This has me baffled!
>> >
>> >Jerome Smith
>> >
>
>--
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.536 / Virus Database: 331 - Release Date: 03-11-03
>