SQL Instance Info Finder

SQL Instance Info Finder enables the user to easily retrieve information about SQL Server instances. By just selecting the information to be retrieved, the program connects to the SQL Server instance with minimum priviledges and retrieves the requested information.

featuresdownloadscreenshotsonline help why we built it


  

 

* SQL Instance Info Finder is a Free Product offered with respect to the SQL Server community.

Image

Why We Built SQL Instance Info Finder


There are times where you want to quickly retrieve information about a SQL Server instance without having to connect with SQL Server Management Studio (SSMS) and retrieve this information with T-SQL queries. We created SQL Instance Info Finder for this exact purpose. You can retrieve useful information such as SQL Server version, build, edition, service pack and much more, and you can export this information to a text file or directly print it.

Features


App Screenshot
Portable

SQL Instance Info Finder is a portable applications, thus it does not require installation.

Rich Set of Info Retrieval Options

SQL Instance Info Finder provides a rich set of information retrieval options in order to enable you retrieve comprehensive information about your SQL Server instances.

Download SQL Instance Info Finder

Version: 1.0


You can download SQL Instance Info Finder from the below download links:

 

Awards:

Image

 

System Requirements:

 

* Supported SQL Server versions: 2005 or later

Screenshots

Online Help

 

SQL Instance Info Finder enables the user to easily retrieve information about SQL Server instances. By just selecting the information to be retrieved, the program connects to the SQL Server instance with minimum priviledges and retrieves the requested information.

SQL Instance Info Finder by SQLArtBits
Figure 1: Main Screen of SQL Instance Info Finder.

Connecting to a SQL Server Instance
You can connect to a SQL Server instance with either Windows Authentication or SQL Server Authentication. The login to be used needs only two permissions for running the program with all the information retrieval options selected:

  • Connect to Database Engine
  • VIEW SERVER STATE

The program checks for the necessary permissions (based on the selected information retrieval options) during runtime and reports to you a possible lack of permissions and how to grant them.

Selecting the information to be retrieved
Currently there are 15 information retrieval options available. These are:

  1. Instance Name
  2. Server Name
  3. SQL Server Version
  4. SQL Server Build
  5. Edition
  6. Product Level (i.e. Service Pack)
  7. Authentication Mode
  8. NETBIOS Name
  9. Domain Name
  10. Full-Text Status
  11. Clustered Status
  12. Default Collation
  13. SQL Instance Process ID
  14. SQL Instance Port
  15. List of All Databases

Modifying an Existing Snippet
You can modify snippets by navigating to File --> Open Snippet. When you open a snippet, its data is automatically retrieved and imported into the relevant fields. Then you can modify the snippet and re-generate it.

Output Options
Currently there are 3 available output options for the retrieved information:

  1. Export to Text File
  2. Copy to Clipboard
  3. Print

Screenshot Examples:

SQL Instance Info Finder by SQLArtBits - Selecting Info Retrieval Options
Figure 2: Connecting to a SQL Server Instance and Selecting Information to be Retrieved.

SQL Instance Info Finder by SQLArtBits - Retrieving SQL Server Instance Info
Figure 3: Retrieving the Requested Information.