Thread: Connection with SQL Server generate "Timeout expired"
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
  
Posts: 233
Default Connection with SQL Server generate "Timeout expired"
Maybe start using a T-SQL stored proc for this?

Also in Query Analyzer run the optimizer to see if you missed any
indexes. Either your SQL server is underperforming or not fully
optimized.

DM Unseen

Reply With QuoteReply With Quote