How to: Update an Instance of Notification Services (Command Prompt)

To update the instance configuration file or to update an application in a single-application instance, you can disable the entire instance and then perform an update.

Note

If you update an event or notification classes, the underlying tables are deleted and recreated. If you update a subscription class, the underlying tables are renamed by appending Old to the table name.

Note

If you update an XSLT file, you must restart the instance so that Notification Services will load the updated file.

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 update an instance of Notification Services

1. Update the instance configuration and application definition. Also, perform any necessary updates to operational files, such as XSL transforms (XSLTs), at this time.

2. Back up the instance and application databases. For more information, see Backing Up and Restoring Databases in SQL Server.

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

4. Type the following command to disable the application:

   nscontrol disable -nameinstanceName

   If you are using SQL Server Authentication, your nscontrol disable command requires additional parameters. For more information, see nscontrol disable Command.

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

   nscontrol update -inconfigFile

   If the instance or application uses command-line parameters or SQL Server Authentication, your nscontrol update command requires additional parameters. For more information, see nscontrol update Command.

6. From a command prompt, type the following command to enable the application:

   nscontrol enable -nameinstanceName

   If you use SQL Server Authentication, your nscontrol enable command requires additional parameters. For more information, see nscontrol enable Command.

See Also

Tasks

How to: Update an Instance of Notification Services (SQL Server Management Studio)

Other Resources

Updating Instances and Applications
nscontrol disable Command
nscontrol update Command
nscontrol enable Command
Managing Instances and Applications How-to Topics (Notification Services)

Help and Information

Getting SQL Server 2005 Assistance