DBA > Job Interview Questions > Microsoft SQL Server FAQs

How can you you be sure that a SOAP queries that

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?

You are setting up a native XML web service on your SQL Server 2005 to respond to inventory requests. How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?

Answer
Use the WSDL=DEFAULT parameter in the create endpoint statement.
Explanation
When using the CREATE ENDPOINT command, you can specify the WSDL=DEFAULT parameter to generate a default WSDL response or use WSDL="spname" where spname is the name of a custom stored procedure to return WSDL responses.

(Continued on next question...)

Other Job Interview Questions