nscontrol delete Command

Deletes an existing instance of SQL Server Notification Services.

Syntax

nscontrol delete 
    [-nologo]
    [-help]
        –name instanceName
        -server databaseServer
    [-sqlusername sqlUserName -sqlpassword sqlPassword]
    [-force]

Arguments

• nologo
  Suppresses the product and version statement that appears when you run an nscontrol command.

• help
  Displays the command syntax.

• nameinstanceName
  Is the name of the instance to delete.

• serverdatabaseServer
  Is the name of the server that hosts the instance and application databases. If you use a named instance of SQL Server, you must specify both the server name and the instance name using the format servername\instancename.

• sqlusernamesqlUserName
  Is the SQL Server logon ID used to connect to SQL Server.

  If you are using SQL Server Authentication to connect to SQL Server, specify a login with this argument. Also specify a password using the sqlpassword argument.

  If you are using Windows Authentication to connect to SQL Server, do not use the sqlusername and sqlpassword arguments.

  Security Note:
  When possible, use Windows Authentication.

• sqlpasswordsqlPassword
  Is the password associated with the sqlusername login. This argument must be used together with the sqlusername argument.

• force
  Attempts to force the closure of any open database connections before deleting databases, without prompting the user. Without the force argument, if a database still has open connections, the nscontrol delete command cannot delete that database. The nscontrol delete command will attempt to delete all other databases for the instance.

  Note

  Using nscontrol delete without the force argument when some databases have open connections can leave the instance in an inconsistent state. Before you run nscontrol delete with the force argument, make sure to stop the NS$instance_name Windows service.

Remarks

The nscontrol delete command deletes the instance and application databases only if they were created by Notification Services. Use the nscontrol unregister command to remove the registry key, the performance counters, and any Windows service for the instance.

Permissions

The account used to run nscontrol delete, or the SQL Server login specified by the -sqlusername argument, must have permission to drop databases. This includes membership in the dbcreator or sysadmin fixed server role. The account must also have permission to execute the Notification Services binary files; this permission is granted to members of the Administrators and SQLServerNotificationServicesUser Windows groups.

Examples

A. Basic example

The following example shows how to delete the databases for an instance of Notification Services named StockInstance, using Windows Authentication to connect to SQL Server.

nscontrol delete -name StockInstance -server nsuetest

B. Forcing open connections to be closed and then deleting an instance

The following example shows how to force the closure of all open connections to the instance and application databases, without prompting the user, before deleting the databases. The nscontrol command uses Windows Authentication to connect to SQL Server.

nscontrol delete -name StockInstance -server nsuetest -force

C. Deleting an instance using SQL Server Authentication

The following example shows how to delete the databases for an instance of Notification Services named StockInstance, using SQL Server Authentication to connect to SQL Server.

nscontrol delete -name StockInstance -server nsuetest 
    -sqlusername SqlUser -sqlpassword sQl-P@sWd

See Also

Reference

nscontrol unregister Command
nscontrol Utility

Other Resources

Deleting Instances of Notification Services

Help and Information

Getting SQL Server 2005 Assistance

Change History