<FileGroup> Element (<NotificationClass>)
SQL Server 2000
Specifies the SQL Server filegroup on which the notification table will be created.
Structure
<NotificationClasses>
<NotificationClass>
...
<FileGroup>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data Type | string, between 1 and 128 characters in length. |
| Default Value | The notification table is created on the default filegroup specified in the /Database/DefaultFileGroup section of the application definition file (ADF) if the <FileGroup> element is not specified. If the <DefaultFileGroup> element also is not specified, then the default filegroup for the SQL Server instance is used. |
| Occurrence | Optional once per <NotificationClass> node. |
| Updates | Can be added, deleted, and modified using NSControl Update. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent Node | <NotificationClass> Node |
Remarks
The <FileGroup> value must map to one of the <NamedFileGroup> values defined in the <Database> node.
If you update a <FileGroup> element, NSControl Update deletes and re-creates the notification class to which it corresponds. This includes dropping and re-creating the SQL Server tables used by this notification class.
Important If you update a <FileGroup> element, any data existing in the original SQL Server tables is permanently deleted.