not able to create linked server since remote serv

  • 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

  • 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

  • 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