SQLServerCentral.com Scripts tagged find

Search for String in all columns

Wed, 07 Nov 2012 07:00:00 UT

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

String Search

Mon, 09 Apr 2012 06:00:00 UT

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

Search all tables for text

Mon, 15 Feb 2010 07:00:00 UT

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

Object Search

Wed, 19 Oct 2011 06:00:00 UT

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