I was the original poster of this thread and with help from others here, I have had continued success. I have had success with querying AD on SQL 2000...

I think I found the solution:

SELECT Model.col.value('./@model, 'varchar(20)') [Model],

Model.col.value('./color[1]', 'varchar(20)') [Color],

Model.col.value('./sunroof[1]', 'varchar(20)') [Sunroof],

Model.col.value('./spoiler[1]', 'varchar(20)') [Spoiler],

Model.col.valu('./quantity[1]/@shop_location' ,'varchar(20)') [ShopName1],

Model.col.valu('./quantity[1]/@qty_avail' ,'varchar(20)') [QtyAvail1],

Model.col.valu('./quantity[2]/@shop_location' ,'varchar(20)') [ShopName2],

Model.col.valu('./quantity[2]/@qty_avail' ,'varchar(20)') [QtyAvail2],

FROM #tmpGridXml

CROSS APPLY Results.nodes('//model') as Model(col)

I'm validating the...

Nevermind, I found the simple resolution.

That's great, thank you very much!!

Thank you very much for all the information. This is very helpul!

I cannot exactly recall where I heard that costs for SQL Standard 32-bit vs SQL Standard 64-bit was...

Thank you for the replies. I understand this maybe out of the ordinary and that itself raises concerns.

The primary reason is for scalability without the SQL 64bit costs for...

Thanks all for the responses. We typically run in the mode of give what they want (sometimes too far) so that's not completely out of the question. However,...

Thank you to both of you. I appreciate the input. I've downloaded QueryExpress and it looks quite simple and light. I need to expose the requirements of...

Well, the server processes many records a second. 5 minutes should fill up a 5mb file no problem so a roll_over would probably be expected. The problem is...

Thanks, Lynn. I initially had this set to 2, but same results. The script I built from Profiler actually uses 0, so I tried that next which is...

Thank you much, George! But first the most tricky part, apparently... finding that Resource CD!

Thank you very much for all the suggestions and recommendations here! Much more information than I had hoped for so this is great!

Thank you. This may be appropriate on another board, but what options are available? I have a stored proc that relies on a list of files within a...

Great information, thank you!

I also wanted to add that I have tried the following, which is my preferred method if it could work.

EXEC sp_xml_preparedocument @hdoc OUT,

...