Monday, February 20, 2012

master, model & msdb in database list

On a new, clustered, install of SQL Server 2000, I can't see the master,
model, msdb & tempdb databases in the Database list of Enterprise Manager.
I suspect I may have changed a setting, but I'm not sure what, or where.That is a setting in EM for the registered server. From memory: right-click the registered server,
select "Edit server registration" and you will find an option whether to hide system objects.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:%236DFzT9HIHA.1188@.TK2MSFTNGP04.phx.gbl...
> On a new, clustered, install of SQL Server 2000, I can't see the master, model, msdb & tempdb
> databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>|||Try this,
On Enterprise Manager, right-clik your server and select Edit SQL Server
Registration Properties and check the box 'Show system databases and system
objects'. Click Ok. Your system databases must be there.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Jay" wrote:
> On a new, clustered, install of SQL Server 2000, I can't see the master,
> model, msdb & tempdb databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>|||Excellent, thanks guys
"Jay" <nospan@.nospam.org> wrote in message
news:%236DFzT9HIHA.1188@.TK2MSFTNGP04.phx.gbl...
> On a new, clustered, install of SQL Server 2000, I can't see the master,
> model, msdb & tempdb databases in the Database list of Enterprise Manager.
> I suspect I may have changed a setting, but I'm not sure what, or where.
>
>

No comments:

Post a Comment