I've always done this using a .NET application and found it far easier than trying to force it with T-SQL. The first big hurdle in doing it with T-SQL is that the image has to be accessible in the file system on the SQL Server. This makes is generally not very useful for user applications.

That being said, Lowell, thank you for the link. It's definitely something I'm interested in and will check out.