query view through linkserver is not working

Last Post 13 Mar 2008 10:40 PM by SQLUSA. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
jchung05
New Member
New Member

--
10 Mar 2008 06:56 PM
Hi all,
I created a link server connecting to another sql server 2000. But I launched a view through link server the result would never return. I am wondering can I do that? If I logged in as the user id in the link server to the remote box and queried the same statementI can get the result. can someone explain why? thanks in advance!

my statement:
select * from LinkServer.remoteDB.dbo.ViewName
jchung05
New Member
New Member

--
11 Mar 2008 05:14 AM
Thanks gunneyk, I used same setup in another box, also setup as linkserver query the view but this time returned the correct result which on the first box never got and hang the connection. I just can't explain. not sure that would be something setup differently. I will investigate that later. thanks anyway for your suggestion.

Jimmy
SQLUSA
New Member
New Member

--
13 Mar 2008 10:40 PM
Something must be different!

What is it?

How about table SELECTs?

Have you tried OPENROWSET?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/ SQL Server 2008 Training
You are not authorized to post a reply.

Acceptable Use Policy