Create SQL Server table using SSMS

Discussion in 'Databases' started by Dale Fye, Dec 7, 2018.

Tags:
  1. Dale Fye

    Dale Fye

    I'm trying to use SSMS 2014 (GIU) to create a new table in my SQL Server database, but get this error message when I click on Tables => New => Table

    upload_2018-12-7_7-21-7.png

    I can obviously use the Create Table method to do this, but was just wondering whether this is because I'm currently using SSMS 2014.
     
    Dale Fye, Dec 7, 2018
    #1
  2. Elshadriel

    Elshadriel Winhost Staff

    Does the version of the database you created through the Control Panel match the version of SQL Server Management Studio you're using (i.e. 2014)?
     
    Elshadriel, Dec 7, 2018
    #2
  3. Dale Fye

    Dale Fye

    No, I'm guessing that the database is probably SS 2016, and SSMS is 2014.
     
    Dale Fye, Dec 7, 2018
    #3
  4. Elshadriel

    Elshadriel Winhost Staff

    Yeah, the versions have to match, or you might run into the errors like the one above.
     
    Elshadriel, Dec 12, 2018
    #4
    Dale Fye likes this.
  5. Dale Fye

    Dale Fye

    Thanks, I upgraded my SSMS to 17.9.1 and it is working fine
     
    Dale Fye, Dec 13, 2018
    #5
    ComputerMan and Elshadriel like this.

Share This Page