SQL
[MSSQL]서버 및 데이터베이스 정보 확인
요지
2015. 7. 15. 09:49
서버 이름, 버전, Edition 확인
SELECT SERVERPROPERTY('ServerName') AS ServerName
, SERVERPROPERTY('MachineName') AS MachineName
, SERVERPROPERTY('InstanceName') AS InstanceName
, SERVERPROPERTY('Edition') AS Edition
, SERVERPROPERTY('ProductVersion') AS ProductVersion
, SERVERPROPERTY('ProductLevel') AS ProductLevel;
GO