[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Will stored procedure execution be timed out in a sql server ? If so where to specify that time out value?

Posted on 2009-04-16
Medium Priority
Last Modified: 2012-06-27
if i execute a stored procedure in my sql server i want to know after how long will that sp gets timeout error, if so.
And where can i specify that.
Question by:nirmalkgupta
  • 4
  • 2
LVL 60

Accepted Solution

chapmandew earned 500 total points
ID: 24158609
If you run it in managment studio, it will not time out by default.  you can go to tools, options, query execution and specify a timeout there if you want one.

if you're connecting to sql througha  web app or something similar, the connection itself specifies the timeout.

Author Comment

ID: 24158732
You got real perfect answer.

I am aware of specifying time out when calling from other clients.
But i am looking for timeout from within a sql server itself.

I need one more option. can i programatically specify this timeout option in my stored procedure if i want to ?

LVL 60

Expert Comment

ID: 24158788
Nope, you can't.  It is based upon the connection made to SQL, so you can't really specify once you're connected to SQL.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 24158817
Ok. Great

Thanks for the reply

Even in msdn forums, i didnt get the answer that you gave.

Thanks for your reply once again

LVL 60

Expert Comment

ID: 24158848
very welcome.  glad to help.  

lots of times...EE is better than MSDN forums.  :)
LVL 60

Expert Comment

ID: 24158852
please close out the question, by the way.

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

872 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