title: How to find a string inside a entire database?
body: <p>I have one specific string, such as "123abcd" for example but I don't know the name of the table or even the name of the column inside the table on my SQL Server Database. I want to find it with a select and show all columns of the related string, so I was wondering something like:</p>
  
  <pre><code>select * from Database.dbo.* where * like  '%123abcd%'
  </code></pre>
  
  <p>For obvious reasons it doens't work, but there is a simple way to create a select statement to do something like this?</p>