[dba-SQLServer] ) errors

Comma at end of line 11?

On Thu, May 24, 2012 at 2:22 PM, Jean-Paul N <jnatola at hotmail.com> wrote:
>
>
> hi all,
>
> I'm trying to figure out what sql doesnt like about this parenthesis; LINE 12
>
> CREATE ENDPOINT WebServiceTest
> AUTHORIZATION [sa]
> STATE = STARTED
> AS HTTP
> (
> AUTHENTICATION = (INTEGRATED),
> PATH = '/MyTestWebservicepath/',
> PORTS = (CLEAR),
> CLEAR_PORT = 8045,
> SITE = '*',
>
> )  THIS PAREN  THROWS THE ERROR
> FOR SOAP
> (
> WEBMETHOD 'urn:www.codeproject.com'.'GetProduct'
> (
> NAME = 'Northwind.dbo.GetProduct',
> SCHEMA = STANDARD,
> FORMAT = ALL_RESULTS
> ),
> WSDL = DEFAULT,
> BATCHES = DISABLED,
> SCHEMA = STANDARD,
> LOGIN_TYPE = WINDOWS,
> SESSION_TIMEOUT = 100,
> DATABASE = 'Northwind',
> NAMESPACE = 'www.codeproject.com',
> CHARACTER_SET = XML
> )
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com