The SQL Search tool helps you find specific words or text phrases in SQL Server schema objects including table columns, T-SQL scripts, or other SQL code in use on an instance. With this global search, you can quickly and easily complete tasks such as updating copyright notices or changing all usages of a stored procedure call.
The SQL Search tool helps you:
By default, SQL Search connects to the specified SQL Server instance using the credentials of your currently logged on Windows account. SQL Search then looks at all the SQL code used by stored procedures, functions, triggers, and views to determine when a specific word or phrase is being used on a SQL Server instance. The SQL Search tool offers the following options when searching for specific text:
Before using SQL Search, be sure to decide how broad a search you actually need. Consider limiting your search to only the necessary databases and objects. Keep in mind that large searches impact performance. By default, the SQL Search tool returns a maximum of 500 matches.
Limit your results to only text matching the case of the search text.
Allow SQL wildcard characters to retrieve more results. To search for text variations using SQL wildcards, append or prefix the word with an underscore character. For example, "lab" or "lab".
Include system databases in your search. Leave this box unchecked to exclude system databases from your search.
Idera Website | Products | Purchase | Support | Resources | Community | About Us | Legal |
---|