Recently, the IT department at the office undertook a hardware technology refresh cycle. To facilitate the IT department, we were required to send out a list of all installed programs & supporting components so that they could provide us with new computer systems up-to-date with the right versions and patches.
That was the time when I discovered something interesting. I found a quick way to get the following information about SQL Server client tools right from SSMS:
- SSMS Build Number
- Analysis Services client tools build number (if applicable)
- MDAC version
- MSXML version
- IE version
- .NET framework in use
- Operating System version
I simply browsed out to Help –> About:
Once there, I noticed that all the information is now available on screen. So, I clicked on “Copy Info”, pasted it to Excel and sent it over to my IT department. They were surprised as to how fast I got this information for them. Well, it’s our little secret now, isn’t it?
Until we meet next time,
Be courteous. Drive responsibly.
SQLTwins by Nakul Vachhrajani 
I was amused when i began to read your article, but really interested by the use of copy info button to insert the data in an Excel form.I will be naughty with you , my mark ( like in a school ) : 19/20.I will use your “tip” on MSDN forums when the original poster is unable to give informations about his/her SSMS which has problems.
So Thanks
LikeLike
@Patrick: As long as you post back (i.e. direct the forum member) to this post, please go ahead.
LikeLike