Script to search tables and columns

• John Tabor

  Old Hand

  Points: 381

  More actions

  May 13, 2005 at 4:42 pm

  #167030

  I need a seach script to search multiple tables and columns. Some of the columns have the same name and I get an "Ambiguous column name". Thanks!

• Rafeeque M.K.

  Ten Centuries

  Points: 1205

  More actions

  May 13, 2005 at 11:59 pm

  #558888

  I think the following links may work for u

  http://www.devarticles.com/c/a/SQL-Server/Execute-SQL-on-Multiple-Tables-and-Columns-SQL-Server-2000/1/

  http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

   

  Rafi-