Problem with sp_xml_preparedocument

Hi All,

Follwing are the 2 code snippets of XOPEN

1.
declare @.idoc int
declare @.doc varchar(1000)
set @.doc ='
<b>
<a>
<s>aaa</s>
</a>
<a>
<s>bbb</s>
</a>
</b>'
exec sp_xml_preparedocument @.idoc OUTPUT, @.doc
SELECT *
FROM OPENXML (@.idoc,'/b/a',2)
WITH (s varchar(100) '@.s')

2.

create table newtemp
(
s varchar(100)
)
declare @.idoc int
declare @.doc varchar(1000)
set @.doc ='
<b>
<a>
<s>aaa</s>
</a>
<a>
<s>bbb</s>
</a>
</b>'
exec sp_xml_preparedocument @.idoc OUTPUT, @.doc
SELECT *
FROM OPENXML (@.idoc,'/b/a',2)
WITH newtemp

Code snippet 2 works but 1 doesnot.

Can some one me the reason why ?

Thanks & Regards

Nitesh

Try changing

WITH (s varchar(100) '@.s')

to

WITH (s varchar(100) 's')

|||

Thanks a lot !!!!

It worked out.

Problem with sa password

Hi All,
I get error when I tried to edit the properties of the sa password. I get
the follwing message:
"Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
collection"
No problems with editing others.
This is very serious because it is the production server.
I urgently need help.
Thank
Egbon.Check out this article: Q218172. It sounds like you have some databases
where dbo is mapped to null.
You should still be able to change the password with sp_changepassword.
"Egbon" <Vnjowusi@.gosps.com> wrote in message
news:unQGxgsUDHA.1680@.tk2msftngp13.phx.gbl...
> Hi All,
> I get error when I tried to edit the properties of the sa password. I get
> the follwing message:
> "Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
> collection"
> No problems with editing others.
> This is very serious because it is the production server.
> I urgently need help.
> Thank
> Egbon.
>|||Many thanks, James.
Egbon
"James Luetkehoelter" <james.luetkehoetler@.NOSPAMspyglassllc.com> wrote in
message news:em1EQmsUDHA.3220@.tk2msftngp13.phx.gbl...
> Check out this article: Q218172. It sounds like you have some databases
> where dbo is mapped to null.
> You should still be able to change the password with sp_changepassword.
> "Egbon" <Vnjowusi@.gosps.com> wrote in message
> news:unQGxgsUDHA.1680@.tk2msftngp13.phx.gbl...
> > Hi All,
> >
> > I get error when I tried to edit the properties of the sa password. I
get
> > the follwing message:
> > "Error 21776: [SQL-DMO] The name 'dbo' was not found in the users
> > collection"
> > No problems with editing others.
> > This is very serious because it is the production server.
> > I urgently need help.
> >
> > Thank
> >
> > Egbon.
> >
> >
>