query timed out

• Hollyz

  SSCommitted

  Points: 1763

  More actions

  December 24, 2008 at 10:24 am

  #197502

  I am trying to do import/export task in sql 2005 by importing the results of a large, large query into an excel file. While I was providing a Source Query , and I try to hit the next button I got this error: The statement could not be parsed. Additional Information: Deferred prepare could not be completed. Query timeout expired (microsoft sql native client).

  This happen after about 50 second or so.

  If I ran this same query in a query analzyer in sql 2005, it runs in about 7 minutes without problem.

  Anyone have a solution to this?

  Thanks

• ESAT ERKEC

  SSCertifiable

  Points: 5661

  More actions

  December 26, 2008 at 2:42 am

  #917721

  I think you can create a temp table and insert the proc dataset in this table and then you can export this table.

  Esat Erkeç