MS SQL XML - Need to save StoredProc name used to generate Xml Schema

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Need to save StoredProc name used to generate Xml Schema

j2associates

2006-10-24, 6:49 pm

Hello all,

Is there a way to store a custom attribute in the file header of an Xsd
file? I would like to store the original loading stored proc name. I would
like to be able to do something like the following where SelectCommand is my
custom attribute.

Schema generates this entry when I drag stored proc onto design surface:
<xs:element name="Leg">

I would like to be able to add a custom attribute something like this:
<xs:element name="Leg" SelectCommand="MyStoredProdName">

I don't want to have to use a row attribute because of the redundancy. Or
better, can I inherit the Schema Editor and overload / override some things?

Sponsored Links