Sorry for asking the bloody obvious, but has tempdb been deleted? As you cannot start the SQL Server service, check in Windows Explorer for existence of C:\Program Files\Microsoft SQL Server\MSSQL\Data\tempdb.mdf (well, this is the default path anyway). Or does the full error message suggest that SQL Server cannot find a certain system table within tempdb?
As you cannot reboot a database, I assume you mean the server itself - is that because it hangs?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin