Enterprise Manager - No Items

Question

Post reply

Enterprise Manager - No Items

Janice Mitchell

SSC Journeyman

Points: 98
More actions
June 1, 2005 at 10:29 am

#164826

Sql Server Enterprise Manager - I am trying to access my database in EM and I keep getting the message "no items'. What's up with that!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dan Rachlis SSC Journeyman Points: 75 More actions · Answer 1

make sure you have access to the database and right click to add a new server registration.

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 2

Is it SQL Server 2000's Enterprise Manager or SQL Server 2005's Management Studio we are talking about here?

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

d torrell SSC Enthusiast Points: 102 More actions · Answer 3

I have come across this error too.

I fixed it by running SELECT * FROM master..sysdatabases and I got an arithmetic overflow on the status of a database that was previously set offline.

Therefore, I used: ALTER DATABASE SET online, ran the SELECT query again to make sure the error was gone, refreshed the Enterprise Manager display and all was well.

This may or may not be the same situation for you. However, system tables are often the culprit.

James-128811 SSC Rookie Points: 45 More actions · Answer 4

I know this is a little late, but the solution from d_torrell was excellent. I fixed my problem due to a database being offline.

Thanks SOOO much.