Yes OPENXML() and supporting sp_xml_* stored procedures are available in SQL 2000.
>What a coincidence... I need to do this today too. Is this method available in SQL Server 2000? If I remember correctly, sp_xml_preparedocument is only a SQL 2005 procedure.
>
>>You can use XML to pass list of values into SP. See
Re: Sending a list from vfp Message #
829213
--sb--