On my development server I was able to create a stored procedure that takes an XML document in as a string and parses it into a table variable that I then use in the procedure. Everything worked great. Here's a mocked-up version of what I'm doing:
DECLARE @xml VARCHAR(1000)
DECLARE @idoc INT
SET @xml =
< User Id="1" />
< User Id="2" />
< User Id="3" />
EXEC sp_xml_preparedocument @idoc OUTPUT, @xml
FROM OPENXML (@idoc, '/ROOT/User', 2)
WITH (UserId INT '@Id')
When I moved the procedure to my production environment I got this error: "XML stored procedures are not supported in fibers mode." After a little searching I tried two things, but now I'm stumped. The option to "Use Windows NT fibers" is not enabled, and just in case I tried running the following in Query Analyzer:
sp_configure 'lightweight pooling', 0
I got the message:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'lightweight pooling' changed from 0 to 0. Run the RECONFIGURE statement to install.
Does anyone know why I'd be getting an error about fibers when they aren't even enabled?