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 |
|
MBeal
Posting Yak Master
110 Posts |
 Posted - 2002-11-27 : 17:35:52
|
| I have two servers running SQL2000 as instances. Both servers are linked to each other. When I am on one of the servers and I try to run a simple query... (Select * from [abc\abc2000].databasename.dbo.tablename) to pull data from the other I get the following message:Server: Msg 7314, Level 16, State 1, Line 1OLE DB provider 'Xena\Xena2000' does not contain table '"V1Data"."dbo"."stay"'. The table either does not exist or the current user does not have permissions on that table.When I run that same query but change it to Northwind.dbo.employees I am able to retrieve the data. What have I missed?MBeal |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-11-28 : 00:36:56
|
| Have you checked the existance of the table and the permissions on both servers. |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-11-28 : 00:46:19
|
| And I know this is tedious - but just check that the table is actually owned by dbo - that's where I fell in a heap ---I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Linked Servers