Simple search the whole database

Search throughout the database – MSSQL

If we’ve got large database and we need to find some procedure or view. And we do not remember what it was called but we know what string or parameters it return or contains.
We can search our database for a simple query.

As a result, we get the names of views/procedures that contain our keyword.
search sql

Of course we can clearly specify what we are looking for then we will get more narrow results.

One Comment on “Simple search the whole database”

Leave a Reply

Your email address will not be published. Required fields are marked *