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 

15 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

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

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

Nearlearn said...

very very informative post for me thanks for sharing

BlockchaincClassroom Training Course in Bangalore

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