Category: SQL Server
view more software Tips and Tricks
Updated: 10/18/2011 10:10 AM
Author: Shiju Mathews
It circumstances that the developer need to search for objects that are using a particular text. For instances that you are renaming a column in a table and you want to make sure that you are not breaking any existing code.
It searches the text of triggers, UDFs, stored procedures and views for a particular substring, returning the name and type of those database objects that match.
Where "UserName" is the text that we want to search.