Share via


Deleting an HTTP Namespace Reservation

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

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'

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