INSERT takes ages...

From: hansje (hansjes_at_anonymous.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 08:11:04 -0800

Hi there,

On a remote server I execute the following

EXEC [REMOTE_SERVER].master.dbo.xp_fixeddrives

I receive a result within a few seconds. Now I wish to put the resultset
in a tmptable:

CREATE TABLE #tmpTable(
                Drive char(3),
                Freespace varchar(10)
)

INSERT INTO #tmpTable
EXEC [216.113.155.219].master.dbo.xp_fixeddrives

SELECT * FROM #tmptable
DROP TABLE #tmptable

Now it takes forever! After a minute I cancel the query, don't know how
long it would take to finally end or timeout. Any reason for this
behaviour? I'm flabbergasted!

Tnx,

Hans Brouwer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: recordset not opening even though query analyzer returns resul
    ... I'm convinced that VB can execute this complex SP. ... > only way i could get an earlier version of it to return in a recordset. ... > table into a cursor and add up th evalues of the ccjs based on values in ... >> execute a query the SQL engine returns a resultset. ...
    (microsoft.public.vb.database.ado)
  • Re: sqlCeResultSet readPrevious() method doesnt work always after a readAbsolut(currentPosition)
    ... On the desktop site the application is using MS Access. ... you now call ReadAbsoluteon rs2, a value of -1 is returned. ... When i execute a readPreviousafterwards, the resultset stays at the ...
    (microsoft.public.sqlserver.ce)
  • Re: OT: security
    ... this remote file will be included into ... the script and executed. ... Note that the remote server would have to ... Mechanisms such as the above allow attackers to execute any code they ...
    (comp.lang.php)
  • Re: jdbc query
    ... resultset is not getting executed. ... You can use the execute around idiom to tidy this lot up: ... final EmployerTeam employerTeam ... throws SQLException { ...
    (comp.lang.java.programmer)
  • Re: running complete transactions
    ... the resultset is retrieved from the first select statement, ... --into tableB or tableC before these next two select statements have ... I would be grateful if you could tell me if I have understood the API ... then execute a number of ResultSet ...
    (comp.lang.java.databases)