Hi,

Try replacing your openxml with the following:

DECLARE @idoc int

DECLARE @doc varchar(300)

SET @doc ='<criticalityquestion>

<shortform><![CDATA[Stay again]]> </shortform>

<optionlabel><![CDATA[Yes;Maybe;No]]> </optionlabel>

<optionvalue><![CDATA[Yes;Maybe;No]]> </optionvalue>

</criticalityquestion>'

EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

SELECT *

FROM ...

You can use this API function

Public Declare Function StartService Lib "advapi32.dll" Alias "StartServiceA" (ByVal hService As Long, ByVal dwNumServiceArgs As Long, ByVal lpServiceArgVectors As Long) As Long

November 27, 2003 at 7:33 am

#483927