1. What's in YOUR CLR?

A UDF that sends a UDP Packet to a phone (displayed by my J2me App), called by a normal SQL insert Trigger to take advantage of set based logic.

2. If you have written CLR's, why did you write them (or it)?

AFAIK you can't send UDP packets from T-SQL

it was more performant as a CLR_UDF + SQL_Trigger than polling, plus I dont like polling.

3. Looking back at it, was it an appropriate thing to do?

Absolutly, received good comments about the performance from the client, made me look good to the boss

4. what would you consider a CLR to be appropriate for?

The problem about repacing multipe spaces with just one space that was mailed recently in here, didn't like the solucion using set based logic, because it reads the string more than one time.