C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Create Web Services in SQL Server


Posted Date: 05 Sep 2008    Resource Type: Code Snippets    Category: SQL

Posted By: Lakhan Pal       Member Level: Gold
Rating:     Points: 10




CREATE ENDPOINT XMLHTTPEndPoint /* Create End Point for web service.*/

STATE= {STARTED | STOPPED | DISABLED} /* STARTED Means Listening and Responding, DISABLED Means Neither Listening nor Responding And STOPPED Means Listening But Not Responding*/

AS
{HTTP | TCP} /* specify the Transport Protocol to used */
(
PATH = <Path for the Webservice> (e.g.: '/Webservices',)

AUTHENTICATION= (BASIC | DIGEST | INTEGRATED),
/* INTEGRATED Is More Secure, While Basic is Least Secure and Digest is not Secure Authentication type */

PORTS= {CLEAR | SSL}, /* CLEAR (HTTP - port 80 by default) SSL (HTTPS - port 443 by default) */

SITE= <Server Name>
)
FOR {SOAP | TSQL}
(
WEBMETHOD <Web Method Name>
(NAME=<Database.Schema.Name>),

BATCHES= {ENABLED | DISABLED},
/* If ENABLED, multiple SOAP request/response message pairs can be identified as part of a single SOAP session. */

WSDL= {NONE | DEFAULT | 'sp_name'},
DATABASE = <Database Name>
NAMESPACE= http://<Server Name>/<Folder Name where you want to create Webservice>
)

WSDL Specify how the Document Generation Will Occur. If none no Response is generated or returned for query.





Responses


No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Create Web Services in SQL Server without IIS Server  .  

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Take back up of databse using Stored Procedure
Previous Resource: Use of new Rank() function in SQL sever 2005
Return to Discussion Resource Index
Post New Resource
Category: SQL


Post resources and earn money!
 
Related Resources



dotNet Slackers   BizTalk Adaptors    Web Design

masks masks masks

Contact Us    Privacy Policy    Terms Of Use