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 |
|
sathishvskumar
Starting Member
3 Posts |
 Posted - 2008-12-28 : 23:17:03
|
| Hi all, we are facing problem while getting no of records in SQL server 2000. When we fetch records(more than 500) from Database I'm getting this Time out Error.We have done query optimization and we set command timeout to infinite but no result.How to solve this. Please help us as it is a client issue and very urgent. we are using System.Data.SqlClient class.Thanks in advance. very urgent please.Regards,Sathish kumar |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-12-28 : 23:20:37
|
| Hi,Set Nocount on Place this stmt before the query which u are going to executeand at the end place this oneset nocount offTry this solution |
 |
|
|
sathishvskumar
Starting Member
3 Posts |
Posted - 2008-12-28 : 23:26:35
|
| Thank You. Let's try and get back to you. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Timeout Error in SQL server 2000