question

MarcoBakker-6120 avatar image
0 Votes"
MarcoBakker-6120 asked MarcoBakker-6120 answered

Get version SSMS

Hi guys,

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

kind regards
Marco

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarcoBakker-6120 avatar image
0 Votes"
MarcoBakker-6120 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DanGuzman avatar image
0 Votes"
DanGuzman answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarcoBakker-6120 avatar image
0 Votes"
MarcoBakker-6120 answered

Thanks for your answer.

I mean via Powershell or CLI

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

cooldadtx avatar image
0 Votes"
cooldadtx answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.