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.
|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.|
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.
- Remove the Application node that represents the application.
Back up the instance and application databases. For more information, see Backing Up and Recovering Notification Services.
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.
Type the following command to disable the instance:
nscontrol disable -name instanceName
Type the following command to apply the changes made in the configuration file:
nscontrol update -in configurationFile
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.
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.
net stop ns$
nscontrol register -name instanceName -server databaseServer
When using SQL Server Authentication or argument encryption, you will need to supply additional parameters. For more information, see nscontrol register Command.
net start ns$
Note: If the instance of Notification Services is scaled-out across multiple servers, reregister the instance on each server.
- net stop ns$ instanceName
Type the following command to enable the instance:
nscontrol enable -name instanceName
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.
TasksHow to: Remove an Application from an Instance of Notification Services (Command Prompt)
ConceptsRemoving an Application from an Instance
Other ResourcesDROP DATABASE (Transact-SQL)
Updating Instances and Applications
Managing Instances and Applications How-to Topics (Notification Services)