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:
The ssms.pkgundef file supresses the team menu by default. We can overide the default configurations by making a slight modification to the file.
- Navigate to ssms.pkgunder file, default location is C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio.
- 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.
- Save the file and on re-open SSMS. You will now see the team menu.