Error running query

Question

Error running query

Mike Levan

SSChampion

Points: 14201
More actions
December 19, 2008 at 1:55 pm

#128760

When i run the follwing query i get this error though my link server is working fine. my link server runs with sql login.
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "ServerC" does not contain the table ""db1"."dbo"."table3"". The table either does not exist or the current user does not have permissions on that table.
select * into #temp
from serverA.db1.dbo.table1
union
select * from serverB.db1.dbo.table2
union
select * from serverC.db1.dbo.table3

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

What is the error? You didn't include it in the post anywhere.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Mike Levan SSChampion Points: 14201 More actions · Answer 2

pls check back my post i have edited with error mesg.

Garadin One Orange Chip Points: 29613 More actions · Answer 3

Right, and what is your question? By your error message, the table either does not exist, or you do not have permissions to it.

A lot of times these issues involve incorrect schemas. Make sure that the table exists with the schema of dbo, and not some user schema. If you're verifying that the table exists with something like:

Select top 10 * from table3

Then you're skirting around the problem.

Seth Phelabaum

Consistency is only a virtue if you're not a screwup. 😉

Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

My vote is permissions. Verify the SQL Server login you created for the linked server has rights to the database and table.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 5

Also that it's going to the right database. I've seen the default database used and it isn't immediately obvious.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning