Vijay -

We are using a similar system (xml stored as text) to
add 'web service' reach to an existing application messaging
product.

The proprietary object is converted to an xml document and sent to
a web service which uses ADO to store it as a text string into a
very simple database.

Drawback: You cannot (easily) query for the document by its contents, only
by its primary key.

So, if you need to be able to construct a new document listing, say, all
buyers of strawberry jam, then holding the inward xml files as a single text
stream is not so good. If you had shredded the inward xml into relationships
you would be in a position to do this.


Horses Courses Bourses
Cheers;
Jon.