I


-I switch, using with Sqlcmd, 38–39

IAsyncResult object, using with asynchronous queries, 98–99

IIS (Internet Information Services), relationship to Reporting Services, 163–164

Image control, using with Report Designer, 166

immediate mode in Integration Services, support for, 197

IMPERSONATE permission, description of, 20

Import Analysis Services 9.0 projects, using in Business Intelligence Development Studio, 36

import directive, using with Notification Services, 124

Import/Export Wizard. See Integration Services Import/Export Wizard

--in argument, using with nscontrol create command, 123

indexes. See also XML indexes

disabling, 12

enhancements in, 12

Init aggregate method

description of, 86

example of, 87–88

INSERT statements

using with strongly typed XML data types, 145

using with XML bulk load feature, 156

instance support

in Analysis Services, 218–219

availability of, 7

InstanceName tag in config.xml file, significance of, 113

Integration Services. See also DTS (Data Transformation Services); packages

architecture of, 189–192

and complex flow control, 196–197

configuration feature of, 211–212

Error Flows feature in, 197

immediate mode support in, 197

packaging tools for, 212–214

project mode support in, 197

toolset for, 202

using containers with, 198

using data adapters with, 198

using event handling with, 201–202

using tasks with, 198–199

using transformations with, 200–201

Integration Services Designer

and Control Flow Designer, 207

and Data Flow Designer, 207

features of, 205–206

and Package Explorer, 211

running packages in, 210

Integration Services Import/Export Wizard, features of, 203–205

IntelliCube feature, using with Analysis Services, 229–230

I/O and disk errors, detecting, 63–64

IsNull property, defining for UDTs, 83

IsNullable UDT method, description of, 81

isql utility, replacement of, 38

Itanium processors, support for, 4–5




Microsoft SQL Server 2005 New Features
Microsoft SQL Server 2005 New Features
ISBN: 0072227761
EAN: 2147483647
Year: 2005
Pages: 80
Authors: Michael Otey

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