Can you post the result of ::

select counter_name, cntr_value / 1024.0 / 1024.0 as GB, *

from master..sysperfinfo

where object_name = 'SQLServer:Memory Manager'

and counter_name in ('Target Server Memory (KB)', 'Total

Server Memory (KB)')

Also check the TOP Line in the Error Log and Post the info:

SQL Server error log, defaults to C:\Program Files\Microsoft SQL Server\MSSQL\LOG

top line should be something like:

2006-03-29 08:59:09.21 server Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)

May 13 2005 18:33:17

Copyright (c) 1988-2003 Microsoft Corporation

Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Else GILA might be on the Right TRACK.. rather is on the right track.