How to know when SQL server version updated

Hi All,

If I issue "select @@version" over SQL server, I get version like this:

Microsoft SQL Azure (RTM) - 11.0.9231.104   Aug 28 2015 18:11:22   Copyright (c) Microsoft Corporation 

How to know when it was updated? I understand, it was after Aug, 28, but when exactly? Where could I get this information?

Thanks,

Sergei.

September 9th, 2015 10:37am

On August 28th at 6:11 PM and 22 seconds..... thats not exact enough for you? lol

You could also get the info from the event logs under Windows Installer.

Free Windows Admin Tool Kit Click here and download it now
September 9th, 2015 2:24pm

Ha-ha. Good point.

Frankly speaking, I thought this is date of 11.0.9231.104 build, not when SQL server was updated. Let me check...

September 9th, 2015 4:07pm

... and I see my supposition was correct. I have another V11 Azure server, and it displays same time.

So the question is still active. How to know when updated build of SQL server applied in Azure? I don't believe it occured at 6:11pm for all servers.

How to access Windows Installer from within SQL Server Management Studio? So far this is the only way I can communicate with SQL Azure server.

Free Windows Admin Tool Kit Click here and download it now
September 9th, 2015 4:13pm

Azure SQL DB deploys update to the service very frequently. Sometimes deployment happen multiple times a day. Hence, tracking the deployment time will be tricky.

Can you elaborate your need/scenario for the deployment time?

-Peh

September 15th, 2015 1:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics