Answered by:
How to check Instance installed date

Question
-
Hi Friends,
How can i check Installed date of sql server.
Thanks
Shashikala
Shashikala
Tuesday, January 28, 2014 5:52 AM
Answers
-
Try the below link
Question: How do I retrieve SQL Server Installation date?
Answer: Run the following query and it will give you the date of SQL Server Installation.
SELECT create_date
FROM sys.server_principals
WHERE sid = 0x010100000000000512000000- Marked as answer by bhat BK Tuesday, January 28, 2014 6:23 AM
Tuesday, January 28, 2014 6:02 AM -
Hi Shashikala,
You can use the below query :
USE[master] GO SELECT[createdate]AS'SQL Install Date' FROM[sys].[syslogins]WHERE[sid]= 0x010100000000000512000000 --NT AUTHORITY\SYSTEM GO
Note : This works only if the installation of the instance is actually performed and not if the instance is pre-configured on an image of the server.
Other options include checking the setup\installation logs. For example, for SQL Server 2012 default instance the path may be similar to something like : Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log
I would then look for the folder with the earliest date.
Again, a word of caution, if it's a testing environment where SQL has been installed and uninstalled several times, there may be folders which have older dates.
neoHypocrite
- Edited by Suraj GanigaMicrosoft employee Tuesday, January 28, 2014 6:13 AM
- Marked as answer by bhat BK Tuesday, January 28, 2014 6:23 AM
Tuesday, January 28, 2014 6:13 AM
All replies
-
Try the below link
Question: How do I retrieve SQL Server Installation date?
Answer: Run the following query and it will give you the date of SQL Server Installation.
SELECT create_date
FROM sys.server_principals
WHERE sid = 0x010100000000000512000000- Marked as answer by bhat BK Tuesday, January 28, 2014 6:23 AM
Tuesday, January 28, 2014 6:02 AM -
Hi Shashikala,
You can use the below query :
USE[master] GO SELECT[createdate]AS'SQL Install Date' FROM[sys].[syslogins]WHERE[sid]= 0x010100000000000512000000 --NT AUTHORITY\SYSTEM GO
Note : This works only if the installation of the instance is actually performed and not if the instance is pre-configured on an image of the server.
Other options include checking the setup\installation logs. For example, for SQL Server 2012 default instance the path may be similar to something like : Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log
I would then look for the folder with the earliest date.
Again, a word of caution, if it's a testing environment where SQL has been installed and uninstalled several times, there may be folders which have older dates.
neoHypocrite
- Edited by Suraj GanigaMicrosoft employee Tuesday, January 28, 2014 6:13 AM
- Marked as answer by bhat BK Tuesday, January 28, 2014 6:23 AM
Tuesday, January 28, 2014 6:13 AM -
Thanks a lot.
Shashikala
Tuesday, January 28, 2014 6:23 AM -
SELECT [create_date] FROM [master].[sys].[symmetric_keys] GO
Tuesday, April 22, 2014 11:39 PM -
It's funny that the answer with "syslogins" table is spread in dozens of forums and blogs.
I found another query, which has by the way an enormous advantage: It needs less access rights !
SELECT modify_date from master.sys.servers where server_id = 0
Should be pretty accurate, unless someone fumbled with "sp_dropserver" on id=0, which you normally only do if you renamed the OS or did other "weird" stuff.
- Edited by matt_pohlig Friday, April 8, 2016 1:47 PM
Friday, April 8, 2016 1:11 PM