RE: Database name is visible but not available.

SSC Guru

Points: 323506

March 15, 2013 at 12:45 pm

weird, i haven't seen that issue before specifically; you clearly have dba rights to take it offline and online, so that's not the issue, especially since it's available afterwards.

I have seen weird things when you use things like the 2005 verison of SSMS to conenct to a 2008/R2/2012 server; the SMO is older and sometimes doesn't support; can you check your SSMS client version and see and see if it's older than the server you connect to?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!