Showing posts with label fibers. Show all posts
Showing posts with label fibers. Show all posts

Tuesday, March 27, 2012

Getting the error "XML stored procedures are not supported in fibers mode"

Hello All
I am getting the error "XML stored procedures are not supported in fibers
mode", when I try to run the example xmlsql given in the SQL books online...
I have changed my "lightweight pooling option to 0", using sp_configure.
I have restarted the server after this.
sp_configure,'show advanced options', 1 will show the lightweight pooling
as 0
But I am still getting the error.
I am using Sql 2000 on windows 2003
Please help. thanks in advance
-rahul
Did you execute the reconfigure command?
This is needed to make the configuration change active.
Best regards
Michael
"RP" <rahulpidaparti@.yahoo.com> wrote in message
news:ODSgBqU2EHA.3244@.TK2MSFTNGP11.phx.gbl...
> Hello All
> I am getting the error "XML stored procedures are not supported in fibers
> mode", when I try to run the example xmlsql given in the SQL books
> online...
> I have changed my "lightweight pooling option to 0", using sp_configure.
> I have restarted the server after this.
> sp_configure,'show advanced options', 1 will show the lightweight
> pooling
> as 0
> But I am still getting the error.
> I am using Sql 2000 on windows 2003
> Please help. thanks in advance
> -rahul
>