VirtualObjectives

SQL Server Surveyor

SQL Server Surveyor is a tool which allows database administrators to easily create reports of their SQL Servers for the purposes of documentation, auditing, comparison with other servers, etc.

This tool does not make any changes or updates to the server or its databases. It simply queries various aspects of the SQL server and presents this information in an accessible form.

Sample Report: Click Here (Size 97 KiB)

Download SQL Server Surveyor v1.3.6.15 Installer (Size 817 KiB) Freeware
SHA256 Hash = 6ed9b2b41ed3cf51fa2ccd5eb8ed527145a22fd6728c346949c360f205f60a3b
Download SQL Server Surveyor v1.3.6.15 No Installer (Size 907 KiB) Freeware
SHA256 Hash = 6e239c4147c58329103673943c3be1f022a776fb11e6413c0a8efedc30a1a8c8
Donate

Features:

The report contains the following:

  • Version of SQL Server and operating system
  • Licensing
  • Collation
  • Uptime
  • Network configuration
  • Disk information
  • SQL Server statistics
  • Linked servers
  • Operators and Alerts
  • SQL Jobs (Job history, failures and long running jobs)
  • Maintenance Plans
  • Database information (not schema)
  • Database Replication
  • Fixed database roles
  • Login and access level to databases
  • Windows Scheduled Tasks

Requirements:

Client: Windows XP, Windows 2000
Server: SQL Server 2008, SQL Server 2005, SQL Server 2000

Access Requirements:

This tool uses xp_cmdshell and sp_OACreate to retrieve various aspects of server information. The person running this tool will need to be a member of the System Administrators server role in order to see the complete report. Otherwise, various parts of the report which require sysadmin access will contain an exception message indicating that insufficient access was provided.

Installation:

To install, run the installation program OR extract the Zipped file to any directory on your PC.

Usage:

  1. Type in the server name (or select from the list if used previously). Server name can also be server\instance.
  2. Select the authentication method. By default the Windows authentication will use the Windows account of the person running the program. Unticking this option will bring up a username/password prompt after the Connect button is pressed.
  3. Click the Connect button. Again, if you are not using Windows authentication, enter the username and password of an appropriate SQL login (sa for example).
  4. The report is generated. You can view the output as desired.
  5. Click on the Save Output button to save the report to either a HTM or HTML file of your choice. Unless you change it, the format of the file name will have the server name and the date and time the report was generated.
  6. To survey another SQL server, simply repeat the steps above.