14,501 questions
I just want to know the version info which is installed.
I found this
get-childitem <path where ssms.ex is located>\ssms.exe | Format-List VersionInfo
Get version SSMS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Marco Bakker | DBA.nl
72
Reputation points
Hi guys,
I would like to know how to get the version information of SSMS?
kind regards
Marco
SQL Server | Other
4 answers
Sort by: Most helpful
-
Marco Bakker | DBA.nl 72 Reputation points
2021-04-01T16:40:19.623+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 23%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
oldPOSHscriptKiddie 1 Reputation point2022-10-05T13:58:35.333+00:00 Just wanted to say, this is awesome. Been looking for it off and on for a couple of years. Thanks.
Sign in to comment -
-
Dan Guzman 9,406 Reputation points2021-04-01T15:35:52.093+00:00 If you mean the SSMS version, click Help-->About from the SSMS menu bar to see your currently installed version. You can also check for a newer version with Tools-->Check for updates.
To see the SQL Server version, Run
SELECT @@VERSION;from an SSMS query window connected to the database server. -
Marco Bakker | DBA.nl 72 Reputation points
2021-04-01T15:53:10.463+00:00 Thanks for your answer.
I mean via Powershell or CLI
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor 60,331 Reputation points2021-04-01T16:30:22.653+00:00 SSMS is an IDE for developing queries. What is the context under which you'd need to know the version? Are you trying to invoke SSMS via Powershell, which doesn't make sense to me, and need a particular version? Or are you trying to ensure that SSMS is up to date on a client machine?