Hi all,
I've been playing with assemblies in SQL Server 2008 and I was wondering what I'd have to do to get this up and running.
I'd like to have a DLL which downloads XML from a set URL and returns it as a string.
Then, in SQL Server I've successfully registered my assembly and function to return this but it looks like SQL Server doesn't like the fact I've registered the Assembly with "PERMISSION_SET=SAFE"
Reading around, it looks like I'd have to set this to EXTERNAL_ACCESS but with the addition of encyrption having to be thrown into the mix. Seems like a right pain but necessary to protect from naughty people with nasty intent.
Any light that can be shed on this will be gratefully received!
I've been playing with assemblies in SQL Server 2008 and I was wondering what I'd have to do to get this up and running.
I'd like to have a DLL which downloads XML from a set URL and returns it as a string.
Then, in SQL Server I've successfully registered my assembly and function to return this but it looks like SQL Server doesn't like the fact I've registered the Assembly with "PERMISSION_SET=SAFE"
Reading around, it looks like I'd have to set this to EXTERNAL_ACCESS but with the addition of encyrption having to be thrown into the mix. Seems like a right pain but necessary to protect from naughty people with nasty intent.
Any light that can be shed on this will be gratefully received!