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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Timeout expired

Author  Topic 

raj_vasista
Starting Member

3 Posts

Posted - 2004-11-18 : 18:14:00
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.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-11-18 : 18:15:35
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42765
Go to Top of Page
   

- Advertisement -