[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

200pts+, Timeout expired for executing ms-sql store procedure?

Posted on 2002-07-10
2
Medium Priority
?
143 Views
Last Modified: 2008-02-26
0
Comment
Question by:AStronus
2 Comments
 
LVL 12

Accepted Solution

by:
Wouter Boevink earned 80 total points
ID: 7148618
You got your question answered?

I'm a bit worried about the timeout. Maybe there's something you can do. Finetune the stored procedure. Create indexes use the Index Tuning wizard.
0
 

Author Comment

by:AStronus
ID: 7149614
yes I change connectionstring to connect by command and set the command timeout higher like 300 and it's work, connectiontimeout doesn't work for me
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question