How to Test after Applied latest 2016 Cumulative Update, SP2, CU 15 to 2016 SQL Servers

Question

Recently, our SQL Servers have been Applied latest 2016 Cumulative Update, SP2, CU 15 to 2016 SQL Servers. I am not working on SQL team. How can we ensure the updates are successful and working properly?

After the installation of the CU15, there are some changes on these applications versions:
Microsoft SQL Server 2016 Setup (English) 13.2.5850.14
Browser for SQL Server 2016 13.2.5026.0
Microsoft VSS Writer for SQL Server 2016 13.2.5026.0
Microsoft ODBC Driver 13 for SQL Server 13.2.5850.14

Thanks very much for any correct info.

Answer 1

Hi @Sheng, Linda -SIEQ ,

You can check the SQL Server services under SQL Server Configuration, the event viewer, SQL Server logs, or try to open a connection using the below query:

try
{
SqlConnection con = new SqlConnection("YOUR_CONNECTIONSTRING");
con.Open();
con.Close();
}
catch (Exception)
{
throw;
}

Regards,

---

Youssef Saad | New blog: https://youssef-saad.blogspot.com
Please remember to ** “Accept answer” ** for useful answers, thank you!

Answer 2

Hi @Sheng, Linda -SIEQ ,
You can check the SQL Server version after update using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version information in parentheses, together with the user name that is used to connect to the specific instance of SQL Server.

You also can look at the first few lines of the Errorlog file which is located at Program Files\Microsoft SQL Server\MSSQL13.\MSSQL\LOG\ERRORLOG for that instance after updating.

Or you can connect to the instance of SQL Server in SSMS, and then run the following query:

Select @@VERSION  

Please refer to this doc for more details.
Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.