Thanks Mani but let me ask you this- is an outage the only way to reattach the model db?

How did it get deattached? Would the services have to be stopped...

Mani,

The system databases are not hidden as I checked following your instructions.

I can see the master, msdb and temp dbs listed in Enterprise Manager.

I ran your query:

select name,dbid from sysdatabases

where...

Yeah with no success....

Did the DBA leave under a cloud because he may have left you a leaving present and possibly hacked the sysdatabases table.

It's possible as I created a database on that...

Odd because the model db is not listed...

I just wanted to say thanks to all those who took the time to respond and help me with this query.

It is much appreciated!

Thanks for the responses gentlemen!

I will put this knowledge into use tomorrow and see how I make out.

Thank you both for taking the time to help me out- it is...

It worked!

Thanks so much for the help Michelle! 

I wasn't aware of that!

Thanks for the warning...

Thanks for the help Wayne!

Using your Google criteria led me here to an answer that should work:

DECLARE @datapath varchar(255)EXEC master..xp_regread'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion','RegisteredOwner',@datapath OUTPUTPRINT @datapath