Master
Purpose – Core system database to manage the SQL Server instance.
In SQL Server 2005, the Master database is the logical repository for
the system objects residing in the sys schema. In SQL Server 2000 and
previous editions of SQL Server, the Master database physically stored
all of the system objects.
Prominent Functionality
Per instance configurations
Databases residing on the instance
Files for each database
Logins
Linked\Remote...