How can I use System.Drawing in managed stored proc?

[dragonwell]

I've started dabbling in writing some procedures in managed code. My first attempt is a simple function that takes a url, makes a web-request, and saves the response stream as a file to disk. This works good so far! Next step, since the files I'm downloading are JPEGS, is to make a function that saves a thumbnail version as well. For this I will need to use classes from System.Drawing - but alas SQL won't load that namespace, apparently??!?

Is there a way to work around this?

Thanks

 

[mrdenny]

You may want to check with the .NET folks. I'm not sure how many CLR folks hang out in here.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com