Linked Server T-SQL - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Linked Server T-SQL

Author

Topic

NickyJ
Starting Member

46 Posts

Posted - 2005-08-03 : 07:04:30

Hi all,

I am running the following T-SQL which is resulting in the following error :

T-SQL : SELECT * from adapt.londev3.sys01.adverts

"Server: Msg 7315, Level 16, State 1, Procedure vw_njp_details, Line 2
OLE DB provider 'MSDASQL' contains multiple tables that match the name"

Anyone help at all, I've tried using OPENQUERY but when using this method I get

"Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'select * from archive'. The OLE DB provider 'MSDASQL' indicates that the object has no columns."

???

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-03 : 07:16:25

Refer this
http://support.microsoft.com/kb/270119/EN-US/

Madhivanan

Failing to plan is Planning to fail

NickyJ
Starting Member

46 Posts

Posted - 2005-08-03 : 10:05:41

Thanks for that article though I'm not doing any updates or deletes. To me looks as though SQL is seeing two objects for each table, a Table and a View and both are called the same which would make sense regarding the message.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources