This script will query across all databases, returning a result of objects recently created or modified.  Read more...

Find all columns containing a string value across all tables and schemas.  Read more...

Searches database for up to 4 keywords. It will search through SPs, UDFs, Triggers, SSIS packages, jobs, table names, and column names.  Read more...

Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.  Read more...

A conceptual proof for a google like search procedure  Read more...

Find quickly all stored procedures, tables and views that are somehow related to the search term.  Read more...

A very simple way to find a string in database objects and see where it is located in object definition.  Read more...

This script will help you search all tables for a specific set of text.  Read more...

This script allows a user to search every field in a database for a specified value - handy when knowing the data but not the schema.  Read more...

This procedure searches for your criteria not only in code, but also in objectnames  Read more...

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...

An easy method to search inherited SP codes for a particular text  Read more...

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...

Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.  Read more...

i have recently had the need to search the every database on the server for a particular string. i came up with this... it has lots of room for improvement but it works  Read more...

Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.  Read more...

Searches for tables who's names contain the search string. Gives Aggregate Size, Rows, Index, and Column information as well.  Read more...

This utility will find strings in procedures, functions, views, and even check constraints.  Read more...

Find in a flexible way different type of objects on databases.  Read more...

Searches for tables who's names contain the search string. Gives Size and Rows information as well.  Read more...