run c# code from sql server 2005?

we want to call web severice, triggier from sql server event. when certain table update need send the information to the web service,

and go to the database for our clients.

some reference to this:
 Ã¢â?¬Å?Common Language Runtime (CLR) being incorporated into the next version of SQL Server codenamed "Yukon". My assumption is that we'll be able to write stored procedures, user-defined functions and possibly database level classes in languages such as C#, Visual Basic.NET, Perl, COBOL, Python, Ruby, J# (JScript?) and any other language that compiles to the Microsoft Intermediate Language (MSIL).ââ?¬Â

can someone suggest some idea?

 

 Thanks in advance!

 
...