Monday, 17 June 2013

SQL Server Installed Date in the system or Host

Finding SQL Server Installed Date
You can find Created date and expire date
select create_date ,DATEADD(dd,180,create_date)expire_date from sys.server_principals where name='NT AUTHORITY\SYSTEM'

You can find installed Date

SELECT createdate AS SQLServerInstalled_Date FROM   sys.syslogins WHERE  sid = 0x010100000000000512000000
You can give this Query also
SELECT * FROM   sys.syslogins WHERE name='NT AUTHORITY\SYSTEM'
www.dbacentre.com

Popular Posts