When was SQL Server installed
========================
SELECT @@SERVERNAME AS [Server Name],
createdate AS [SQL Server Install Date]
FROM sys.syslogins
WHERE [sid] = 0x010100000000000512000000;
output
=======
How to Check Errorlog based on specific time
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
xp_readerrorlog 0,1,N'',N'',N'5/14/2014 7:22:18 AM',N'5/14/2014 7:22:19 AM'
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
How To Find Out Who Installed SQL Server:-
------------------------------------------------------------------------------------------------------
Click here
