How to find out Microsoft SQL Server Enterprise Edition Expiration Date

Introduction

As you all know Microsoft SQL Server’s evaluation edition expires after 6 months of validity. So in this article, I am going to tell you how to find our expiry date of MS SQL server, so you can save your important database before it’s too late.

• Open and connect to Microsoft SQL Server.
• Click on new query button on your left hand side.

• Type following command in new query window of Microsoft SQL Server -> Click on execute.

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'

• Result

Note : This command is applicable for all MS SQL server editions.