January 21, 2008 at 10:55 pm
I have an application with a Purge functionality. When I execute the SP from SQL Server 2005, it gets executed successfully, when I perform Purge thorugh the application, it says purge successful.
The tester has now reported the following
ERROR MESSAGE:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Any clue what this means?
January 21, 2008 at 11:03 pm
Hi
SQL waits for a certain amount of time for doing a task and even after waiting if its not possible to do the task it gives a time out error.
there are many reasons for this...
locking , network issues , server not running etc.
check out BOL it has some info on Timeouts..
"Keep Trying"
January 21, 2008 at 11:11 pm
Thanks! I will definitely check it out..
The problem has been resolved for now. The tester was just being a jerk. No need to elaborate further.
January 21, 2008 at 11:14 pm
The error is clear from the application(client) you are not able to connect to the sql server.
>>Check if the coonection string in the application is set correctly or not.
>> Check are you able to ping the Server from the application machine
>> Check with sys admin if network is the issue
"More Green More Oxygen !! Plant a tree today"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply