there's a script in the scripts ection for sending an SMS in a trigger here:http://www.sqlservercentral.com/scripts/Miscellaneous/31899/[/url]
that uses the exisitng email-to-SMS functions that every cell carrier seems to support.
there's a lot of other examples if you search for "SMS" here on SSC.
did you mean the actual modem connection and everything, or is that sufficient? there's another thread that has the actual modem handling on codeproject.com, but I'm not sure what you need.
Lowell