Are you trying to get the CREATE statement checked into TFS every night? I'm not sure why you do this. Really you only check in changes, so you'd just be looking for changed objects.

The Red Gate tool requires the developer to do this, though any developer can see if an item in a db is changed against VCS.

If you want to automate some check to see if things are not getting checked in, really you are auditing. You might like this article: https://www.simple-talk.com/sql/database-administration/auditing-ddl-changes-in-sql-server-databases/. It can probably be adapted for TFS.

Disclosure: I work for Red Gate