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 118 KB)

SQL Server Surveyor v1.0.3.2 Installer (Size 674 KB) Freeware

SQL Server Surveyor v1.0.3.2 No Installer (Size 704 KB) Freeware

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

Unfortunately, this tool is not able to report Windows Scheduled Tasks (only AT command-line schedules).

Requirements:

Client: Windows XP, Windows 2000
Server: 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:

Type in the server name (or select from the list if used previously). Server name can also be server\instance.
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.
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).
The report is generated. You can view the output as desired.
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.
To survey another SQL server, simply repeat the steps above.