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 A.id = B.id
WHERE A.text like '%tblNames%'
Reference: http://geekswithblogs.net/whiletrue/archive/2009/02/02/find-text-in-sql-stored-procedures.aspx

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,

    prologic-corp

    ReplyDelete