Wednesday 4 July 2012

Get SQL server Installation and expiry date

Query to get Installed and expiry data of SQL
-- Evaluation Version Expire Date
SELECT create_date AS InstallationDate,
DATEADD(DD, 180, create_date) AS 'Expiry Date'
FROM sys.server_principals
WHERE sid = 0x010100000000000512000000
GO

1 comment:

  1. Titanium bmx frame | TITanium Art | TITanium Artists
    TITanium Art | TITanium Art. A. by. titanium drill bits TITanium Art. A. by. TITanium Art. A. by. TITanium Art. A. by. TITanium Art. A. by. TITANA titanium build for kodi ART. A. by. TITANA titanium meaning ART. A. by. TITANA ART. A. by. TITANA ART. A. by. TITANA ART. A. by. how strong is titanium TITANA ART. nano titanium flat iron A. by. TITANA ART. A. by. TITANA ART. A. by. TITANA ART. A. by. TITANA ART. A. by. TITANA ART. A. by.

    ReplyDelete