Sorry for replying so late, Thanks everyone for your suggestions.

Step 1: I had restored these databases to another server from backups, and kept business going. I has good full...

Status: 65536 Status 2: 1627389952 values for suspect databases.

CirquedeSQLeil (2/18/2010)

---

This seems different from the...

When i login into box, i see databases in suspect mode.

AndrewSQLDBA (2/18/2010)

---

When you are using SSMS, are you on the server, or on your workstation? Have you tried connecting from a different workstation, or from a different server?

We cannot tell...

Yes, i can connect using SSMS. However in object explorer details i see only database names i don't see any details for these databases.