Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Foreign key from another table in a linked server

Author  Topic 

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-04-19 : 00:55:27
Hi,

We're having a few linked servers in our company. some tables in one of the linked servers include columns (better saying, foreign keys) of tables in another server. I wonder if there's a way to create a foreign key referencing one columns in another server. That is, suppose there's Column A in table A in Server A which references Column B in table B in server B, is there a way to create column A as foreign key referencing column B?

Any idea is appreciated.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-19 : 01:08:27
Dup post:-

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101322
Go to Top of Page
   

- Advertisement -