Oracle's UTL_TCP Equivalent in SQL Server 2005

I received a function from a co worker as a solution for a problem I'm facing with one of our applications that included reference to the Oracle Library UTL_TCP (write_text). However, the solution is not yet one since I'm not actually using Oracle, but SQL Server 2005. I've been able to convert most of the code to Transact SQL syntax, but still haven't found the equivalent for this library in SQL Server.

I know UTL_TCP.write_text just sends a message to a s开发者_运维技巧ervice on another server (parameters include host, port and charset).

Any possible ideas?

Thanks in advance!

SQL Server has no built-in support for using sockets from TSQL code. The most obvious solution is to write your own CLR stored procedure(s) to wrap the System.Net.Sockets.Socket class.