>Hi all,
>
>I have a big problem with my SQL Server 2000 SP3a runing on Windows server 2003. When I use Openquery() with a linked server using .DBF table, the amount of Mem Usage in taskmanager for process sqlservr.exe is growing fast and never go down. After restarting SQLServer and 15 Openquery() request, mem usage pass from about 19,000K to about 510,000K. When Mem usage is about 800,000K the server doesn't respond anymore, connections are disconnected and the only way to use it again is restart the service.
>
>Any help is welcome.

Isn't there a setting in SQL Server 2000 to set the max amount of memory it will use? Otherwise it just uses all it can get it's hands on...