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
>

getting my inner join to work

I have a book catalog where some books have more than one author, hence
I've made a one-to-many table where I have the book isbn matched up to
the author id.

I have a table called books that has the book title, etc. and an author
table that has the author info. I join these to on the book_to_author
table that has two columns, the isbn and the author id, where they match
up.

Now I want to do a search that pulls up all the titles written by one
author, so that if someone sees a book they like on our site, and they
want to pull up all the titles by that author, they click on the authors
name and all the titles they have written now appear on a scroll out
page.

I'm confused about how to write the join statements given the three
tables. So how would I write this?

Thanks for your help,

Bill

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"Bill" <BillZimmerman@.gospellight.com> wrote in message
news:3f58db68$0$62079$75868355@.news.frii.net...
> I have a book catalog where some books have more than one author, hence
> I've made a one-to-many table where I have the book isbn matched up to
> the author id.
> I have a table called books that has the book title, etc. and an author
> table that has the author info. I join these to on the book_to_author
> table that has two columns, the isbn and the author id, where they match
> up.
> Now I want to do a search that pulls up all the titles written by one
> author, so that if someone sees a book they like on our site, and they
> want to pull up all the titles by that author, they click on the authors
> name and all the titles they have written now appear on a scroll out
> page.
> I'm confused about how to write the join statements given the three
> tables. So how would I write this?
> Thanks for your help,
> Bill
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

It would be helpful to have the DDL (CREATE TABLE) statements for your
tables, but I guess you're looking for something along these lines:

select
b.title
from
dbo.books b
join dbo.book_to_author ba
on b.isbn = ba.isbn

join dbo.authors a
on ba.author_id = a.author_id
where
a.author_id = ???

Simon