Why am i getting the error in Linked server :
Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "SQLNCLI" for linked server "Xyz".
Mostly thie error appear when the link table referance is not made correctly. The select statement should refer the linked server table as
linkserver name.database.dbo.table.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment