Creating Understanding and Educating Programmers, Developers and Technical Communities, one post at a time.

Thursday, May 2, 2013

Find Text in Stored Procedures

Method to retrieve every text inside the stored procedures of a database
SELECT B.Name, *
FROM syscomments A INNER JOIN sysobjects B
ON =
WHERE A.text like '%tblNames%'

1 comment:

  1. This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
    healthcare, e commerce, programming, it consulting, retail, manufacturing, CRM, digital supply chain management, Delivering high-quality service for your business applications,
    Solutions for all Industries,
    Getting your applications talking is the key to better business processes,
    Rapid web services solutions for real business problems,
    Web-based Corporate Document Management System,
    Outsourcing Solution,
    Financial and Operations Business Intelligence Solution,