At certain times branches may ask to protect teams (occasionally they will say lock/unlock teams). To do this you'll need to run the attached script also found under the SQL Queries folder (Update Team Protected Status by Office and Season (with exceptions)).


When running this script you'll need to select:

  1. the Team Protected Status:
    • No
    • Yes
    • Team Add Only
  2. the season to change the status on
  3. an office from which every team from every office underneath it will be affected (so you can select at any level: Branch, Region, District or MHA)
  4. the office(s) you want to exclude from this update to the team protected status. To add more simply copy paste the last line in the screenshot below (making sure to remove the two dashes '--'.