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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Timeout Expired

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-23 : 12:57:24
Ana writes "Hello,

I've been getting the following message when I try to run a query (SQL 7.0, on NT 4.0 , sp 6).

[Microsoft][ODBC SQL Server Driver]Timeout expired

I checked my properties for the server and the timeout is set to 0, which I believe to mean that the query should run until complete.

The table I am working with is an imported table from a DB IV . There are 1,000,000 records in the table, and I am trying to order by the table. But shouldn't it run? Any suggestions?

Thanks for all.....

Ana"
   

- Advertisement -