Very Computer

by **S?ren Jense** » Thu, 17 Jun 1999 04:00:00

I have a database with 11.000.000 records in a SQL Server 7.0. I use a
Compaq Server (PII 400 MHZ) with 512 mb ram, approx. 12 gb. harddisk etc.,
but when I want to create a View in the Enterprise manager, I get the above
mentioned errormessage.

I have indexed my table, and the primary index i clustered. When I Group on
the primary key it works fine, but When I Group on another index I get the
problem.

Can anyone help me?

Best regards from Denmark

S?ren A. Jensen

by **David Márquez Silv** » Sat, 19 Jun 1999 04:00:00

A good debugging aproach would be to use the Enterprise Manager to see what
happens. Also be sure the ODBC logging is not enabled in the ODBC
administrator.

>I have a database with 11.000.000 records in a SQL Server 7.0. I use a
>Compaq Server (PII 400 MHZ) with 512 mb ram, approx. 12 gb. harddisk etc.,
>but when I want to create a View in the Enterprise manager, I get the above
>mentioned errormessage.

>I have indexed my table, and the primary index i clustered. When I Group on
>the primary key it works fine, but When I Group on another index I get the
>problem.

>Can anyone help me?

>Best regards from Denmark

>S?ren A. Jensen

Very Computer

ODBC Timeout expired????

ODBC Timeout expired????

ODBC Timeout expired????