This blog post is a follow up post of an excellent write up by my friend Vinod Kumar. I suggest you read his blog post here SSMS Tips–Object Explorer Details. After reading his blog post, I called him up and had an interesting conversation with him. Here is our conversation:
Pinal: It is easy to find anything in Object Explorer but it is not possible to find everything in Object Explorer.
Vinod: What do you mean? Explain me with example.
Pinal: For example, if I want to find anything related to any schema or table, I can go to Object Explorer and can search about that schema and find relevant information.
However, if I want every single object where any string exists, how do I find all of those objects.
Vinod: That is easy as well, remember SQL Server is Microsoft product and will follow the simple rules of the search which you are familiar. Just try to wrap your string with % and see the magic.
Pinal: Never thought of it. Let me try.
After the conversation was over, I tried to wrap my search string with % and it works, indeed it works. SSMS retrieved every single object where the string appeared.
Thanks Vinod. It is so cool that when we have questions we can reach out to experts.
Reference: Pinal Dave (http://blog.sqlauthority.com)