A. This is because the memory allocated by SQL Server does NOT include tempdb in ram. There must be enough memory for SQL, tempdb AND NT otherwise SQL will fail to start. To recover from this :...
A. Do a select * from sysprocesses and identify the spid in question. Then do a "KILL <spidno>"...