LISTING 1: Code That Creates Procedure Sp_findfields

CREATE PROCEDURE dbo.sp_findfields (@sFieldName VARCHAR(20))

AS

SELECT SUBSTRING(so.name, 1, 50) 'table name',
 SUBSTRING(sc.name, 1, 50) 'field name'
FROM sysobjects so
INNER JOIN syscolumns sc ON so.id = sc.id
WHERE so.type = 'U' 
AND sc.name LIKE '%' + @sFieldName + '%'
ORDER BY so.name, sc.name