NotificationField Constructor (NotificationClass, String)

Initializes a new instance of the NotificationField class with the parent NotificationClass and a name.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Sub New ( _
    notificationClass As NotificationClass, _
    name As String _
)

public NotificationField (
    NotificationClass notificationClass,
    string name
)

public:
NotificationField (
    NotificationClass^ notificationClass, 
    String^ name
)

public NotificationField (
    NotificationClass notificationClass, 
    String name
)

public function NotificationField (
    notificationClass : NotificationClass, 
    name : String
)

Parameters

• notificationClass
  The parent NotificationClass object for the computed field.

• name
  A String, between 1 and 128 characters in length, that specifies the name of the computed field.

  You cannot change the name. To rename a notification field, you must remove the field and the add the field with the new name.

Remarks

Field names can contain letters, numbers, and the special characters _ # @ and $. They must also conform to Microsoft SQL Server identifier conventions. For more information about SQL Server identifiers, see Identifiers.

If you change a field name, updating the application 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. Any data existing in the original notification class tables is permanently deleted.

This constructor sets the DigestGrouping property to false.

You must set the Type property to give the field a data type.

Example

The following examples show how to define a notification field and add it to the collection of notification fields for a notification class:

// Define a LeavingFrom notification field and use it for grouping 
// digest messages. Add it to the end of the field collection
NotificationField notificationOrgin = 
    new NotificationField(flightNotifications, "LeavingFrom");
notificationOrgin.Type = "nvarchar(6)";
notificationOrgin.DigestGrouping = true;
flightNotifications.NotificationFields.Add(notificationOrgin);

' Define a LeavingFrom field and use it for grouping
' digest messages. Add it to the end of the collection.
Dim notificationOrgin As NotificationField = _
    New NotificationField(flightNotifications, "LeavingFrom")
notificationOrgin.Type = "nvarchar(6)"
notificationOrgin.DigestGrouping = True
flightNotifications.NotificationFields.Add(notificationOrgin)

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

NotificationField Class
NotificationField Members
Microsoft.SqlServer.Management.Nmo Namespace

Other Resources

Defining the Notification Schema
Field Element for Schema/Fields (ADF)