CREATE procedure [dbo].[sp_find]                    
  @findcolumn varchar(50)                    
AS                    
BEGIN                    
 SET NOCOUNT ON         
 --print object_name(@@PROCID)     
 SELECT     
   TableFound,     
   ColumnFound     
 FROM       
   (           
    SELECT     
      1 AS SortOrder,    
      sysobjects.name AS TableFound,    
      '' AS ColumnFound                  
    FROM sysobjects      
    WHERE sysobjects.xtype IN('U' ,'V')       
      AND sysobjects.name LIKE '%' + @findcolumn + '%'      
    UNION ALL       
    SELECT     
      2 AS SortOrder,    
      sysobjects.name AS TableFound,    
      syscolumns.name AS ColumnFound                  
    FROM sysobjects                   
      INNER JOIN syscolumns ON sysobjects.id=syscolumns.id                  
    WHERE sysobjects.xtype IN('U' ,'V')               
      AND syscolumns.name like '%' + @findcolumn + '%'         
   )  X           
   ORDER BY       
     SortOrder,    
     TableFound,    
     ColumnFound                  
END