SELECT
SERVERPROPERTY(‘ProductVersion’) AS “Sql ProductVersion”,
SERVERPROPERTY(‘ProductLevel’) AS “Sql ProductLevel”,
SERVERPROPERTY(‘Edition’) AS “Sql Server Edition”;
select
create_date as ‘SQL Server Install Date’,
DATEADD(DD, 180 , create_date) as ‘SQL Server Expiry Date’
from sys.server_principals
where name = ‘NT AUTHORITY\SYSTEM’