Создание конечной точки HTTP
CREATE ENDPOINT MyAdWHTTPEndpoint
  STATE = STARTED
AS HTTP (SITE = 'MyServer', 
  PATH = '/sqlWebService', 
  AUTHENTICATION = (INTEGRATED ), 
  PORTS = ( CLEAR ))
FOR SOAP 
  (WEBMETHOD 'http://tempUri.org/'.'uspGetManagerEmployees' 
    (name='AdventureWorks.dbo.uspGetManagerEmployees', 
    schema=STANDARD ),
    WSDL = DEFAULT,
    DATABASE = 'AdventureWorks',
    NAMESPACE = 'http://AdventureWorks/AdWWebServices')