Document SQL Server 2012

With the new XIA Configuration Server 4.2 it is now possible to document SQL server 2012 instances and databases.

The same level of detail continues as with previous version of XIA Configuration and SQL database instances.

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 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
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

Comments

Post a Comment

Popular posts from this blog

Windows Server 2016, 2019, 2022, Windows 10 and Windows 11: Date and time "Some settings are managed by your organization".

Image
When you're using the new "Modern" date and time settings in Windows Server 2016, 2019, 2022, Windows 10 and Windows 11 you may find that you can't set the correct date and time and the value "Some settings are managed by your organization". - While you're here - Why not check out our Windows Server Documentation and Audit Tool? The simplest way around this is to go back to the proper control panel using Start, Run, "Control.exe" and searching for "Set the date".  Within here you can set the date and time manually as required If you try and click the Change time zone button you may again get access denied... To resolve this open an elevated command prompt by right clicking the command prompt and selecting Run as Administrator  From there run the command rundll32.exe shell32.dll,Control_RunDLL timedate.cpl This will open the Data and Time control panel app elevated as an Administrator.
Read more

TFTPD32 or TFTPD64 reports Bind error 10013 An attempt was made to access a socket in a way forbidden by its access permissions.

Image
When you start the trivial FTP (TFTP) server application TFTPD32 or TDTPD64 you may see the following error Bind error 10013 An attempt was made to access a socket in a way forbidden by its access permissions. This can be because another application is using this port. The easiest way to check if (and which) application is using the port is as administrator run an elevated command prompt and enter netstat -anb > ports.txt Then open ports.txt in Notepad and search for :69, you'll quickly be able to see the process using the required port - While you're here - Why not check out our Windows Server Documentation and Audit Tool?
Read more

Enable function lock for F1-F12 on HP ZBook mobile workstations

Image
When you press the function keys on a HP ZBook mobile workstation you may find that they don't operate as expected. This is because of function lock, if you hold the fn key the function keys work as expected. You can lock the function keys on as described in this document. https://support.hp.com/gb-en/document/c02035108 However there are two things to note Firstly following a BIOS upgrade (which occurs automatically if you have the preinstalled HP software still installed) you may lose your locked function keys and have to reapply.   Secondly the HP documentation states you press the fn lock and fn keys at the same time as per the image below from the page.  While you're here - Why not check out our Windows Server Documentation and Audit Tool? This is not the case, you need to press and hold the fn key, and then tap the fn lock key to toggle function lock, not an obvious thing when you start work first thing in the morning and are hammering the function keys try
Read more