I've seen Windows do that before. The only solution I've ever seen work was a reboot.

subs99 (12/30/2009)

---

Errr... I'm pretty sure...

I did the same thing again, assigning the XML to a variable, then querying against the variable.

See if this gets you going in the right direction:

select

G.test.query('.'),

T.comp.query('.')

from @XML.nodes('gomez_data/monitor/test') G(test)

cross apply...

It means it's not a space in the final position. Might be a tab, or something similar.

Select the ASCII value of the third character, look that up, you'll find...

The error you're getting says you have data conversion issues. Take a look a the columns referenced in the error message and see what data type they are. ...

Have you tried putting it in a .bat (batch) file and calling that? That's what I usually do with anything more complex than a dir command.

I like posers. Well, as long as they're good looking and the pose is...

I prefer to create a domain account for that, domain\SQLBackups. Give it rights to the backup directories, give it rights in SQL, and be done with it.

It means the column you are creating the index on is defined to take 2000 bytes of data. The warning won't go away unless you redefine the column. ...

I'd have to see a sample of the XML to be able to help with the query.

Here's what I come up with for this one:

declare @XML XML;

select @XML = ' <test>

<node>Newark, NJ - Qwest</node>

...

Is there a reason you're not just using the For XML clause on a select query? That would do what you're looking for, and would do it much more...

James Stover (12/30/2009)

---

I could go on indefinitely. Everything you do carries risks. Every human endeavor is subject to refinement over time and use. What makes you think...

Jeff Moden (12/29/2009)

---

What's ironic about that statement is that all software boils down to only two parts... 1's and 0's. ...

GilaMonster (12/29/2009)

---

GSquared (12/29/2009)

---

For anyone here a month or so ago, I have good news on the employment front. Starting a new job with a much better company in mid-Jan....