As business requirements change I need to update post server installation scripts. A mistake in these scripts can cause major issues down the road, thus it's important to version control. One small hinderance of SSMS version 17 - 17.5 is the missing 'Team' menu for TFS intergration.

No team menu:

noteam

The ssms.pkgundef file supresses the team menu by default. We can overide the default configurations by making a slight modification to the file.

  1. Navigate to ssms.pkgunder file, default location is C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio.

pkgdeg-1

  1. Open the file in notepad++ or any text editor with line numbers and comment out lines 19 - 56. Note two forward slashes // convert code to comments.

TFSnoload

  1. Save the file and on re-open SSMS. You will now see the team menu.

team