Hi I am getting a timeout error when i debug my asp.net app and a [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData(CheckforData()).error when i run a simple select from query analyser. My sql seems to be really slow now. I have windows2003 server with no sp and SQL2000 with sp3A and the latest hotfix.
I don't think there's any point in me posting my sql as if i write any select statement from query analyser it seems to be taking longer than normal. A select * from a table with 10 000 records is taking 3mins to show results. So it's def. something else. Waht do u think? Do I need an sp for win2003 server?