SQL Version

SQL Server Version

Herhangi bir sql sunucuya baglandıgınızda database sunucu ile ilgili bilgileri asagidaki t-sql ile alabilirsiniz.

SELECT SERVERPROPERTY(‘ServerName’) AS [ServerName],
SERVERPROPERTY(‘MachineName’) AS [MachineName],
SERVERPROPERTY(‘InstanceName’) AS [InstanceName],
SERVERPROPERTY(‘productversion’) AS [ProductVersion],
SERVERPROPERTY(‘ProductLevel’) AS [ProductLevel],
SERVERPROPERTY(‘Edition’) AS [Edition],
SERVERPROPERTY(‘Collation’) AS [Collation],
SERVERPROPERTY(‘IsClustered’) AS [IsClustered],
SERVERPROPERTY(‘IsFullTextInstalled’) AS [IsFullTextInstalled],
SERVERPROPERTY(‘IsIntegratedSecurityOnly’) AS[IsIntegratedSecurityOnly],
SERVERPROPERTY(‘LicenseType’) AS [LicenseType],
SERVERPROPERTY(‘NumLicenses’) AS [NumLicenses];

Yazar : Sezin ULUTAS

   Send article as PDF