Re: Distributed Query Strangeness

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: T. (tmorris_at_firstegg.ihatespam.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 14:37:02 -0500

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
> >
> >
>
>

Relevant Pages

  • SecurityFocus Microsoft Newsletter #152
    ... MICROSOFT VULNERABILITY SUMMARY ... Real Networks Helix Universal Server Remote Buffer Overflow ... ... NEW PRODUCTS FOR MICROSOFT PLATFORMS ...
    (Focus-Microsoft)
  • Re: Stored Procedure Fails Only When Called By Agent
    ... Stored Procedure 1: ... EXEC sp_addlinkedserver '10.1.2.10', 'SQL Server' ... LOCALMACHINE\myaccount/pass3, the same account that owns the job. ...
    (microsoft.public.sqlserver.replication)
  • SecurityFocus Microsoft Newsletter #140
    ... Cafelog b2 Remote File Include Vulnerability ... Webfroot Shoutbox Remote Command Execution Vulnerability ... Pablo Software Solutions Baby POP3 Server Multiple Connection... ... Microsoft Windows XP Nested Directory Denial of Service... ...
    (Focus-Microsoft)
  • RE: SBS 2003 sudden services problem over router based vpn
    ... I understand that your remote cannot receive POP3 emails through VPN ... SBS Server through routers. ...
    (microsoft.public.windows.server.sbs)
  • RE: Download connection Manager through RWW
    ... the issue may occur due to the Remote VD is ... Then please rerun the CEICW wizard and Configure Remote access wizard ... Start Internet Explorer. ... Since the Symantec anti-virus application installed on the server, ...
    (microsoft.public.windows.server.sbs)