if you have pubs database, please run below query and post the results

use Pubs

go

sp_fulltext_database 'enable'

go

Thanks for correcting me John. I agree with action plan given by John. to Add:

First step will be rebuild master database and then you need to restore from the backup...

If you want to change database owner it should be simple.

you can use system procedure sp_changedbowner

Someone has to be dbo of the database. You can revoke Sysadmin role from sa

you want to hide it from System Administrator (sa account) ?

Looks like autoclose is ON for all those database.

Try by turning the option OFF.

use Enterprise Manager and right click on database. Go for Option tab and uncheck Auto Close.

HTH

For Ted,

http://support.microsoft.com/kb/899976/en-us

Performance difference

<script type=text/javascript>loadTOCNode(2, 'moreinformation');</script>After you install SQL Server 2000 Service Pack 4 (SP4), SQL Server may not choose an index seek if you compare numeric columns or...

Please check if Autoclose is ON for the database. do you see something like below.

2006-06-27 13:26:01.22 spid55    Starting up database 'a'

2006-06-27 13:26:05.29 spid55    Starting up database 'a'. 

2006-06-27 13:26:06.12 spid55   ...

Model is template for every new database being created.

If you add a user to model, it will be propogated to all new database created.

from the error 1450 I can tell that you are getting below error message

"Insufficient system resources exist to complete the requested service"

what are the parameters you are passing to sqliostress

please...

http://support.microsoft.com/?id=281642

"NT AUTHORITY\SYSTEM" gives me kind of clue that there might be some application/service running this.

I agree with Philiip about profiler and DBCC filter.

1. Do you have some application which monitors...

You are doing it on SQL 2000? If yes, read below...

Its strange that you are not having sp_dboption. sp_dboption is supported for backward compatibility in SQL 2000.

As a workaround run below

sp_configure...

As per BOL

Microsoft® SQL Server™ 2000 provides parallel queries to optimize query execution for computers having more than one microprocessor. By allowing SQL Server to perform a query in parallel...

Check recent SQL Error Logs and see exact reason for not able to recover master. As suggested by Rudy you may need to restore last full backup of master,.

Log shipping is a nice way of "backup/restore"