only surprised that this kind of recognition didn't come earlier.

well deserved.

would increase the varbinary like so

select ABS(CAST(CAST((newid()) AS VARBINARY(8000)) AS Bigint))

help?

example here of using c# clr proc to zip and ftp backups. Also using asymmetric key.

http://sql-library.com/

using CLR procedure, much more secure,robust free and extensible solution here

http://sql-library.com/?p=186

using CLR procedure, much more secure,robust free and extensible solution here

http://sql-library.com/?p=186

using CLR procedure, much more secure,robust free and extensible solution here

http://sql-library.com/?p=186

using CLR procedure, much more secure,robust free and extensible solution here

http://sql-library.com/?p=186

using CLR procedure, much more secure,robust free and extensible solution here

http://sql-library.com/?p=186

Hi Jim,

Thanks very much for your help. Unfortunately my servers are not in`the active directory domain.

Can i use a variation on your solution anyway?

Jules,

Yes, explicit ordering seems pointless but it is enforced by the xsd which validates it.

If there no way to sort it alphabetically then i need to remove the order enforcement...

The interesting thing is that i can set the 'one' element at the top but I need the elements alphabetical order by name.

So this works

SET @xml = ( SELECT...

NO 😉

doesnt help returns this

<root_element value="one">

<elementA value="many" />

<elementA value="many1" />

<elementA value="many2" />

<elementA value="many3" />

<elementA value="many4" />

<elementA value="many5" />

...

what was it? i got the same problem, thanks.

great that works. thanks very much.

Just one more thing.

Is there a way i can rename the element in t-sql.

So update <N id = "2"/> to be <P id =...