We already do that, to an extent. But in this case I don't already have a blacklist- I want to assemble one from the data we already have.

We're on 2005, but not Enterprise. Just Standard, or whatever it's called. I suppose it won't be a critical problem to do it manually- it's not going to run often, after all.

<employs legions of scammers to bust Ally's database />

In that case, you won't have the fun stuff for doing pattern matching, etc. No matter! You can still do what you want in SQL rather than .net code:

 

http://stackoverflow.com/questions/881913/sql-server-function-for-displaying-word-frequency-in-a-column

 

is a good place to start

Hah. It'll run every 24 hours to establish a watch list of words. That watch list will then be used constantly.

Aha. Looks perfect-thanks.