SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Programming Reference

Analysis Services Data Access Interfaces

XML For Analysis

XML for Analysis Reference

XML Elements

Properties

AllowOverwrite Element

ApplyCompression Element

Attribute Element

AttributeName Element

Attributes Element

Axes Element

AxesInfo Element

Axis Element

AxisInfo Element

BackupRemotePartitions Element

Binding Element

Bindings Element

CancelAssociated Element

Capability Element

Caption Element

Cell Element

Cell Element (MDDataSet)

CellData Element

CellInfo Element

CellOrdinal Element

Command Element

ConnectionID Element

ConnectionString Element

CrossProduct Element

Cube Element

Cube Element (OlapInfo)

CubeInfo Element

CubeName Element

CustomRollup Element

CustomRollupProperties Element

Database Element

DatabaseID Element

DatabaseName Element

DataSource Element

DataSourceID Element

DataSourceType Element

DataSourceView Element

DbSchemaName Element

DbTableName Element

DeleteWithDescendants Element

Description Element

Dimension Element

DisplayInfo Element

Error Element

ErrorCode Element

ErrorConfiguration Element

Exception Element

File Element

Folders Element

HelpFile Element

HierarchyInfo Element

ID Element

Keys Element

Key Element

Language Element

LastDataUpdate Element

LastSchemaUpdate Element

LName Element

LNum Element

Location Element

Locations Element

Materialize Element

MeasureGroupID Element

Members Element

Message Element

Messages Element

Mode Element

MoveWithDescendants Element

Name Element

Name Element (Parameter)

New Element

Object Element (Dimension)

ObjectDefinition Element

OlapInfo Element

Optimization Element

Original Element

Parallel Element

Parameter Element

Parameters Element

ParentObject Element

PartitionID Element

Password Element

Properties Element

PropertyList Element

Queries Element

Query Element

RequestType Element

RestrictionList Element

Restrictions Element

results Element

root Element

row Element

Security Element

SessionID Element

SkippedLevels Element

Source Element (Error)

Source Element (Synchronize)

Sources Element

SPID Element

Steps Element

Storage Element

SynchronizeSecurity Element

TableNotification Element

TableNotifications Element

Time Element

Translation Element

Translations Element

Tuple Element

Type Element

UName Element

UnaryOperator Element

Value Element

Value Element (Parameter)

Warning Element

Where Element

WritebackTableCreation Element

Minimize

This topic has not yet been rated - Rate this topic

SPID Element (XMLA)

SQL Server 2005

Identifies an active server process identifier (SPID) on which to execute the parent Cancel element.


<Cancel>
   ...
   <SPID>...</SPID>
   ...
</Cancel>

Element Characteristics

Characteristic	Description
Data type and length	Integer
Default value	None
Cardinality	0-1: Optional element that can occur once and only once.

Element Relationships

Relationship	Element
Parent elements	Cancel
Child elements	None

The SPID element represents the server process ID (SPID) used for a given session on an instance of Microsoft SQL Server 2005 Analysis Services (SSAS).

Reference

CancelAssociated Element (XMLA)
ConnectionID Element (XMLA)
SessionID Element (XMLA)

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.