Export (0) Print
Expand All

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.

NoteNote

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.

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.

NoteNote

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

NoteNote

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

NoteNote

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:
© 2014 Microsoft