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
No comments:
Post a Comment