• Is this a SQL Server 2005 or 2008?

    I'm asking because you posted in the 2008 forums but you said it's a 2005 instance.

    However, if you have many insufficient memory errors, you probably have run out of memory.

    Which operating system is it running on?

    If it's windows 2008, you should have an entry in your event viewer for resource exhaustion, to confirm this diagnosis.

    -- Gianluca Sartori