Deleting an HTTP Namespace Reservation

To delete a HTTP namespace, use the sp_delete_http_namespace_reservation stored procedure.

Using sp_delete_http_namespace_reservation

Existing namespace reservations can be deleted by using the sp_delete_http_namespace_reservation stored procedure:

sp_delete_http_namespace_reservation N'namespace'

namespace must be of the form:

<scheme>://<hostpart>:<port>/<RelativeURI>

• scheme
  Indicates HTTP protocol scheme, either http or https

• hostpart
  Can be a specific host name (name of the instance of SQL Server 2005) or the following wildcard characters: the plus sign (+) or asterisk (*).

  The plus sign (+) implies that the reservation operation applies to all possible host names for the computer for the specified <scheme> and <port>.

  The asterisk (*) implies that the reservation operation applies to all possible host names for the computer for the <scheme> and <port> that are not otherwise explicitly reserved, such as by running other sp_delete_http_namespace_reservation operations, active endpoints, or other applications.

• port
  The TCP port number that the SQL Server-based application is using.

  Note

  This should correspond to the port number that is used in the HTTP protocol setting for the PORT value when the corresponding endpoint was created.

• relativeURI
  A relative path Uniform Resource Identifier (URI).

  Note

  This should correspond to the port number used in HTTP protocol setting for the PATH value when the corresponding endpoint was created.

Examples

The following examples show deleting a namespace.

sp_delete_http_namespace_reservation N'http://MyServer:80/sql'
sp_delete_http_namespace_reservation N'https://adventure-works.com:443/sql'

See Also

Reference

Reserving URL Namespaces by Using Http.sys
Reserving an HTTP Namespace

Concepts

Configuring the HTTP Kernel-Mode Driver (Http.sys)

Help and Information

Getting SQL Server 2005 Assistance