M


master

A system database in SQL Server 2005 used as the system catalog.

Materialized view

A view that physically exists through a number of underlying indexes that have been created on it.

Matrix layout

A component of a report used in SQL Server Reporting Services to display data using a cross-tab format.

Merge agent

The replication agent that applies the initial snapshot to the subscriber. It then moves and reconciles any changes that occur.

Merge replication

A replication type that relies on DML operations being captured from both the published database and the subscriber database(s) and automatically synchronized.

Typically starts with a snapshot of the publication. Uses triggers to track subsequent changes made at either the publisher or subscriber.

model

A system database in SQL Server 2005 used as a template for creating new databases.

msdb

A system database in SQL Server primarily used to provide support for the SQL Server Agent.



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net