The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P103: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 492 Chapter 11 SQL Server XML Support Table Continued. Settings Available for the FOR SOAP Clause FOR SOAP setting Value Description LOGIN_TYPE MIXED I WINDOWS If batches are enabled ad hoc SQL requests can be executed on the endpoint by calling the sql sqlbatch method. This method also exposes parameterized query functionality therefore it can take an optional list of SqlParameter elements that will describe metadata and values for the parameters of the specified query. Within the query parameter names starting with the at sign @ can be embedded. Matching parameter names must be supplied otherwise an error is returned for the request. Specifies the SQL Server Authentication mode for the endpoint. If LOGIN_TYPE is not specified the default is WINDOWS. LOGIN_TYPE can only be used to further restrict the authentication mode for endpoints that are based on the server global authentication mode that was selected when the instance of SQL Server was installed. MIXED Allows either SQL Server Authentication or Windows Authentication to be used to authenticate endpoint users. If MIXED is specified and the server is installed in Windows Authentication mode an error is returned. When set to MIXED SQL Server Authentication is supported on the endpoint and the endpoint must be configured to use a Secure Sockets Layer SSL port. Continued SQL Server XML Support Chapter 11 493 Table Continued. Settings Available for the FOR SOAP Clause FOR SOAP setting Value Description WINDOWS Allows only Windows Authentication to be used to authenticate endpoint users. WSDL NONE I DEFAULT I sp_name Indicates whether WSDL document generation is supported for this endpoint. If NONE no WSDL response is generated or returned for WSDL queries submitted to the endpoint. If DEFAULT a default WSDL response is generated and returned for WSDL queries submitted to the endpoint. In exceptional cases where you are implementing custom WSDL support for the endpoint you can also specify stored .
