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 

26 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

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

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

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

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

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

sonali said...

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

Unknown 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

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...

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

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

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

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/

Healthandfigure said...

chhote ling ki samshiya se mukti paane ke liye aaj mein aap ke liye kuch penis size badhane ki dawa oil jis massage karke aap apne penis ka size doon se teen inch tak lamba aur mota kare skte hain

Arun said...

I think this is one of the most significant information for me. And i'm cheerful examining your article. Regardless, should remark on hardly any expansive things, The site style is amazing, the articles is genuinely incredible.
Quotes on Guru purnima

Post a Comment

Ads