M

MachineName system variable, purpose in Integration Services, 195

management and development tools

Business Intelligence Development Studio, 33–38

SQL Computer Manager, 24–25

SQL Server Management Studio, 25–33

Sqlcmd utility, 38

Management Studio. See SQL Server Management Studio

MARS (Multiple Active Results Sets)

ADO.NET’s support for, 100–101

support for, 13

Matrix control, using with Report Designer, 166

Matrix reports, generating with Report Wizard, 179

MAX_QUEUE_READERS keyword, using with SQL Server Service Broker application, 135

MaxCount system variable, purpose in Integration Services, 195

MaxVariance class

creating, 88

implementing UDAGGs with, 87

MDAC (Microsoft Data Access Components), relationship to Transparent Client Redirect, 54–55

MDX (Multidimensional Expression)

enhancements in Analysis Services, 235–236

using Profiler with, 233

MDX Query Editor, using with Analysis Services, 223–224. See also Query Editor

MDX scripts, availability of, 235–236

Measures pane, displaying in OLAP Report Designer, 170

measures, relationship to OLAP, 217

media errors, continuing from past, 63

media mirroring, example of, 63

media reliability enhancements, impact on backups, 62–63

Merge aggregate method

description of, 86

example of, 88

message contents, encrypting in SQL Server Service Broker, 139

message transport protocol, using with SQL Server Service Broker, 130–131

message types

creating for SQL Server Service Broker application, 134

grouping as contracts in SQL Server Service Broker, 132

identifying in SQL Server Service Broker application, 138

using with SQL Server Service Broker, 132

messages

associating with external middle-tier procedures, 130

identifying initiators of, 136

retrieving from queues, 136–138

sending to queues, 135–136

verifying receipt of, 138

metadata

allowing access to, 21

enhancements in, 12–13

using with SQL Server Service Broker, 131–132

Metadata window, displaying in OLAP Report Designer, 169

MFType class, code for, 82–83

MFType UDT

using as variable, 84

using in table, 85

Microsoft.SqlServer.Notification Services namespace, import directive for, 124

middle-tier procedures, associating messages with, 130

Mirroring. See Database Mirroring

missing members, handling in MDX, 236

Modify() method, using with XML data types, 148

modules, setting execution context for, 17–18

MOLAP (multidimensional OLAP), overview of, 218

MOVE CONVERSATION T-SQL DML statement, description of, 133

Msg 6965 error message, returning, 146

multiple instance support

in Analysis Services, 218–219

availability of, 7

MyCLRDLL.DLL, creating assembly for, 74–75

MyContacts table, inserting row in, 85

MyHTTPEndPoint, creating, 157

myNSSubscriptions object, creating for Notification Services, 124

MyPF partition function, creating, 11

MyTrigger, creating, 78

MyXmlDoc column, defining, 143

MyXMLDocs table, creating, 145

MyXMLDocSchema namespace, using with XSD schema, 144

MyXMLDoc.xml file, displaying contents of, 156