November 15, 2007 at 4:44 am
Hi,
Is some one help me on this issue
some time when i am executing a stored procudeure,i am getting the following error message,is it because of the Server perfomance,or can we have to change some setting to enable this
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Please see the error message
Regards,Ezhilan
November 15, 2007 at 6:44 am
it depends where and how you're executing the stored proc. If it's through an app then the timeout maybe there as usually timeouts are a client not a server setting. I have noticed that trying to do some things through management studio that used to work fine in EM for sql 2000 time out - but as I don't do much of that I've not got a problem with it.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
November 15, 2007 at 7:12 am
Can you post us the server spec. to me it looks like your server is hit in some hardware problem.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply