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

Sheng, Linda -SIEQ 1 Reputation point

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,639 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Youssef Saad 3,401 Reputation points

    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:

    SqlConnection con = new SqlConnection("YOUR_CONNECTIONSTRING");
    catch (Exception)


    Youssef Saad | New blog:
    Please remember to ** “Accept answer” ** for useful answers, thank you!

    0 comments No comments

  2. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor

    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,

    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.

    0 comments No comments