Our VFP 6.0 app w/SQL 2000 backend will run ok for extended periods of time, then suddenly we get update errors saying SQL Server doesn't have enough memory to run the query (same queries it's been running all along). We go into Enterprise Manager, stop and restart the service and all is well again. Any ideas what causes this?

TIA