Tsql 獲取服務器信息
2014-03-20 17:42 小sa 閱讀(291) 評論(0) 收藏 舉報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');
類似<? phpinfo()?> 獲取php 服務器信息。
浙公網安備 33010602011771號