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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-26 : 06:57:46
|
| alt writes "We installed sql2000 service pack 3 on a vmware machine which is a clustered machine..i dont if this was there at the start but i cant see the master, model msdb tempdb in enterprise manager.also when i restored a sql7 database to this machine some system stored procedures in the user database don't appear to be there.dt_addtsourcecontrol, "dbo system"dt_adduserobject " "dt_adduserobject_vs " "dt_checkinobject " "and others.what are the issues here.thanks." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-26 : 08:01:04
|
| Just reregister the server and make sure the hide system objects isn't checked... |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-05-26 : 08:21:43
|
| Open enterprise manager->Right click server - edit server properties-> Uncheck the check box hide system databases and system objects...------------------------I think, therefore I am |
|
|
|
|
|
|
missing system stored procedures and databses from enterprise manager