Hi, I have SQL Server 2000 running on Win 2000 Server. I can view all the records in a table with "SELECT * FROM <tablename>" however when I try to be specific and specify a select criteria I get a timeout error as follows: "[Microsoft][ODBC SQL Server Driver] Timeout expired" I have checked and the timeout in the configuration options is set to 0 (unlimited). Any ideas what's the problem? I have one suspicion about the size of the table, however as I have no experience of SQL Server I'm unsure if this is a problem? The database consists of a single table, comprising of 37 columns and 54million rows. The server is twin 1.1GHZ with 1.8GB RAM. Is this a case of the table being to big? and would it generate a timeout error? Any ideas appreciated... Cheers.
Did you use index for that table? Post your table structure Madhivanan Failing to plan is Planning to fail
Check the execution plan for this query under Query Analyzer for more information. http://vyaskn.tripod.com/watch_your_timeouts.htm link to resolve the timeouts issue. HTH Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Please would you do more specific ? and could you describe your table structure ? and if you dont have index built on the field of criteria please try it, create a index and then execute the query i am sure it would be helpful. hsGoswami ghemant@gmail.com
Hi, Did u mean select * from table_name works well but select * from table_name where col1=1 gives you timeout error. From which application you are trying this. is it QA or some vb application. I hope you must have sp3 installed and mdac2.8 at client if its VB client. Try ITW and check the plan.