Solved

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

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

Accepted Solution

by:
Wouter Boevink earned 20 total points
Comment Utility
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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now