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.

How can I search SQL server database to find string in any of objects name? I have a problem when testers says this and that is not working and I can not find it by it's name.

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

RedGate has a free tool called SQL Search that will do just that. It integrates with SQL Server Management Studio and lets you search through all the objects in a database for items containing a specific string and will tell you what it matched and what kind of object it is (table, key, column, etc).

If you want to know more about the specific SQL you can use to do this, you may want to ask at dba.stackexchange.com.

share|improve this answer
    
thanx techturtle –  Robert Jung Aug 20 '12 at 17:52
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.