USE master;

GO
EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure; 

Another definition for DB is "catalog"

so a catalog view  allows you to

query metadata

about

SQL Server database objects

primary tool

for management objects

in the DB

integrated environment

for

accessing, configuring, managing, administering and developing

RDBMS components

start/stop

Windows Servers

to

enable and disable

network protocols

return information about DB and their objects

only a single value is returned

(Catalog views return multiple rows of info)

Metadata functions:

they return only a single value

this is called scalar function

DataBase Console Checkers

helps you maintain your DB