Multi-language support in T-SQL

This is brilliant, a little scary, but brilliant. (note added July 2010: OK, A LOT SCARY!) While back we built a website supporting unlimited languages and articles. For a reason unknown I decided to keep all my content in one table, index it and link my other tables to it.