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. Report Features: 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. Access Requirements: This tool uses xp_cmdshell and sp_OACreate to retrieve various aspects of server information. The user will need to be a member of the System Administrators server role in order to see the complete report.
||Microsoft SQL Server 2008, 2005, 2000