NotifyTableChange Element (XMLA)

Article
12/15/2008

Notifies an instance of Microsoft SQL Server 2005 Analysis Services (SSAS) that a change has occurred to tables in a specified data source.

Syntaxe

<Command>
   <NotifyTableChange>
      <Object>...</Object>
      <TableNotifications>...</TableNotifications>
   </NotifyTableChange>
</Command>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	Command
Child elements	Object, TableNotifications

Notes

The NotifyTableChange command allows a client application to explicitly notify an Analysis Services instance that one or more tables contained in a data source have been changed. For proactive caching, this notification indicates that relational OLAP (ROLAP) objects based on those tables should be reviewed and updated.

This method of notification is best used for ROLAP objects based on views or named queries defined in a data source view for which changes can be hard to detect and track.

The Object element must refer to a data source in the Analysis Services database. If the Object element refers to an object other than a data source, an error occurs.

For more information about proactive caching, see Mise en cache proactive.

Voir aussi

Concepts

Commands (XMLA)

Aide et Informations

Assistance sur SQL Server 2005

Partager via