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

Sheng, Linda -SIEQ 1 Reputation point
2020-12-23T20:12:57.97+00:00

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.
13,364 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Youssef Saad 3,406 Reputation points
    2020-12-23T20:41:49.053+00:00

    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!

    0 comments No comments

  2. AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
    2020-12-24T02:42:53.16+00:00

    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.

    50898-2.jpg
    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.

    50876-3.jpg

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

    Select @@VERSION  
    

    50877-4.jpg

    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.

    0 comments No comments