Thank you both to the reponses! I am on a learning curve but the bottom line sounds like I need to move away from this old and slow way...

Thanks guys! This is all good information, especially when it comes time to put the final request for a machine that exceeds 7 - 8 K$!

Thank you very much! I have used that plenty of times but just did not think to use it in this case.

Thanks for all the info! I appreciate it greatly.

The information I am looking for is whether a performance gain is available with Quad Core version Dual Core. Most...

Thanks for the feedback, Brian. So, summing up your ultimate advice in this situation, would be to not use rowlock?

For some of these queries, I could get away with...

Thank you, thank you!!

Update:

I updated to MSXML6.  I changed syntax to:

EXEC @hr = sp_OACreate 'MSXML2.DOMDocument.6.0', @xmlDOMObj OUTPUT

SQL Service no longer stops.  I now get the following error:

ODBC: Msg 0, Level 19, State...

Thank you very much!  I now have this working and no longer pulling hair out.

I believe I have found the solution to this problem. 

Upon reading the article below, I configured the sp_OACreate to execute 'out-of-process' by including the parameter of 4.  When I...

Thanks to both of you for the responses.  I'll look onto these options. 

Thanks again!

It does not appear to send the data out.  I am going to run through a different approach to see what happens.  I appreciate the help!

Thank you for the reply!

I did try this, along with several other special character encoding.  It does not seem to send the data as expected since the POST returns 0...

This is an old post but I'll give this a try.

I have used the stored procedure provided (thank you very much), but I am having trouble with the authorization.  I...

Got it.  I'll run through it.  Thanks!

I just realized that... how lame of me.

I know it is not generally advisable to access the sys files directly.  Is this the case with this table as well?

Thanks...