Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2008-10-16 : 11:02:29
|
| Hello,I have created a linnked server on serverA to ServerB. When I run select query on serverA for a database in serverB I get an error except for one database.The error is Msg 7314, Level 16, State 1, Line 1The OLE DB provider "SQLNCLI" for linked server "ServerB" does not contain the table ""database"."dbo"."table"". The table either does not exist or the current user does not have permissions on that table.Can someone help me?Thanks,-S |
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2008-10-16 : 11:06:24
|
| Sorry guys. I forgot to add other databases to the link server login. Now the sql works fine. |
 |
|
|
|
|
|
Linked Server