How to: Remove an Application from an Instance of Notification Services (SQL Server Management Studio)

To remove an 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 by using Microsoft SQL Server Management Studio.

Note

The following procedure assumes you are configuring the instance of Notification Services 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. In SQL Server Management Studio Object Explorer, expand the Notification Services node.

4. Right-click the instance of Notification Services that runs the application and select Disable.

5. Right-click the instance, point to Tasks, and select Update.

6. In the Update Instance dialog box, click the Browse button and select the updated ICF.

7. Enter or update values as necessary for any parameters shown in the Parameters box.

8. Select the Enable instance after it is updated option to enable the instance at the end of the update process.

9. If the instance uses argument encryption, click Encryption in the left pane and then enter the encryption key.

10. Click OK to perform the update.

11. To update performance counters, reregister the instance of Notification Services:

    1. Right-click the instance and select Stop.
    2. Right-click the instance, point to Tasks, and select Register.
    3. Click OK.
    4. Right-click the instance and select Start.

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