1. To send MSMQ messages (originally it was a SQL2000 extended SP written in C)
2. SQL Server could't do it natively.
3. Yes
4. Accessing resources not available directly to SQL Server. The problem with those - in most cases you have to access namespaces not 'secure' form SQL Server point of view.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]