ApexSQL Search – Text search

Applies to
ApexSQL Search

Summary
This article describes the benefits of using the Text search feature.

Description

The Text search feature allows you to find data in SQL tables and views matching the phrase you’ve specified, including data stored in encrypted views or databases encrypted with Transparent Data Encryption (TDE).

Quick tip:

The Text search feature doesn’t support searching for data stored in system objects

Quick tip:

The minimum permissions required to use the Text search feature are:

  • Public role membership on the searched SQL instance,
  • CONNECT and
  • VIEW DEFINITON on the searched database
  • SELECT on the searched database

To search encrypted objects, in addition to the above:

  • VIEW ANY DEFINITON has to be granted on the searched SQL instance

Quick tip:

For more information on the search phrases and wildcards you can use visit the See also section

You can control the scope of your search by:

  • Selecting the exact objects and columns you want to search in the Select objects to search list

Quick tip:

To quickly select just specific objects or columns, click Uncheck all in the Select objects to search list context menu and then select only the ones to be searched

  • Specifying whether to match:
    • Numeric columns
    • Text type columns
    • Unique identifier columns
    • Date columns

    to the searched text. To omit any of these columns from the search, simply deselect the appropriate option. For instance, if only the Text type columns option is selected, searching for 12 will show the values stored in char, varchar, nvarchar, text, and ntext columns; not the values stored in unique identifier or any numeric or date types of columns

  • Selecting the Views option to include both tables and views in the search

Quick tip:

To quickly remove duplicate data from the search results (e.g. you are only interested in whether the data exists, not its exact location), deselect the Views option

  • Specifying whether to display exact matches only. For instance, if the Exact match option is selected, results containing 11 won’t be displayed if 1 is searched for

See also
ApexSQL Search – Search phrases, history and results
ApexSQL Search – Object search
ApexSQL Search – Dependency viewer
ApexSQL Search – Safe rename

Last updated
November 20, 2014