I have to agree with David.

The simplest way to generate KML from SQL Server data is to serve it up using an xml template with an XSLT file.

The idea...