CREATE procedure [dbo].[sp_find]         
@findcolumn varchar(50)         
as         
begin         
 set nocount on         
 select sysobjects.name as TableFound,syscolumns.name as ColumnFound        
 from sysobjects        
   inner join syscolumns on sysobjects.id=syscolumns.id        
   where sysobjects.xtype='U'     
 and (syscolumns.name like '%' + @findcolumn +'%'       
   or sysobjects.name like '%' + @findcolumn +'%' )     
order by   TableFound,ColumnFound        
end   
GO
EXEC sys.sp_addextendedproperty  
         @name = N'Version',
         @value = N'9.0.154.90',  
         @level0type = N'SCHEMA',  @level0name = 'dbo',  
         @level1type = N'PROCEDURE', @level1name = 'sp_find';
EXEC sys.sp_addextendedproperty  
         @name = N'Purpose',
         @value = N'simple tool to find column or table names that are LIKE the inputed value',  
         @level0type = N'SCHEMA',  @level0name = 'dbo',  
         @level1type = N'PROCEDURE', @level1name = 'sp_find';
--show all extended properties
SELECT objtype, objname, name, value  
 FROM fn_listextendedproperty (NULL, 'schema', 'dbo', 'PROCEDURE', 'sp_find', NULL, NULL);    
--get just the "Version" that i created:
SELECT objtype, objname, name, value  
 FROM fn_listextendedproperty ('Version', 'schema', 'dbo', 'PROCEDURE', 'sp_find', NULL, NULL);

select objz.name as TableName,
colz.name as ColumnName,
colz.colid
from sysobjects objz
inner join syscolumns colz
on objz.id = colz.id 
WHERE objz.xtype='U'
ORDER BY objz.name,colz.colid