Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raj_vasista
Starting Member
3 Posts |
 Posted - 2004-11-18 : 18:07:45
|
| Hi All,I am executing a DTS package through a stored procedure which is inserting a thousands of records into my SQL SERVER 2000 Database.When I run my stored procedure through the SQL Query Analyser, it works fine, but when I call the stored procedure through a .NET Application, its giving me the following error."Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.I am using VS.NET Studio 2003,SQL SERVER 2000.The DTS package and Database are in the same server.Any help would be greatly appreciated.Thanks.Raj. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-18 : 18:12:17
|
| Modify the timeout setting to a larger value. The default is 30 seconds.Tara |
 |
|
|
raj_vasista
Starting Member
3 Posts |
Posted - 2004-11-21 : 09:13:18
|
| thanks tara. It works fine if I change the executionTimeout for the httpruntime element in the machine config. Unfortunately I cant change the machine config on the server for some other reasons.So I tried to change it on the web config file. But I still get the error. Is there any other place I can make the changes? Would calling this huge database operation asynchronously work??thanks.Raj |
|
|
|
AlDragon
Starting Member
12 Posts |
Posted - 2004-12-06 : 23:27:39
|
| Are you creating a Sqlcommand object to execute the procedure? If so set the command object.commandtimeout to 0. This will execute the procedure until it is done. Or set it to a max time(its in secs) that suits the business needs.Al Franzini |
|
|
|
|
|
|
Timeout expired