I have a particular requirement to check following.
A store procedure which verify SQL server database setting are as per defined standard for platform.
List database setting with error report after match below mentioned requirements.
-- Database name with any special character
-- Collation Danish-Norwegian, Case Insensitive,
-- Accent Sensitive
-- Create and update stats async
-- Recovery mode: Simple, databases containing DW data.
-- ANSI settings :Yes
-- One read/write filegroup
-- One file pr. LUN pr. Filegroup (max 32)-Iam not very clear how to get this info.
-- Data, maxsize pre-allocated, no auto-growth
-- Log, no auto-growth
-- One set of partition definitions per partitioned table
-- Check database owner or SPI/SSPI information exist in extended property.
-- Any Sql Server version specifc feature used like datatype etc (Optional)
-- Show all tables where character column doesn't support unicode
Additional Add-on features to it
-- When was any particular table queried by user under this database (Required)
-- List CLR Assembly version and permission set (Optional)
-- List all user with db_owner and db_securityadmin permission (Optional)
Thanks in advance.