Using XML in SQL 2000

• MenTaT :-)

  SSC Eights!

  Points: 811

  More actions

  August 13, 2003 at 2:50 pm

  #65470

  Hi, I am teaching myself the use of XML in SQL 2000 using the 'SQL 2000 Unleashed' book from SAMS.

  I am atempting the following procedure:

  CREATE PROCEDURE [dbo].[S_ORDERS_BY_CUSTOMER_AND_EMPLOYEE_XML]

  (@xml varchar(1000))

  AS

  declare @ixml int, @CustomerID nvarchar(5), @EmployeeID int

  EXECUTE sp_xml_preparedocument @ixml OUTPUT, @xml

  SELECT @CustomerID = CustomerID, @EmployeeID = EmployeeID

  FROM OPENXML(@ixml, 'sp/row')

  WITH (CustomerID nvarchar(5) '@CustomerID',EmployeeID int '@EmployeeID')

  SELECT Customer.CustomerID, OrderID, LastName + ', '+FirstName as EmployeeName

  FROM Customers Customer

  JOIN Orders [Order] ON Customer.CustomerID=[Order].CustomerID

  AND [Order].CustomerID=@CustomerID

  JOIN Employees Employee ON [Order].EmployeeID=Employee.EmployeeID

  AND [Order].EmployeeID=@EmployeeID

  FOR XML AUTO

  IF @@ROWCOUNT > 0

  return 0

  else

  return 1

  EXEC sp_xml_removedocument @ixml

  GO

  and executing this in Query analyzer and passing the following:

  '<sp>

  <row CustomerID=''ANTON'' EmployeeID=''7''/>

  </sp>'

  The message I recieve is:

  XML stored procedures are not supported in fibers mode.

  Question: Do I need to turn NT fibers off in the instance I am running????

  Any help is appreciated.

  Thanx

  Ron

  --Ron
  

• MenTaT :-)

  SSC Eights!

  Points: 811

  More actions

  August 15, 2003 at 6:12 am

  #470088

  I turned off the NT Fibers and this resolved trhe problem.

  --Ron