Increase Timeout to Get Query Results

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Solomon Rutzky » Increase Timeout to Get Query Results

Increase Timeout to Get Query Results

Rate Topic

Display Mode

Topic Options

Author

Message

mordik

Posted Monday, November 24, 2008 12:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, July 18, 2009 8:39 PM
Points: 4, Visits: 6

How do you increase the timeout for the page?
To avoid this error:
System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Post #607333

Jeff Moden

Posted Monday, November 24, 2008 12:45 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:19 PM
Points: 33,110, Visits: 27,035

First, I think you posted this on the wrong forum.

Second, that type of error normally means that there's something wrong with either some slow code that needs to be reworked or someone has a lock in the database preventing further access by others. Increasing the timeout rarely works as expected.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #607339

mordik

Posted Monday, November 24, 2008 1:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, July 18, 2009 8:39 PM
Points: 4, Visits: 6

Where do you suggest one can find the answer to my question?

Post #607362

Jeff Moden

Posted Monday, November 24, 2008 6:22 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:19 PM
Points: 33,110, Visits: 27,035

If it's on the GUI side that you want to do this, then I'm not sure.

If it's on the SQL Server side of the house, a trip to Books Online will reveal all.

--Jeff Moden

Post #607473

mordik

Posted Monday, November 24, 2008 11:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, July 18, 2009 8:39 PM
Points: 4, Visits: 6

On the SQL side it's not a problem because the queries run ok in query analyzer....

The GUI is an issue...will have to keep looking...
Thanks anyway...

Post #607783

« Prev Topic | Next Topic »

Permissions