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 

11 comments:

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

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

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

Post a Comment