Search the spname with search text

Madhu.b.rokkam
Posted by Madhu.b.rokkam under Sql Server category on | Points: 40 | Views : 1695
Declare @spName varchar(100);
set @spName = '%spNamephrase%'
Select distinct name from sysobjects where type='p' and name like @spName order by name

Comments or Responses

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

Login to post response