Index_M

M

Maintenance plans, 278-281

Make MSX Wizard, 113

Mangione, Gord, 49

Many-to-many lookup table, 70

Many-to-many table relationship, 196

MAPI client, 95

MAPI profiles, 97, 491

MAPI profiles available to SQL Mail, listing, 491

Mapi32.dll, in Outlook 2000, 96

Master database, 79

recovering corrupt, 292

steps for rebuilding, 414

Master database files, snapshot of, 35

Master database restore, 292

Materialized views, 333

max() function, 231

Maximum Conflict Resolver, 446

Maximum Registry Size, increasing, 8

Maximum server memory, setting, 38

MDAC, 19

Member server, installing SQL Server on, 11

Memory

configuring for scaling up, 339

and increasing server performance, 31

Minimum and Maximum settings, 29-30

optimizing, 29-31

redundant, 345

and scaling up, 339-340

Memory floor, 340

Memory leaks

of custom extended stored procedures, 177

from open transactions, 190

Memory tab (Properties dialog box), 29-30

Merge agents (replication), scheduling, 436-437

Merge replication, 426-427, 430

Merge replication model, 426

Merge replication setup, 444-447

Merge replication subscriptions, 448

Message Text option (error messages), 134

Messages (error). See Error messages

Meta Data Services, saving a package in, 117

Metadata

passing using database name, 194

tying to database objects, 199

viewing catalog-level, 323

viewing column-level, 324

viewing on a linked server, 322-323

viewing table-level, 323-324

Method, explained, 205

Microsoft and Sybase, relationship between, 4

Microsoft.NET, 5

Microsoft's DNA strategy, 5

Minimal mode, starting SQL Server in, 37

Minimum Conflict Resolver, 446

Mixed Mode authentication, 33

Model database template (SQL Server), 221

Modify Dependencies dialog box, 409

Money data type, 225

Monitor server (log shipping), 348

Monthly scheduled tasks of a DBA, 52

MS Access database, creating a linked server to, 306

MS DTC (Distributed Transaction Coordinator), 402, 421, 438

MS Excel

for analyzing data, 160

with spreadsheet columns over 255 characters, 216

MS Exchange Settings profile, 97

MS Loopback Adapter, 7

MS Outlook 2000 e-mail client, 95-97

MSCS (Microsoft Clustering Services), 371

failover clustering, 371-377

selecting the account to start, 391

msdb database

rebuilding, 293

sysoperators table in, 105

MSDE, 11

MS_Description screen, in Query Analyzer, 201

MSDN copy of SQL Server, 21

MSSQL (server directory), 22

MSSQL logs directory, 8

MSSQLServer service, 96-97

MSX (master server), 113

MSXOperator operator, 113

MTS (Microsoft Transaction Server), 14

Multi Server Administration, enabling, 113

Multi Server Jobs group, 114

Multiphase data pump, enabling, 125-126

Multiple instances, managing, 26-27

Multiple-instance clusters, 376-377

Multiserver jobs

creating, 114

managing, 113-114

MULTI_USER clause, SET command with, 40