0

I know that SELECT @@version gets the version of server.

But when SSMS booting, it shows SQL Server 2014.

SSMS booting

I want to know what original version of SSMS what I am using.

UPDATES 1

As per Antonio Campagnaro's answer, I got more confusion. See below image

Help->About

Pugal
  • 539
  • 5
  • 20

1 Answers1

1

SSMS (SQL Server Management Studio) is a program that can connect to a sql server instance. If you need to know what SSMS you are using you can find it in Help -> About..

If you need to know what sql server instance version you are using you can query SELECT @@VERSION

SSMS and sql server doesn't need to be the same version, but SSMS need to be higher than sql server

Other way to get sql server version

Antonio Campagnaro
  • 546
  • 6
  • 15
  • SQL Server = database engine; SQL Server Management Studio = GUI Administration Tool for working against the SQL Server engine [hope this help](https://stackoverflow.com/questions/22273903/microsoft-sql-server-vs-sql-server-management-studio) – Antonio Campagnaro Jun 28 '18 at 12:32