FileGroup Element for EventClass (ADF)

Specifies the application database filegroup on which the event table will be created.

Syntaxe

<EventClasses>
    <EventClass>
        ...
        <FileGroup>

Element Characteristics

Characteristic Description

Data type

string, between 0 and 128 characters in length.

Default value

The /Database/DefaultFileGroup value (if specified) or the application database's primary filegroup.

Occurrence

Optional once per EventClass element.

Updates

Can be added, deleted, and modified when updating the application.

Element Relationships

Relationship Elements

Parent element

EventClass Element (ADF)

Child elements

None.

Notes

If specified, the FileGroup value must match one of the Database element's NamedFileGroup values.

ms145406.note(fr-fr,SQL.90).gifImportant :
If you update a FileGroup element, updating the application deletes and re-creates the event class to which it corresponds. This includes dropping and re-creating the SQL Server tables and indexes used by this event class. Any data existing in the original SQL Server tables is permanently deleted.

Exemple

The following example shows how to have Notification Services place the event class tables in the Events filegroup.

<FileGroup>Events</FileGroup>

Voir aussi

Référence

Application Definition File Reference

Autres ressources

Définition des principales propriétés de classe d'événement
Mise à jour des instances et des applications

Aide et Informations

Assistance sur SQL Server 2005