title: How to do hit-highlighting of results from a SQL Server full-text query
body: <p>We have a web application that uses SQL Server 2008 as the database. Our users are able to do full-text searches on particular columns in the database. SQL Server's full-text functionality does not seem to provide support for hit highlighting. Do we need to build this ourselves or is there perhaps some library or knowledge around on how to do this? </p>
  
  <p>BTW the application is written in C# so a .Net solution would be ideal but not necessary as we could translate.</p>