Posted by MC on 01/06/07 08:04

Let me just add something here.
You need to check for performanse before deciding to go that way. If you
need high performance, triggers really need to be tested before you commit
yourself in doing things that way.


MC


"Ted" <r.ted.byers@rogers.com> wrote in message
news:1168054494.981787.125540@51g2000cwl.googlegroups.com...
>
> Erland Sommarskog wrote:
>> Ted (r.ted.byers@rogers.com) writes:
>> > "Can we use a distributed SELECT statement in a view?"
>>
>> Yes.
>>
>> > and "Can we create a foreign key constraint that references a column
>> > in a
>> > view?"
>>
>> No. Foreign keys are inside the database. To keep cross-database of
>> cross-server referential integrity, you will have to use triggers.
>>
>>
>
> Thanks Erland.
>
> Ted
>>
>> --
>> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>>
>> Books Online for SQL Server 2005 at
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
>> Books Online for SQL Server 2000 at
>> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

• Next in forum: Re: How do I reference a table in one database from a SQL script running in another database?
• Prev in forum: Re: How do I reference a table in one database from a SQL script running in another database?
• Thread view: Re: How do I reference a table in one database from a SQL script running in another database?

[Reply to this message]