I have an SQL Server instance who's memory usage gradually grows until windows will give it no more. It seems logical that the occasional big query result would cause the instance to grow.
Is there a way I can convince SQL Server to release the memory it doesn't need any more (other than restarting the service)?
I'm using SQL Server 2000 SQL Server 8.00.2039 - SP4 (Standard Edition)
I was able to find that out using the following query:
SELECT 'SQL Server ' + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - ' + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' (' + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'