title: Search all tables, all columns for a specific value SQL Server
body: <p>I have a specific value, let's say string 'comments'.  I need to find all instances of this in the database as I need to do an update on the format to change it to (*) Comments.</p>
  
  <p>How can I do this? The database is in SQL Server 2000 format.</p>