Thanks for the feedback.  You are correct - the TTF fonts can be used to print from most applications.  SQL Server doesn't provide much in the way of direct user input/output, and that's normally handled by a front end application.  Storing your barcode text in a database and generating the barcodes through the UI should be fairly easy with the TTFs installed (see sample application).

There are other symbologies available, but generally they cost $$$.  I focused on Code 39 and Code-128, because I couldn't find a good free Code-128 font.  I haven't created any other TTFs yet myself, although UPC/EAN would not be overly difficult; though the rules for actually assembling a UPC/EAN barcode can be a little tricky.