Printed 2013/12/08 02:31PM  Searching for Objects or Text
Strings Using SQL Search  By Brad McGehee, 2010/02/04  As a DBA,
at one time or another, you will need to quickly find an object
within a database, such as a table, view, or stored procedure.
In other cases, it is handy to be able to search objects to
locate specific text strings. Depending on which version of SQL
Server you are using, you have had several choices.  For
example, in SQL Server 2005/2008, I could run the following
T-SQL code to find all of the tables in the AdventureWorks
database that includes the string “Vendor”.  USE AdventureWorks
Or, if I wanted to find all the columns in the AdventureWorks
database that include the string “Vendor”, I could run this
T-SQL code.  USE AdventureWorks  Using INFORMATION_SCHEMA views
to find specific object names (and related data) is very
powerful and let’s you write many different queries to find a
lot of information about your database’s objects. The only
downside to doing this is that you have to wr