Date: Thu, 28 Mar 2024 19:20:57 +0000 (UTC) Message-ID: <116032294.68881.1711653657824@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_68880_1953907145.1711653657822" ------=_Part_68880_1953907145.1711653657822 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Object Search tool helps you find tables and objects across = your SQL Server environment by searching for specific words or text ph= rases used in object names. With this global search, you can quickly and ea= sily determine where particular objects, such as a table, reside or how man= y times the same object, such as a login, was created on different instance= s.
The Object Search tool helps you:
By default, Object Search connects to the specified SQL Server instances u= sing 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 act= ually 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 f= or 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 inc= lude system databases in your search.
Type the name of one or more databases hat you want to search. Leave thi= s field blank to include all databases in your search.