Get version SSMS

Marco Bakker | DBA.nl 72 Reputation points
2021-04-01T15:12:28.99+00:00

Hi guys,

I would like to know how to get the version information of SSMS?

kind regards
Marco

SQL Server | Other
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Marco Bakker | DBA.nl 72 Reputation points
    2021-04-01T16:40:19.623+00:00

    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

    2 people found this answer helpful.

  2. Dan Guzman 9,406 Reputation points
    2021-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, RunSELECT @@VERSION; from an SSMS query window connected to the database server.

    0 comments No comments

  3. 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

    0 comments No comments

  4. Michael Taylor 60,326 Reputation points
    2021-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?

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.