• Could? yes, of course.

    Should? dunno. depends on the goal.

    As for using VCS to compare the databases, I'd say it depends... We cannot because our Production database is very separate from development - geographically 5000 miles, and it's behind a separate firewall in a datacenter.

    We've opted to use SQL Compare to periodically check the drift on our 40+ databases.

    We keep our Development database schema in VCS (actually twice: once using Redgate Source Control for developer level tracking, and once using a Powershell script daily to write all object-scripts to a source-controlled folder - a holdover from when Enterprise Manager dropped its VSS support. I keep it going because I'm 'conservative' that way. And yes, I've been source-controlling my databases since the good old days of 6.0/6.5)

    As for auditing: On both Dev and Prod a daily job runs a query against the default trace logs to capture and log object changes ... I can see who changed what and when. (I review this log daily for security purposes)

    Mark
    Just a cog in the wheel.