DISQUS

DISQUS Hello!  The comments on this profile are unclaimed and thus are unverified.

Do they belong to you? Claim these comments.

sleakbug's picture

Unregistered

Feeds

aliases

  • sleakbug

sleakbug

6 months ago

in SQL Server 2005: Locating Stored Procedures that Contain a Keyword on Tech-Recipes
In SQL 2000 you will need to join together all the 8K records in syscomments for each stored procedure to search within, and beware of your search term breaking across an 8K boundary between 8K records. That will require creating a record that includes the last 1000 chars of one record + the first 1000 chars of the next record to include in the search. You may use less than 1000 chars depending on the size of your search terms.
Returning? Login