Tsql 获取服务器信息

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

Tsql 获取服务器属性，如服务器版本。服务器名

ref:http://technet.microsoft.com/zh-cn/library/ms174396.aspx

select serverproperty ('servername')
select serverproperty ('BuildClrVersion');
select serverproperty ('Collation');
select serverproperty ('CollationID');
select serverproperty ('ComparisonStyle');
select serverproperty ('ComputerNamePhysicalNetBIOS');
select serverproperty ('Edition');
select serverproperty ('EditionID');
select serverproperty ('EngineEdition');
select serverproperty ('HadrManagerStatus');
select serverproperty ('InstanceName');
select serverproperty ('IsClustered');
select serverproperty ('IsFullTextInstalled');
select serverproperty ('IsHadrEnabled');
select serverproperty ('IsIntegratedSecurityOnly');
select serverproperty ('IsLocalDB');
select serverproperty ('IsSingleUser');
select serverproperty ('LCID');
select serverproperty ('LicenseType');
select serverproperty ('MachineName');
select serverproperty ('NumLicenses');
select serverproperty ('ProcessID');
select serverproperty ('ProductVersion');
select serverproperty ('ProductLevel');
select serverproperty ('ResourceLastUpdateDateTime');
select serverproperty ('ResourceVersion');
select serverproperty ('ServerName');
select serverproperty ('SqlCharSet');
select serverproperty ('SqlCharSetName');
select serverproperty ('SqlSortOrder');
select serverproperty ('SqlSortOrderName');
select serverproperty ('FilestreamShareName');
select serverproperty ('FilestreamConfiguredLevel');
select serverproperty ('FilestreamEffectiveLevel');