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.