Sql Server Timeout expired. The timeout period elapsed prior to completion of the operation

home » blogs » Vivek Thakur » Sql Server Timeout expired. The timeout period elapsed prior to completion of the operation

Sql Server Timeout expired. The timeout period elapsed prior to completion of the operation

(0)

(865)

Avg: 0/5: (0 votes)

posted 12/9/2011 by Vivek Thakur

The default SqlCommand timeout is 30 seconds, so you might get this error while executing a lengthy Sql operation (like creating a DB and its schema via C# code):

Error : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

In order to fix this, just increase the command time out as follows:

myCommand.CommandTimeout = 120; // 2 min

(where mycommand is a SqlCommand object)

Comments (no comments yet)

Add a new comment

Latest community blog posts

ASP.NET: Get formauthentication cookie and get the data present in it

yesterday by Raghav Khunger

Views: 54 - Comments: 1

A person asked me today how to get form authentication cookie and get the data present in it. I decided to write a short blog on it. Formauthentication cookie is saved with the name which we can get via FormsAuthentication.FormsCookieName property. The key here is to get the cookie via this name and...
ASP.NET: Form authentication timeout in web.config overriding the manual ticket timeout

11 days ago by Raghav Khunger

Views: 161 - Comments: 0

While working with one of the sample application I noticed that form authentication timeout in web.config was overriding the manual ticket's (which we created via code) timeout. Below is the code which was written in the application: var ticket = new FormsAuthenticationTicket(1, "UserName", DateTime...
jQuery: Set cursor position in textbox

4/13/2012 by Raghav Khunger

Views: 272 - Comments: 0

In this blog I will show how to select a range of characters in textbox with jquery. In my demo I have used one textbox and one button. On click of button arange of characters in textbox will be selected. Below is the sample code: <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="ser...
Could not load file or assembly 'Newtonsoft.Json, Version=3.5.0.0...

13 days ago by Raghav Khunger

Views: 169 - Comments: 0

Recently we moved from Newtonsoft.Json 3.5 to 4.0 version. We noticed that we were getting Could not load file or assembly 'Newtonsoft.Json, Version=3.5.0.0.. while working with Twitter authentication which we were using in our application. The third party dll which we were using for Twitter authent...
jQuery Mobile Login Dialog Box

11/17/2010 by Tim Eisenhauer

Views: 62821 - Comments: 22

PRODUCT SPOTLIGHT This is an addition to my series of blog posts on jQuery Mobile: jQuery Mobile Introduction & Tips To Get Started jQuery Mobile Getting Started So, if you've been following my posts so far, you should have a good overview of jQuery Mobile, it's documentation, how to set up your...