Version control major problem with SSDT, TFS for ALTER script

See more:

SQL

TFS

Hi All,

I have face one problem with SQL Server Data Tools (SSDT) and database project which is manage by TFS.

If some one forgot to check-in db script after ALTER the script [ like alter of store procedure ] then it leads to inconsistent script on DB server and DB project which is under source control (TFS).

Above scenario creating major problem in patch creation.

Can any one suggest me the solution.

What I have tried:

I used schema comparer option of SSDT before patch creation which help me to sync DB server script with DB project which directly alter without check in.
But not solve the purpose of version control