Web Analytics Made Easy - Statcounter
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used to find out the list of all the stored procedures which contains a  particular given text as input.
SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE ‘%Given text%’

Discover more from Technology with Vivek Johari

Subscribe to get the latest posts sent to your email.

By vivekjohari

I am currently working as a Senior Database Professional and have around 18 years of experience in database. Degree:- Master Degree in Computer(MCA) Certification course in Data Science & Machine Learning from Indian Institute of Technology (IIT), Delhi Work experience:- Designing of the database. Database Optimization. Writing Complex Stored Procedures,Functions,Triggers etc. Designing and developing SSIS & DTS packages. Designing SQL Reports using SSRS. Database Server Maintenance. Certification:- MCTS: DA-100: Analysing Data with Microsoft Power BI MCTS: DP-300: Administering Relational Databases on Microsoft Azure Microsoft certified Sql DBA in Sql server 2008 (MCTS). Microsoft certified BI professional in Sql server 2008 (MCTS). Oracle certified profession DBA in ORACLE 10g (OCP) certified profession DBA in ORACLE 9i (OCP) My other publication Technical Blog:- Technologies with Vivek Johari Guest Author and Blogger at sqlservercentral.com

32 thought on “SQL Script to search stored procedures containing a given text”
  1. … [Trackback]

    […] There you can find 12560 additional Info to that Topic: techmixing.com/2015/01/sql-script-to-search-stored-procedures.html […]

  2. … [Trackback]

    […] Find More Information here on that Topic: techmixing.com/2015/01/sql-script-to-search-stored-procedures.html […]

  3. … [Trackback]

    […] There you can find 6223 more Information on that Topic: techmixing.com/2015/01/sql-script-to-search-stored-procedures.html […]

  4. … [Trackback]

    […] Here you can find 89013 more Info on that Topic: techmixing.com/2015/01/sql-script-to-search-stored-procedures.html […]

Leave a Reply

Discover more from Technology with Vivek Johari

Subscribe now to keep reading and get access to the full archive.

Continue reading