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 @date = convert(varchar(50),create_date,107) 
FROM sys.server_principals

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


Rajesh said...

Are you Ready to learn java???

Java Training in Chennai

Anu Sri said...

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

web designing course chennai

oracle R12 said...

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

Sharon Sandy 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

Reena raj 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

john stany 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

Sharon Sandy 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

john stany 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 marketing

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

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

murali krishna 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

mari A 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

sobiga J 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

Safety Professionals 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

Post a Comment