Upgrade Issue 2016 to 2017

Rohit Kulkarni 686 Reputation points
2023-02-28T13:43:50.07+00:00

Hello Team,

I have update the MS SQL Server from 2016 to 2017.The upgrade went fine.

But when i logged in to the instance and trying to change the database to 2017.

In the Propertires-->Options-->Compatibility Level

This option is blank. Please advise can any one.

User's image

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

Accepted answer
  1. Seeya Xi-MSFT 16,461 Reputation points
    2023-03-01T06:28:59.25+00:00

    Hi @Rohit Kulkarni,

    Yes. You need install the latest SSMS. It seems that your SSMS is version 16.X. This only applies to SQL Server 2016 and prior versions. You can see your current SSMS version here.

    From the SSMS navigation bar click on Help->About.. :

    User's image

    SSMS 19.0.1 is the latest general availability (GA) version. You can install it.

    Best regards,

    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Guoxiong 8,201 Reputation points
    2023-02-28T14:12:20.1366667+00:00

    I guess you use an earlier version of SQL Server Management Studio (SSMS). Try to use the latest version of SSMS and see if that solve your issue. Here is the link to Download SQL Server Management Studio (SSMS).

    0 comments No comments

  2. Erland Sommarskog 107.2K Reputation points
    2023-02-28T22:54:38.5333333+00:00
    ALTER DATABASE db SET COMPATIBILITY_LEVEL = 140
    
    0 comments No comments