I have a large SQL Server database with lots of tables containing different kinds of fields.
Is there a global (and if not, an efficient) way to prevent the word "sauerkraut" from being entered anywhere in the database?
Whether "Sauerkraut" is the only word entered, or part of a sentence like "I love sauerkraut very much"? (and if it's part of the sentence, I don't want the record to be updated with any part of that sentence)
(Sauerkraut being an innocent example of what I'm really trying to prevent)