SQL Server Documentation Tool

Automated documentation software to help you keep track of your SQL servers

  Download Free 30-Day Trial
  View Example Documentation

Use our SQL server documentation tool XIA Configuration to automatically document your SQL servers and databases.

Compare items to expose incorrectly configured SQL servers and security vulnerabilities.

All of XIA Configuration's features are supported when documenting SQL, including version control, reporting, XML output and more.

XIA Configuration has a non-intrusive architecture with agentless data collection.

SQL Server Documentation Example

View an example SQL document generated by XIA Configuration:

SQL Server documentation example generated by XIA Configuration
SQL Server documentation example generated by XIA Configuration
  Open Example Document

Supported Platforms

Document the following versions of SQL:

  • SQL 2017
  • SQL 2016
  • SQL 2014
  • SQL 2012
  • SQL 2008 and 2008 R2
  • SQL 2005
  • SQL 2000

Note: All editions of each SQL Server version are supported.

Information documented by XIA Configuration

Find out more about the SQL information documented by XIA Configuration below:

Screenshot of the navigation tree and SQL general settings in the XIA Configuration web interface
Screenshot of the navigation tree and SQL general settings in the XIA Configuration web interface

General SQL Server Information

The following general SQL server information is included in the documentation:

  • Name
  • Product
  • Product Level (e.g. SP3)
  • Edition
  • Host Operating System
  • Platform
  • Version
  • Version Name
  • Language
  • Processors
  • Root Directory
  • Server Collation
  • Is Clustered
  • Use AWE to Allocate Memory
  • Minimum Server Memory
  • Maximum Server Memory
  • Index Creation Memory
  • Minimum Memory Per Query
  • Maximum Worker Threads
  • Default Index Fill Factor
  • Default Backup Media Retention
  • Default Data Location
  • Default Log Location
  • Boost SQL Server Priority
  • Allow Triggers to Fire Others
  • Cursor Threshold
  • Default Full-Text Language
  • Default Language
  • Max Text Replication Size
  • Scan for Startup Procs
  • Two Digit Year Cutoff
  • Network Packet Size
  • Remote Login Timeout
  • Cost Threshold for Parallelism
  • Locks
  • Max Degree of Parallelism
Screenshot showing SQL server advanced settings in the XIA Configuration web interface
Screenshot showing SQL server advanced settings in the XIA Configuration web interface

Security Settings

XIA Configuration provides the following information about security settings:

NOTE: certain settings are not applicable to SQL 2000
  • Server Authentication
  • Auditing Level
  • Enable Server Proxy Account
  • Proxy Account
  • Enable C2 Audit Tracing
  • Cross Database Ownership Chaining
  • XPCmd Shell

Connection Settings

The following information about connection settings is included:

  • Maximum Concurrent Connections
  • Use Query Governor
  • Query Governor Limit
  • Allow Remote Connections
  • Remote Query Timeout
  • Named Pipes Enabled (SQL 2005 and above)
  • TCP Enabled (SQL 2005 and above)

Database Settings

The following database settings are included:

  • Description
  • Collation
  • Last Database Backup
  • Last Database Log Backup
  • Name
  • Owner
  • Date Created
  • ReadOnly
  • Size
  • Space Available
  • Users
  • Use Full Text Indexing
  • Collation
  • Database and Log File name, autogrowth, location
  • Recovery Model
  • Compatibility Level
  • Auto Close
  • Auto Create Statistics
  • Auto Shrink
  • Auto Update Statistics
  • Auto Update Asynchronously
  • Close Cursor on Commit Enabled
  • ANSI NULL Default
  • ANSI NULLS Enabled
  • ANSI Padding Enabled
  • ANSI Warnings Enabled
  • Arithmetic Abort
  • Concatenate Null Yields
  • Cross Database Ownership Chaining
  • Date Correlation Optimization
  • Numeric Round Abort
  • Parameterization
  • Quoted Identifiers
  • Recursive Triggers
  • Trustworthy
  • Page Verify
  • Database Read-Only
  • Database State
  • Restrict Access
  • Extended Properties
  • Database User - Name, Login, Default Schema, Database Roles
  • Database Creation SQL Script

Database Tables

The following information about database tables is included:

  • Name
  • Date Created
  • Owner
  • Quoted Identifiers
  • Replicated
  • Schema
  • Columns
Screenshot showing SQL database table column details in the XIA Configuration web interface
Screenshot showing SQL database table column details in the XIA Configuration web interface

Database Table Columns

The following information about database table columns is included:

  • Name
  • Allow Nulls
  • ANSI Padding
  • Computed Text
  • Data Type
  • Default Schema
  • Default Value
  • Is Computed
  • Is Foreign Key
  • Full Text Indexed
  • Is Identity
  • Identity Increment
  • Identity Seed
  • Primary Key (true / false)
  • Maximum Length
  • Replicated
Screenshot of a SQL table definition in a document generated by XIA Configuration
Screenshot of a SQL table definition in a document generated by XIA Configuration

Stored Procedures

The following information about stored procedures is included:

  • Name
  • Description
  • Date Created
  • Last Modified
  • Encrypted
  • Execution Context
  • Execution Principal
  • Owner
  • Quoted Identifiers
  • Schema
  • System Object
  • Recompile
  • For replication
  • Parameters
  • SQL Stored Procedure Code body

Security - Logins

The following login security information is included in the documentation:

  • Login Type
  • Default Database
  • Login Disabled
  • Deny Connect
  • Creation Date
  • Default Language

Inventory

Create a SQL server inventory by automatically detecting and scanning Windows machines that are members of an Active Directory domain.

Server roles such as SQL are automatically detected and scanned.

Learn moreScreenshot of Active Directory search and detection settings in the XIA Configuration Client
Screenshot of Active Directory search and detection settings in the XIA Configuration Client

Relationship Map

XIA Configuration generates a map showing relationships between customers, databases, Windows servers and other items:

Screenshot showing a SQL relationship map in the XIA Configuration web interface
Screenshot showing a SQL relationship map in the XIA Configuration web interface

Try our SQL server documentation tool for free

No commitments. No costs. Try XIA Configuration today.

  Download Free 30-Day Trial

View all the systems supported by XIA Configuration >

Capabilities   ▲