Search the spname with search text

Posted by Madhu.b.rokkam under Sql Server category on 2/15/2011 | Points: 40 | Views : 2228

Declare @spName varchar(100);
set @spName = '%spNamephrase%'
Select distinct name from sysobjects where type='p' and name like @spName order by name

Bookmark It

Posted by: PandianS on: 2/16/2011 Level:Silver | Status: [Member] [MVP] | Points: 10

Hi

You can also use

EXEC Sp_Stored_Procedures '%spNamephrase%'

GO

Cheers
www.sqlserverbuddy.blogspot.com

Posted by: Madhu.b.rokkam on: 2/18/2011 Level:Bronze | Status: [Member] [MVP] | Points: 10

Thanks Pandian

Latest Code Snipptes