Click here to Skip to main content
15,898,134 members
Articles / Database Development

How to find a specific string from stored procedures, triggers and functions in database

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
7 Feb 2012CPOL 6.5K   1  
Simply add your search phrase and run to find jobs, Stored Procedures, Keys, Tables, Views, Indexes, Defaults, and Functions.set nocount on declare @Keyword as varchar(200)set @Keyword = 'Search prase'--<---- enter keyword here--Search jobsselect name Job, enabled , description, ...

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
South Africa South Africa
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions