Tegest, We may have had a similar problem. A stored proc that returns about 250 records was timing out. Check out the T-SQL UPDATE STATISTICS command -- Run UPDATE STATISTICS table-name WITH FULLSCAN once for each table included in the query, then retry the proc.
-- Bob -----Original Message----- From: vmace_20850 [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 11:39 AM To: [EMAIL PROTECTED] Subject: [AspNetMetroArea] Re: Time Out Expired --- In [EMAIL PROTECTED], "tegestmelu" <[EMAIL PROTECTED]> wrote: > > I get the following error when trying to run a stored procedure from > Vb.Net which selects about 200 records. > > The error says:"Time out expired: The time out period elapsed prior > to completetion of the operation or the server is not responding" > > When our Db rebuilds the index of the table which the stored > procedure uses the problem seems to go away for some time. > > I would appreciate it if anybody has any suggestion how to fix this > problem. > > Thanks > Tegest Hi there, You might have found a solution to your problem since your post, but in case you have not, I would suggest the following: have the sproc return 10-20 recs at the time( paginate on the server).If you really must display 200 recs, increase teh timeout property and run a profiler , as someone mentioned in here. Vlad Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/X1EolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetMetroArea/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
