Now returns table (or function which returns a table) and column name. CREATE FUNCTION Find_Text_In_Column_Name (@StringToSearch varchar(100))RETURNS @fColumnNames TABLE (tablename sysname, colname sysname)ASBEGIN SET @StringToSEarch = ‘%’ + @StringToSearch + ‘%’ INSERT @fColumnNames SELECT DISTINCT SO.NAME, SC.NAME FROM syscolumns SC (NOLOCK)INNER JOIN sysobjects SO (NOLOCK) ON SC.id = SO.id WHERE SC.NAME LIKE @StringToSearch ORDER BY…

My new favorite toy: Google code search Some interesting comments and such left in code: I’m an idiot. Why the hell wtf Some idiot What an idiot Google code search even does regex. How about a string of random ? and !?