I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.
You need to run the following query and it will give you the date of your SQL Server Installation.
SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’
WHERE SID = 0X010100000000000512000000
SID 0X010100000000000512000000 is belongs to user "NT AUTHORITYSYSTEM". This user create at the time of installation only.
If you liked this post, do like on Facebook at
Reference : Rohit Garg ()