Friday, February 24, 2012

Export to Excel

I have a big report which I want to export t oexcel. I get an error with timeout as it is a big fine. Does anyone have a suggestion as to how I can change the timeout? I tried to run the file on server early morning with File to Delivey option.

regards

Josh

Yes, you can define that, the Report Excecution to Excel is just another way to render the report. See more details on:

Setting Time-out Values
http://msdn2.microsoft.com/en-us/library/aa274413(SQL.80).aspx

Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment