Deleting an HTTP Namespace Reservation

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

ms191210.note(en-US,SQL.90).gifNote:
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.

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.

ms191210.note(en-US,SQL.90).gifNote:
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).

ms191210.note(en-US,SQL.90).gifNote:
This should correspond to the port number used in HTTP protocol setting for the PATH value when the corresponding endpoint was created.

ms191210.note(en-US,SQL.90).gifNote:
Only computer administrators have permissions to delete existing namespace reservations.

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'

Community Additions

ADD
Show: