|
|
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
|
|