none
OLE DB provider "SQLNCLI10" for linked server "XXX" returned message "Unspecified error"

    Question

  • Hi,

    I am trying to access data from Linked Server. I have added the other server as linked server and also I am able to access tables from queries. But when I try to access tables from Stored Proc. I get the above error. Can any one help me on this.

    Both the servers are  SQL Server 2008 R2

    Thanks

    Vikram

    Thursday, March 20, 2014 3:35 PM

Answers

All replies