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

• You want to disable the trigger dEmployee on the HumanResources...
• What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• What result would you expect from this statement? Select * from dbo .MyTable
• What's an allocation unit?
• When testing connectivity in SQL Server, you use which utility in conjunction with the readpipe utility to establish a connection?
• Which collation is used for Service Broker messages sent between the instances?
• What's an allocation unit?
• Out of the box Report Builder supports two report level fields that can be shown on a report. Which option below has those two options?
• What is a bookmark lookup?
• More...