Export (0) Print
Expand All
Expand Minimize

<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.

See Also
Defining the Notification Fields

Designating the Filegroup

Show:
© 2014 Microsoft