RedGate have released SQL Search, a SSMS plug-in, which gives users the ability to search their database schemas to instantly locate any term in stored procedures, functions, views and more. It’s currently free.
- Find fragments of SQL text within stored procedures, functions, views and more, such as finding all occurrences of ‘SELECT *’ in views and stored procedures.
- Quickly navigate to objects wherever they happen to be on your servers
- Find all references to an object