Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

four part naming not woprking Expand / Collapse
Author
Message
Posted Sunday, January 13, 2013 4:31 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 7:01 AM
Points: 51, Visits: 303
select * from linkedserver.database.dbo.table where 1=2

Returns:

Non-interface error: Invalid schema or catalog specified for the provider

how can we get around this?

Thanks

Post #1406529
Posted Sunday, January 13, 2013 7:45 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:07 PM
Points: 21,351, Visits: 15,032
Here is a similar thread. See if it helps.

http://www.sqlservercentral.com/Forums/Topic439890-149-1.aspx#bm440689




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1406545
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse