system resources exceeded error
Date: Mon, 14 Feb 2005 05:55:06 -0800
We are getting a system resources exceeded message on a query with a left
join between a local table (left) and odbc linked table (SQL Server) on a
machine running XP and Access 2003. When the join is changed to an inner
join, the query runs successfully. The net result difference is 4 records.
A machine running windows 2000 succesfully runs both queires. I have edited
the MaxLocksPerfile in regedit and Buffer size. Any thoughts?
Relevant Pages
- Re: CONTAINS performance
... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
(microsoft.public.sqlserver.fulltext) - Re: Indexing Service, Openquery and sp_executesql
... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
(microsoft.public.sqlserver.fulltext) - Re: Problem using Access or Query Designer to run queries in SQL Serve
... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
(microsoft.public.sqlserver.odbc) - Re: Transaction Isolation Level
... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
(comp.databases.ms-sqlserver) - Extreme performance issues (SQL Server 2000/ADO.NET/C#)
... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
(microsoft.public.dotnet.framework.adonet) |
|
