How to CREATE ENDPOINT

I am learnig to create a endpoint in Sql Server 2005. I have create a simple SP to get a customer in Northwind.
Then create a endpoint using HTTP.

SP:
CREATE PROCEDURE [db_accessadmin].[upGetCustomer]
@CustId nchar(5)
AS

SELECT CustomerID,CompanyName,ContactName,ContactTitle,Address,City,PostalCode,Country,Phone,Fax
FROM Customers
WHERE
customerid=@custid
ORDER by CompanyName,CustomerID,Country DESC

Then, create the ENDPOINT script,
USE [Northwind]
GO

CREATE ENDPOINT customer_endpoint
STATE=STARTED
AS HTTP (
PATH='/sql',
AUTHENTICATION= (INTEGRATED),
PORTS = (CLEAR),
SITE = '*'
)
FOR SOAP (
WEBMETHOD 'http://tempUri.org','GetCustomerInfo'
(
NAME='Northwind.dbo.upGetCustomer', FORMAT=ROWSETS_ONLY,
schema=STANDARD
),
WSDL=DEFAULT,
BATCHES=ENABLED,
DATABASE='Northwind'
)
GO

I followed to .Net Sql Server 2005 shows and an article fro DevX website,http://www.devx.com/dbzone/Article/28525/1954?pf=true.

Everything seems to be ok, i think but when I tried to check syntax/runs the script I gets error message,

.Net SqlClient Data Provider:Msg 102, Level 15, State 1, Line 11

Incorrect syntax near ','.

This error is at close bracket before the FOR SOAP.
Can any1 help ..

Thanks for advance.
PunpromkTongue Tied

[2347 byte] By [Punpromk] at [2008-2-3]
# 1
Hi,
Please post this question in one of the SQL forums located here: http://forums.microsoft.com/msdn/. This forum is for Team Edition for Architects.

Thanks!

ElonaTuomiMSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Architecture & Design...

Visual Studio Team System

Site Classified