Post reply

Problem With linked Servers

  • July 15, 2003 at 10:55 am

    #161829

    Hi!

    I have two Sql Servers ( A and B ).

    In the linked server section of Server A, I've linked B.

    In Server A, Database Db01, I have a View (Vw01) referencing a table in the linked server.

    <pre

    Vw01:

    select*

    from B.Db02.dbo.Tbl02

    /pre>

    Then, when I try to update data in Vw01 I get the error 7306

    Could not open table '%ls' from OLE DB provider '%ls'. %ls

  • July 15, 2003 at 11:34 am

    #465573

    You may be getting this error because you don't have a unique index defined in Tbl02. The only way to really tell what is going on is by running a trace in SQL profiler on OLE DB errors.

    All the best,

    Dale

    Edited by - DALEC on 07/15/2003 11:34:26 AM


    All the best,

    Dale

    Author: An Introduction to SQL Server 2005 Management Studio

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply