How to: Remove an Application from an Instance of Notification Services (Command Prompt)

To remove a Notification Services application from an existing instance, you must modify the instance configuration and then update the instance. The following procedure shows what to modify and how to then perform the update using command-line utilities.

Note

The following procedure assumes you are configuring the instance of Notification Services by using an instance configuration file (ICF) and application definition files (ADFs). If you are using Notification Services Management Objects (NMO), use methods of the Microsoft.SqlServer.Management.Nmo.Instance class to update the instance of Notification Services.

To remove an application

1. In the ICF, do the following:

   • Remove the Application node that represents the application.
   • Remove any application-specific custom protocols from the Protocols node.
   • Remove any application-specific delivery channels from the DeliveryChannels node.
   • Remove any application-specific default parameter values from the ParameterDefaults node.

2. Back up the instance and application databases. For more information, see Backing Up and Recovering Notification Services.

3. On the Start menu, point to All Programs\Microsoft SQL Server 2005\Configuration Tools, and then click Notification Services Command Prompt to open a command prompt window.

4. Type the following command to disable the instance:

   nscontrol disable -nameinstanceName

5. Type the following command to apply the changes made in the configuration file:

   nscontrol update -inconfigurationFile

   If the instance or application uses SQL Server authentication or you need to use command-line parameters, you will need to supply additional parameters. For more information, see nscontrol update Command.

6. To update performance counters, reregister the instance of Notification Services using only the -name and -server arguments. If you do not use the performance counters, do not perform this step. Type the following commands to reregister the instance.

   1. **net stop ns$**instanceName

   2. nscontrol register -nameinstanceName-serverdatabaseServer
      When using SQL Server Authentication or argument encryption, you will need to supply additional parameters. For more information, see nscontrol register Command.

   3. **net start ns$**instanceName

      Note

      If the instance of Notification Services is scaled-out across multiple servers, reregister the instance on each server.

7. Type the following command to enable the instance:

   nscontrol enable -nameinstanceName

After you have updated the instance, you may want to delete the application objects from the application database, or, if the application has its own database, drop the entire database.

See Also

Tasks

How to: Remove an Application from an Instance of Notification Services (Command Prompt)

Concepts

Removing an Application from an Instance

Other Resources

DROP DATABASE (Transact-SQL)
Updating Instances and Applications
Managing Instances and Applications How-to Topics (Notification Services)

Help and Information

Getting SQL Server 2005 Assistance