Eirikur Eiriksson (5/7/2014)

---

george sibbald (5/7/2014)

---

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);

Be very careful with NOLOCK and READ UNCOMMITED, apart from possibly bringing back incorrect data these two options will not be supported in future versions of sql server.

😎