• Article

Deleting an HTTP Namespace Reservation

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Note

To delete an HTTP namespace by using the kernel-mode HTTP driver (Http.sys) requires Windows administrative privileges on the local computer on which the instance of SQL Server is installed.

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) 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.

Note

Only computer administrators have permissions to delete existing namespace reservations.

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'