Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> .NET Framework inside SQL Server

Timeout Error

Hi,

We were in the process of migrating our application from sql 2000 to sql 2005.

It is noticed that a particular method is giving us Timeout Expired error in SQL 2005 – Sp2, windows 2003 server sp1.

It was working perfectly in SQL 2000 and SQL 2005 (without any Service Packs)

After we installed the Service pack 2, the method call from Sqlhelper class

“SqlCommandBuilder.DeriveParameters() “is giving the time out error.

We tried a round work by installing SP1 first and then installing a support patch from the following url

http://support.microsoft.com/kb/917824 but still the method is giving the same error.

any kind of help will be greatfull.

Regards

Mat

[2175 byte] By [Matrixchyah] at [2008-1-7]
«« Regd Schedular functionality in windows.
»» DirectoryServicesCOMException: There is no such object on the server?
# 1

Note from documentation:

DeriveParameters requires an extra call to the database to obtain the information. If the parameter information is known in advance, it is more efficient to populate the parameters collection by setting the information explicitly.

Since DeriveParameters is running a query against the server, you use profiler to see what it is running to understanding why it may be timing out (low server memory, too many connections, etc). You may also consider changing the app if the parameters are well defined to avoid the extra round-trip to the server.

MarkBenvenuto at 2007-10-2 > top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...
SQL Server
.NET Framework inside SQL Server

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified