Document and Audit SQL Server Instances and Databases

XIA Configuration is able to automatically document and audit your SQL Server instances, including detailed information about databases, tables and stored procedures.

Detect code changes within a stored procedure between database versions or environments, expose incorrectly configured SQL servers or security vulnerabilities easily with XIA Configuration.
 
All of XIA Configuration's features are supported when documenting SQL, including version control, production of PDF reports, change tracking and XML output.
 
 
 

Supported Database Platforms

NOTE:
All editions are of each SQL Server version are supported
  • SQL 2000
  • SQL 2005
  • SQL 2008
  • SQL 2008 R2
  • SQL 2012
 
 


General Server Information
  • 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  

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

  • 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
  • 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
  
  • Name
  • Date Created
  • Owner
  • Quoted Identifiers
  • Replicated
  • Schema
  • Columns
Database Table Columns
  • 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 

Table Definition PDF Output

    


Stored Procedures

  • 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
  • Login Type
  • Default Database
  • Login Disabled
  • Deny Connect
  • Creation Date
  • Default Language

 

Interested?

If you would like to try using XIA Configuration, download the free trial version, or visit our purchase page.