2.1. SQL SERVER INSTANCE

Each instance (or installation) of Microsoft SQL Server 2000 is composed of several databases, four system databases (master, model, msdb and tempdb) and as many user databases as specified by the database administrator. SQL Server 2000 supports installing more than one instance on the same host.

2.1.1. The SQL Server Database

Each database consists of a collection of system and user tables and related database objects such as views, indexes, stored procedures, triggers, etc. A database in a Microsoft SQL Server database maintains a list of its database objects in its sysobjects table in that database. Each object type and its sysobjects table symbol are listed in Table 2-1.

Table 2-1. Object Types
Object TypeSysobjects ...

Get Transact-SQL Desk Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.