The Object Search tool helps you find tables and objects across your SQL Server environment by searching for specific words or text phrases used in object names. With this global search, you can quickly and easily determine where particular objects, such as a table, reside or how many times the same object, such as a login, was created on different instances.
The Object Search tool helps you:
By default, Object Search connects to the specified SQL Server instances using the credentials of your currently logged on Windows account, and then collects data for any object that matches the word or phrase you specified.
Before using Object Search, be sure to decide how broad a search you actually need. Consider limiting your search to only the necessary databases. Keep in mind that large searches impact performance. By default, the Object Search tool returns a maximum of 500 matches.
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".
Limit your results to only text matching the case of the search text.
Exclude system objects from your search. Leave this box unchecked to include system databases in your search.
Type the name of one or more databases hat you want to search. Leave this field blank to include all databases in your search.
IDERA Website | Products | Purchase | Support | Resources | Community | About Us | Legal |
---|