Hi,
I am trying to create an ENDPOINT in SQL Server 2005 database. My script is as below. I am unable to create this endpoint. It shows error as 'Incorrect syntext near HTTP'
Script:
/****** Object: Endpoint [GetEmployees] Script Date: 03/02/2007 22:21:26 ******/
CREATE ENDPOINT [GetEmployeesBINA]
AUTHORIZATION [TIS-WORLD\Administrator]
STATE=STARTED
AS HTTP (PATH = http://tisserver:80/sql/shapeserv, PORTS = (CLEAR), AUTHENTICATION = (INTEGRATED), SITE=N'localhost', CLEAR_PORT = 80, COMPRESSION=DISABLED)
FOR SOAP (
WEBMETHOD 'EmployeeList'( NAME=N'[AdventureWorks].[dbo].[GetEmployees]'
, SCHEMA=DEFAULT
, FORMAT=ALL_RESULTS), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'AdventureWorks', NAMESPACE=N'http://AdventureWorks/Employee', SCHEMA=STANDARD, CHARACTER_SET=XML)
2) Once I create this endpoint. If I want to check the endpoint in browser , Which url I haeve to use.
Nilkanth Desai