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.
o.name AS Object_Name,
FROM sys.sql_modules m
ON m.object_id = o.object_id
WHERE m.definition Like '%Order%';
As a result, we get the names of views/procedures that contain our keyword.
Of course we can clearly specify what we are looking for then we will get more narrow results.