Re: Distributed Query Strangeness
From: oj (nospam_ojngo_at_home.com)
Date: 11/19/04
- Next message: Mikito Harakiri: "Re: Distinct or Group by"
- Previous message: Steve Kass: "Re: delete almost duplicate records"
- In reply to: T.: "Re: Distributed Query Strangeness"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Nov 2004 14:55:08 -0800
Hmm...do you have 'data access', 'rpc out' set for the remote server.
Take a look at 'sp_serveroption' for additional info.
"T." <tmorris@firstegg.ihatespam.com> wrote in message
news:u5ZqO9mzEHA.1300@TK2MSFTNGP14.phx.gbl...
> thanks for the reply, but same result, indefinite hang , no profiler
> activity on remote server..
>
> "oj" <nospam_ojngo@home.com> wrote in message
> news:%23LUXwLmzEHA.3336@TK2MSFTNGP11.phx.gbl...
>> Try this instead:
>>
>> INSERT dbo.MyLocalInventory (column list...)
>> EXEC RemoteServerName.DatabaseName..sp_executesql N'exec
>> usp_GetInventoryData'
>>
>>
>>
>> "T." <tmorris@firstegg.ihatespam.com> wrote in message
>> news:erztvIkzEHA.1452@TK2MSFTNGP11.phx.gbl...
>> > Hi group, I'm creating a web portal where customers can search for
>> > inventory
>> > which originates on remote servers/databases. I want to physically
>> > copy
>> > this data to the portal server rather than have partitioned views...
> I've
>> > written a stored procedure for each source database that selects the
> rows
>> > I
>> > need. The plan was to have the portal server call each remote
>> > procedure
>> > overnight to get the latest data via the linked server option. This
> works
>> > just fine UNTIL - I try to call the remote proc as a clause of the
> INSERT
>> > statement. I.e., this works, I get a result set in under 1 second:
>> >
>> > EXEC RemoteServerName.DatabaseName.dbo.usp_GetInventoryData
>> >
>> > this doesn't
>> >
>> > INSERT dbo.MyLocalInventory (column list...)
>> > EXEC RemoteServerName.DatabaseName.dbo.usp_GetInventoryData
>> >
>> > it hangs indefinitely...doesn't time out. If I run profiler on the
> remote
>> > server I don't see the remote proc execute. Any ideas?
>> >
>> > Thanks
>> >
>> >
>>
>>
>
>
- Next message: Mikito Harakiri: "Re: Distinct or Group by"
- Previous message: Steve Kass: "Re: delete almost duplicate records"
- In reply to: T.: "Re: Distributed Query Strangeness"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
