select b.name 
from 数据库名.dbo.syscomments a, 数据库名.dbo.sysobjects b     
where a.id=b.id  and b.xtype='p' and a.text like '%key words%' order by name  
 
create PROCEDURE [dbo].[_searchSP]   
     @keywords nvarchar(100)    
AS    
BEGIN    
    -- SET NOCOUNT ON added to prevent extra result sets from    
    -- interfering with SELECT statements.    
    SET NOCOUNT ON;     select b.name   
    from dbo.syscomments a, dbo.sysobjects b    
    where a.id=b.id  and b.xtype='p' and a.text like '%' + @keywords+ '%'    
    order by name    
END go
create PROCEDURE [dbo].[_searchTableFunction]   
     @keywords nvarchar(100)    
AS    
BEGIN    
    -- SET NOCOUNT ON added to prevent extra result sets from    
    -- interfering with SELECT statements.    
    SET NOCOUNT ON;     select b.name   
    from dbo.syscomments a, dbo.sysobjects b    
    where a.id=b.id  and b.xtype='TF' and a.text like '%' + @keywords+ '%'    
    order by name    
ENDgo