فوری:تشخیص SqlExpress که 2005 یا 2008

[Mehrali_ali]

فوری:تشخیص SqlExpress که 2005 یا 2008؟

[mohsen.net]

از هر کدام از 2 دستور زیر می توانید ورژن را بدست آورید


SELECT @@version
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

[mohsen.net]

نسخه تکمیل شده دستور دوم


SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('Edition') AS Edition,
CASE SERVERPROPERTY('EngineEdition')WHEN 1 THEN 'Personal or Desktop '
WHEN 2 THEN 'Standard'
WHEN 3 THEN 'Enterprise'
WHEN 4 THEN 'Express' END AS EngineEdition,
SERVERPROPERTY('servername') AS ServerName,
SERVERPROPERTY('InstanceName') AS InstanceName,
SERVERPROPERTY('BuildClrVersion') AS BuildClrVersion