Setting up an endpoint for TSQL

Question

Post reply

Setting up an endpoint for TSQL

aaa121

SSCertifiable

Points: 5902
More actions
June 11, 2007 at 2:28 pm

#174079

Can someone please tell me how I can convert this statement to a TSQL endpoint instead of using SOAP?

create
endpoint getengineeringlist
state
= started
as
http (
site
= 'localhost',
path
= '/sql/employees',
authentication
= (integrated),
ports
= (clear)
)
for
soap
(
webmethod
'GetEngineeringEmployees'
(
name = 'adventureworks.dbo.GetEngineeringEmployees',
schema = standard
),
wsdl
= default,
database
= 'adventureworks',
batches
= disabled
)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

What are you trying to create an endpoint for?

According to Books Online, the syntax for a TSQL endpoint is

CREATE ENDPOINT endPointName [ AUTHORIZATION login ]

[ STATE = { STARTED | STOPPED | DISABLED } ]

AS TCP (

LISTENER_PORT = listenerPort

[ [ , ] LISTENER_IP = ALL | ( 4-part-ip ) | ( "ip_address_v6" ) ]

)

FOR TSQL

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

aaa121 SSCertifiable Points: 5902 More actions · Answer 2

I'm just trying to create an endpoint for test purposes. I am going to connect to it using visual studio 2005.