Our development team uses a single development server. Remote desktop is used. Each user has their own TFS workspace on that server. They use a shared database.
When one does get the latest, one needs to have the TFS workspace updated with the latest changes to the database project in TFS. A script is not needed to be created to update the database, since it will already be updated.
How can this be done?