Export (0) Print
Expand All

Instance Class

SQL Server 2005

Represents an instance of Notification Services.

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

'Declaration
Public NotInheritable Class Instance
	Inherits NamedSmoObject
public final class Instance extends NamedSmoObject
public final class Instance extends NamedSmoObject

Updated text: 14 April 2006

Notification Services instances host Notification Services applications and define instance-wide settings, such as the database server, custom delivery protocols, and delivery channels, which represent delivery endpoints.

You can use Instance objects to define new instances or to manage existing instances. To define a new instance, you set its properties and then use the Create method. To manage an existing instance, you get a reference to an existing instance via a NotificationServices object.

When using SQL Server Authentication with a NotificationServices object, you use a Server object to obtain a NotificationServices reference, and then use this reference to get a Notification Services instance. When creating an instance of the Server object, you can specify a ServerConnection object that uses a SqlConnection object.

If you are using SQL Server Authentication to call instance and application management methods such as Create, Update, Drop, Enable, or Disable, the SqlConnection must not already be open.

Make sure the SqlConnection is not opened before the Server object instance is created, or else use another ServerConnection constructor that does not use a SqlConnection object.


The following examples show a minimum instance configuration using Notification Services Management Objects (NMO):

Dim emptyInstance As Instance = _
    New Instance(notificationServices, instanceName)

Dim fileChannel As DeliveryChannel = _
    New DeliveryChannel(emptyInstance, "FileChannel")
fileChannel.ProtocolName = "File"

Dim fileNameArg As DeliveryChannelArgument = _
    New DeliveryChannelArgument(fileChannel, "FileName")
fileNameArg.Value = sampleDirectory + _
    "\Notifications\FileNotifications.txt"

fileChannel.DeliveryChannelArguments.Add(fileNameArg)
emptyInstance.DeliveryChannels.Add(fileChannel)
Console.WriteLine("Delivery channel added.")

Dim emptyApp As Application = _
    ConfigureApplication(emptyInstance)
emptyInstance.Applications.Add(emptyApp)
Console.WriteLine("Application added.")

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

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

Target Platforms

Release

History

14 April 2006

New content:
  • Added clarification that SqlConnection objects must not be open.

Community Additions

ADD
Show:
© 2014 Microsoft