December 10, 2003 at 10:38 pm
I made a merged replication between server1 and server2. Now i found that server2 is automatically configured as a remote server in server1 and server1 is configured as a remote server in server2. replixcation works no problem with that.
now i want to create a distributed partitioned view between authors table of pubs of these two servers. for that I have to declare server2 as a linked server in server1. since it is already configured as a remote server it does not allow me to add as a linked server. kindly suggest me what to do
thanks and regards
Anil
December 10, 2003 at 10:45 pm
forgot one point. mine is sql server 2000 standard edn. books online says the following
"Only the Developer and Enterprise Editions of SQL Server 2000 allow INSERT, UPDATE, and DELETE operations on partitioned views."
But I am aiming only select
my statement is
create view view1
as
select * from authors
union all
select * from server2.pubs..authors
pl help
December 11, 2003 at 6:00 am
What error is showing?
Is it server2 configured for remote access?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply