SQL Server 構成情報確認SQL

バージョン情報

Select @@version
go

SELECT  
  SERVERPROPERTY('ProductVersion ') AS ProductVersion
  , SERVERPROPERTY('ProductLevel') AS ProductLevel
  , SERVERPROPERTY('ResourceVersion') AS ResourceVersion
  , SERVERPROPERTY('ResourceLastUpdateDateTime') AS ResourceLastUpdateDateTime
go  

言語設定・ソート順序

SELECT
  SERVERPROPERTY('InstanceName') AS InstanceName
  , SERVERPROPERTY('MachineName') AS MachineName
  , SERVERPROPERTY('Collation') AS Collation
  , SERVERPROPERTY('CollationID') AS CollationID
  , SERVERPROPERTY('ComparisonStyle') AS ComparisonStyle
  , SERVERPROPERTY('LCID') AS LCID
  , SERVERPROPERTY('SqlCharSet') AS SqlCharSet
  , SERVERPROPERTY('SqlCharSetName') AS SqlCharSetName
  , SERVERPROPERTY('SqlSortOrder') AS SqlSortOrder
  , SERVERPROPERTY('SqlSortOrderName') AS SqlSortOrderName
go

パラメータ設定情報

SELECT * FROM sys.configurations
go

参考：パラメータ設定更新
EXEC sp_configure 'default language', 3 ;

データベース

SELECT
	database_id
	,suser_sname(owner_sid) as 'owner_name'
	,name
	,state_desc
	,recovery_model_desc
	,compatibility_level
	,collation_name
	,create_date
FROM sys.databases
;

データファイル

select
  d.database_id
  ,d.name
  ,m.file_id
  ,m.name
  ,m.type_desc
  ,m.physical_name
  ,m.state_desc
  ,m.size
  ,m.max_size
  ,m.growth
  ,m.is_percent_growth
  ,m.is_read_only
from sys.master_files m
inner join sys.databases d
on (m.database_id = d.database_id)
order by d.database_id,m.file_id
;