Confilct in SQL Server version
I know that SELECT @@version gets the version of server.
But when SSMS booting, it shows SQL Server 2014.
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
Solution
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
- Design in Query Editor disabled for Azure databases
- In SSMS SP debugger, can "Watch" variable value length be increased above 255 character limit
- Convert hour to 12 hr format after extracting 'hour' using DatePart(hour,Datetime)
- Get default value of stored procedure parameter
- SSMS agent job using scp command to transfer files to sftp is going to loop and not completing
- SSAS : Last 12 months data from cube returning NULL
- How to enter 'NULL' into SSMS cell?
- CTRL+R does not hide the Query Result window in SSMS
- How can I connect to MS Dynamics 365 CRM with SSMS
- UPDATE Statement with concatenate row values
- Selecting a single value from a table
- Opening .sql files in SSMS 2012 as default program and with existing instance
- SQL Server job for copying data from a database to another one
- Use an array to add permission to a list of users in ssms
- Grey out 'Edit Top 200 Rows' SSMS
- SQL Server: how to construct a IF like system within "where" clause?
- SSMS status bar color bug
- Agent jobs on SSIS package failed
- SSMS Set Statistics Time On/Off prints multiple lines instead of just one
- How to disable nesting of triggers at table or trigger level in SQLServer?
- How to search for a string/substring in SSMS results?
- Filter out identical rows od data based on mutliple criteria to only show outliers
- trying to improve performance of a join in SQL query
- SSMS: How to return only the value in the last row for each month/year instead of every row?
- SQL Server Management Studio: Display executed date/time on the status bar
- Sum all the previous work experiences (into months) where rows are dynamic (1 row for 1 experience) and different for each employee
- Dynamic date case statement
- Looking to be sure that errors get caught properly in my stored procedure
- Autocomplete table names are not showing up
- Need to concatenate to a field value, after checking if value [isnull]