T-SQL to find the SQL Server Installation date | SansSQL

Tuesday, May 20, 2014

T-SQL to find the SQL Server Installation date

Here is an handy T-SQL to find the installation date of SQL Server.

DECLARE @date AS VARCHAR(50), @ServerName AS VARCHAR(100)

SELECT @ServerName = CAST(SERVERPROPERTY('SERVERNAME') AS VARCHAR)

SELECT @date = convert(varchar(50),create_date,107) 
FROM sys.server_principals
WHERE name='NT AUTHORITY\SYSTEM'

PRINT 'This SQL Server Instance "' + @ServerName + '" was insalled on '+ @date 

42 comments:

Rajesh said...

Are you Ready to learn java???

Java Training in Chennai

Unknown said...

Nice post. This is very useful. Thanks for sharing.

web designing course chennai

Unknown said...

Hi,
very simple with useful information thanks for posting. Erptree is best training center for oracle and its modules.for more info just visit our website .
Thank you.
Oracle EBS Online training

Brave Technologies said...

Thank you for Sharing. We are leading erp software solution providers in chennai. For more details call +91 9677025199. erp in Chennai

Unknown said...

It's interesting that many of the bloggers your tips helped to clarify a few things for me as well as giving.. very specific nice content. And tell people specific ways to live their lives.Sometimes you just have to yell at people and give them a good shake to get your point across.
Web Design Company
Web Development Company
Mobile App Development Company

Unknown said...


Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
Web Design Company
Web Development Company

Unknown said...

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
Android App Development Company

Unknown said...

great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
Web Design Development Company
Web design Company in Chennai
Web development Company in Chennai

louis philip said...

You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...
Fitness SMS
Salon SMS
Investor Relation SMS

isabella jacob said...

it is really amazing...thanks for sharing....provide more useful information...
Mobile app development company

Unknown said...

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
iOS App Development Company

unknown said...

Java is high level programming language .Due to its stability and scalability, you can find Java on mobiles, desktops, large scale applications etc. Java is also gaining big in the field of Internet of Things (IoT).
Java training center in chennai

louis philip said...

I am expecting more interesting topics from you. And this was nice content and definitely it will be useful for many people.
Texting API
Text message marketing
Digital Mobile Marketing
Sms API
Sms marketing

Unknown said...

Hi Good day....

Excellent post and very useful for everyone...keep updating
php training in coimbatore

seo training in coimbatore

web design training coimbatore

hannah cyrus said...

Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
snapho

Rajesh said...

Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.


Oracle Fusion Financials Online Training

Rainbow Training Institute said...

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

Oracle Fusion HCM Online Training

Unknown said...

Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.

AWS Training in Chennai

sonali said...

Thank you Admin!
1 crore projects center specializes in Embedded Testing Training in chennai

Bairavi said...

Thank you for sharing this valuable information.
php training in chennai | android training in chennai

Moses said...

Awesome post!

Thanks.You can learn best Advance Java Training in Chennai | Arduino Training in chenna

Krishnakumar said...

Interesting and worth Post!
Matlab Training in Chennai | Embedded System Training in Chennai

sunshineprofe said...

You truly did more than visitors’ expectations. Thank you for rendering these helpful, trusted, edifying and also cool thou
nebosh course in chennai
ghts on the topic to Kate.

Sherin Alfonsa said...

Excellent article with lots of new updates. Thank you

Selenium Training in Chennai
Best Selenium Training Institute in Chennai
ios developer training in chennai
.Net coaching centre in chennai
French Classes in Chennai
Big Data Training in Chennai
Best JAVA Training in Chennai
Digital Marketing Courses

Shanthi Cabs said...

Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us @ Best Travels in Madurai | Tours and Travels in Madurai | Madurai Travels

Rigid Box said...

Information from this blog is very useful for me, am very happy to read this blog Kindly visit us @ Luxury Watch Box | Shoe Box Manufacturer | Luxury Cosmetics Box

shivani said...

Astonishing web diary I visit this blog it's incredibly magnificent. Strangely, in this blog content made doubtlessly and sensible. The substance of information is instructive.
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training

shivani said...

A bewildering web journal I visit this blog, it's unfathomably heavenly. Oddly, in this present blog's substance made purpose of actuality and reasonable. The substance of data is informative
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training

shivani said...

A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training

shivani said...

An overwhelming web journal I visit this blog, it's unfathomably amazing. Unusually, in this present blog's substance made inspiration driving truth and reasonable. The substance of data is enlightening
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training

Rainbow Training Institute said...

Such a nice blog, I really like what you write in this blog, I also have some relevant information about if you want more information.

Oracle Fusion HCM Online Training

Rainbow Training Institute said...

Nice post. your article is really informative and helpful for me and other bloggers too

Big Data and Hadoop Online Training
Big Data Hadoop Training
Hyderabad

Rainbow Training Institute said...

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

Spark and Scala Online Training
Spark Scala Training
Hyderabad

James said...

Many industries use data science in order to automate different tasks. Businesses use historical data for training their machines to do repetitive tasks. And this is what simplifies arduous jobs done by humans a few years back. data science course syllabus

Ashok said...

I’m happy I located this blog! From time to time, students want to cognitive the keys of productive literary essays composing. Your first-class knowledge about this good post can become a proper basis for such people. nice one
data science course in India

rstrainings said...


I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up

Devops Training in Hyderabad

Hadoop Training in Hyderabad

Python Training in Hyderabad

Tableau Training in Hyderabad

Selenium Training in Hyderabad

Unknown said...

This article will outline all the different strategies you should be aware of when it comes to soccer.

Best IAS Coaching in India

Nearlearn said...

very very informative post for me thanks for sharing

BlockchaincClassroom Training Course in Bangalore

Escorts in Noida said...

Escort Service In Gurgaon - Our call girls agency is ready to meet your all needs. They are enjoying most seductive female call Girls from different parts of the World. Have you ever date any female in your life? If no then you do not know the real taste of dating fun with a call girl. Then our Gurgaon Escorts service will help you to tackle your dreams with one of the independent female escort agencies.

Escort Service In Gurgaon
https://www.kajalvermas.com/escort-service-in-gurgaon/

Best IAS Coaching In India said...

This article will outline all the different strategies you should be aware of when it comes to soccer.

Best MPSC Coaching in Mumbai

Best IAS Coaching in Navi Mumbai

Best IAS Coaching in dadar

Best IAS Coaching in Thane

Best IAS Coaching in Andheri

Best IAS Coaching in Mumbai

Best ias coaching in borivali

Best IAS Coaching in bhandup

Sarika A said...

I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it. We are providing the best services click on below links to visit our website.
Oracle Fusion HCM Training
Workday Training
Okta Training
Palo Alto Training
Adobe Analytics Training

rstrainings said...


I am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up

Devops Training in Hyderabad

Hadoop Training in Hyderabad

Python Training in Hyderabad

Tableau Training in Hyderabad

Selenium Training in Hyderabad

Post a Comment

Ads