SQL Discussion

Sign In

Skip Navigation LinksDiscussions List : Determine SQL Server expiration data

Edited: 12/3/2021 4:20 PM
Picture Placeholder: System Account
Picture Placeholder: System Account
  • System Account

### Determine SQL Server expiration data

​There is a question from one of our SQL Folks

How to get the SQL Server expriation date?

 

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'

 

Picture Placeholder: System Account
  • System Account
/_layouts/15/images/person.gif" alt="Picture Placeholder: System Account" />
System Account

​There is a question from one of our SQL Folks

How to get the SQL Server expriation date?

 

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'

 

012/3/2021 4:11 PM12/3/2021 4:20 PMNoGeneral
0
8/13/2019 8:08 AM
There are no items to show in this view of the "Discussions List" discussion board.