aint this a bit****

I guess if I would've rebooted the server after that command then everything would have came back quickly!!! but Im up and running now...I banged my head...

They are all there.

I tired this command

BEGIN TRANSACTION

      UPDATE sysdatabases SET status = <value> WHERE name = 'model'

commit transaction. stop single user mode

went into server manager to start it but...