2005Management Studio

We have SQL 2005 -- Yukon 9.00.852 running on one machine.

Couple of days ago it is working fine and I am using the Object explorer in Management studio. Know suddnly all the database are gone from object explorer and I only can not see the server name and no database under it.

How I can bring all the database backu in Object explort--management studio.

From command line I can access all the databases. They are up and running fine.

Please email me at consultant_5400@.yahoo.com.

Did you already try File->Connect Object Explorer?

Sayed Ibrahim Hashimi
www.sedodream.com
|||

Yes I try that , It did not work, I also try to register the server again and it also did not not work.

May be best option is to install Management studio only again. But we have one database on it.

Thanks

|||Did you check the error logs and tempdb size? In SQL2000, full tempdb would be a reason for databases not displaying in EM - perhaps this is the same in SQL2005? Just an idea...|||

Hi,

Please can you let me know if it is a temp database issue how to fix that.

I already restart the services, But still it is not showing us databases in EM.