Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a tool that would look through a group of stored procedures for source code keywords?

A client has a lot of business logic coded into their database and I need to find where it is using certain strings of text? I.E. what procedure contains 'was applied to their balance', so I can refactor that out into business logic. Does anyone know of such a tool? Perhaps something from Red-Gate?

share|improve this question
add comment

1 Answer 1

Similar question has been answered earlier. You wouldn't need a 'tool' to search for text in the DB objects. A simple SQL script would suffice. Check this out for details:

http://stackoverflow.com/questions/674623/how-to-find-a-text-inside-sql-server-procedures-triggers

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.