CODEWITHSUNDEEP
sql-server-2008-r2ssms
StatsViaCsh
StatsViaCsh

Reputation: 2640

SQL Server 2008R2 Management Studio, where are my db objects?

I've been working with sql server 2008 exclusively through the visual studio interface since I've started coding. I'm trying to get at my database in the SSMS, and I connect, but my database is visible, but not expandable in the object explorer.. I see an object count of 0 in the object explorer details. In VS, I have a full database heirarchy to work with, dozens of tables, sprocs, functions. The connection string points to the same location. Any ideas? I have RTFM to no avail. :) enter image description here

Upvotes: 0

Views: 679

Answers (1)

StatsViaCsh
StatsViaCsh

Reputation: 2640

Turns out my database was awaiting recovery... this was fixed by running the following:

ALTER DATABASE Market SET OFFLINE
GO

ALTER DATABASE Market SET ONLINE
GO

Upvotes: 1

Related Questions