MS SQL 2000 "timeout expiried"

所有回覆

• 

  

  0

  登入以投票

  Hi
  
  have you tried to re-implement the stored procedure to see if you could improve the performance, so that it can complete before timeout? (to avoid timeout)
  
  Can you set the command timeout to 0 or longer to avoid the time out error? (I am sorry to tell you that I do not know if you can change the timeout to be unlimited time)
  
  Another though is: If you have any table that you are going to update it in use/ opened? It may cause timeout/ take very long time to update. (It happened to me before)
  
  Please correct me if I am wrong.
  
  Many thanks
  

  2008年6月19日 下午 03:37

  回覆

  |

  引述
• 

  

  0

  登入以投票

   

  Thanks for your reply

   

  Do you have any methods/tools to check if the table is opened?

   

  Also, I have one more question.

   

  We can configure the remote query timeout with "exec sp_configure N' exec N'remote query timeout (s), 1000" command.

   

  How to use it? And what is the different between N'remote query timeout and the command timeout?

   

  Thank you very much!

  2008年6月19日 下午 03:57

  回覆

  |

  引述
• 

  

  0

  登入以投票

  homeendd wrote:

  what is the different between N'remote query timeout and the command timeout?

   

  Remote Query is when your query is executing in that server but also having external connection to call remote execution to remote connected server.

   

  Command one means those commands which is executing in local SQL Server.

  2008年6月20日 上午 04:22

  回覆

  |

  引述
• 

  

  0

  登入以投票

  homeendd wrote:

  Do you have any methods/tools to check if the table is opened?

  
  
  I am sorry to tell you that, i do not know if there any way to check if the table is open.
  
  Sorry
  

  2008年6月20日 上午 07:20

  回覆

  |

  引述
• 

  

  0

  登入以投票

  Table is always available if database is online.

  2008年6月20日 下午 02:15

  回覆

  |

  引述