August 26, 2009 at 10:05 am
When I open Enterprise Manager it is howing NO ITEMS under databases.
WHen I open the same sql server using Query Analyzer, the databases are there.
Another note, is that when I look at this sql server via SQL 2005 or SQL 2008 Studio, the databases show...
Please help, it is driving me crazy.
BTW I did run a script using sp_dboption to take the DB's offline and back on, but that did not work either.
I have not restarted the sql server itself as of yet because we have multiple customers on the server. Was hoping to correct without restarting, or maybe just wanted assurance that that would correct the issue.
Thanks for your help in advance.
August 26, 2009 at 1:22 pm
Are you sure you can connecting with the same credentials?
Can you connect to other SQL 2000 servers with this machine and EM and see dbs?
August 26, 2009 at 1:27 pm
Close EM and open new instance.
This seems to be a bug in EM. I have faced it many times.
Thanks
Dev
August 26, 2009 at 2:14 pm
Actually I found the problem.
When I ran select * from sysdatabases
I was getting and arithmetic overflow...
The number of rows returned was 39, it should have been 80.
Then when I limited the rows that the select was returning by using a where name like 'cc_30%' I still go it. So I did a where name like 'cc_31%' and did NOT get it.
When I looked at the databases via SQL2005 studio, I saw the next database in line was OFFLINE.
So via sql2005, I put it back ONLINE then back OFFLINE and the error went away and the SQL2000 enterprise manager showed the databases again.
There must have been a corrupt status or DBID within the sysdatabases table.
WOO HOOO!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply