Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-04-18 : 11:12:14
|
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
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-04-18 : 12:57:54
|
What error do you get?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-04-18 : 13:18:00
|
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] |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-19 : 17:09:04
|
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? |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-04-21 : 09:03:00
|
sp_helpdb results:Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53Cannot 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. |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-04-21 : 09:17:05
|
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. |
|
|
|
|
|