Posted by Paul on 10/01/89 11:39

It turns out that we have a table that is over 1GB in size. We only had
the server configured to allow SQL Server to use 800MB.

Therefore, when we were querying using a query resulting in a full
table scan there was not enough memory to perform the query. Instead of
returning an error it basically just stopped (or maybe it was doing the
query but it would take years!).

Anyway, thanks to all those that posted!

Paul

[Back to original message]