SQL Server Trial Edition Expiration

It's time to get outdoors and Explore

SQL Server Trial Edition Expiration 

I installed SQL Server Docker Container on Linux Machine running on EC2. 

I took the AMI Image and launched the existing container and wanted to know when will the SQL Server licence expires on Docker container.

It expires after 6 Months from initial container launch date. 

EXEC sp_configure 'show advanced options', 1;

EXEC sp_configure 'Agent XPs', 1;

DECLARE @daysleft int
DECLARE @instancename sysname
SELECT @instancename = CONVERT(sysname, SERVERPROPERTY('InstanceName'))
EXEC @daysleft = xp_qv '2715127595', @instancename
SELECT @daysleft 'Number of days left' GO
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'

Posted in SQL Server on Jun 11, 2017.


Please sign in to comment!