SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Can't see DB properties from EM
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 04/18/2008 :  11:12:14  Show Profile  Reply with Quote
Ever since I connected to a SQL 2000 server of mine with SQL 2005 SSMS I can't see the properties of the databases from within SQL 2000 Enterprise manager.

Has anyone seen this before? The Server in question is 2000 Enterprise edition SP4 on a win 2003 server.

dinakar
Flowing Fount of Yak Knowledge

USA
2507 Posts

Posted - 04/18/2008 :  12:57:54  Show Profile  Visit dinakar's Homepage  Reply with Quote
What error do you get?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 04/18/2008 :  13:18:00  Show Profile  Reply with Quote
Error 21776: [SQL-DMO] the name 'master' was not found in the database collection......

But before that I was getting [SQL-DMO] [EXCEPTION_ACCESS_VIOLATION]
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 04/19/2008 :  17:09:04  Show Profile  Reply with Quote
Run sp_helpdb in query analyzer to see if maser is in the list. By the way, tried reboot your machine then open em again?
Go to Top of Page

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 04/21/2008 :  09:03:00  Show Profile  Reply with Quote
sp_helpdb results:

Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc__
____000100002215'; column does not allow nulls. INSERT fails.
The statement has been terminated.

That's interesting. I think I need to check the owners of all the DBs.

Go to Top of Page

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 04/21/2008 :  09:17:05  Show Profile  Reply with Quote
Well it turns out that I had no owner on one of the databases. I ran sp_changedbowner with a valid user and all is well.

Thanks.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000