Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 7306 when Updating Data on Linked SqlServer
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00810274
Message ID:
00811603
Views:
19
Hi Arnaldo,

Take a look at Error 7306 in the Sql Server Books online (BOL). It includes an explanation on how to troubleshoot it.



>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.
>
>Vw01.
>select *
>from B.Db02.dbo.Tbl02
>
>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
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform