river1 (5/7/2014)
Hi,I would like to know in with date did a SQL Server 2005 instance was installed on a server.
Can I know This using t-sql?
from glenn Berrys diagnostic queries
-- When was SQL Server installed
SELECT @@SERVERNAME AS [Server Name], create_date AS [SQL Server Install Date]
FROM sys.server_principals WITH (NOLOCK)
WHERE name = N'NT AUTHORITY\SYSTEM'
OR name = N'NT AUTHORITY\NETWORK SERVICE' OPTION (RECOMPILE);
---------------------------------------------------------------------