You're on the right track. But note that, like it's highlighted on the documentation, because the SQL Server query optimizer typically selects the best execution plan for a query, it's...

That's a challenging project you are working on. Auditing and logging tables are really underrated as far as records management goes. Everyone wants to keep track of changes, but rarely...

Thank you. Always good to work with real open data.

Thank you for noticing. I submitted an update to complete the statement.

"In ReadyRoll, we would track the changes as they occurred, and they'd be executed in the order you made them in."

In one word: Excellent!

Steve Jones - SSC Editor (6/9/2016)

---

g.britton (6/8/2016)

---

Just to quickly answer the final question:

These days, it seems everyone is doing CI with SQL...

Thank you for your comment. I wouldn't go as far as state that it doesn't solve anything. You can automate and track schema changes on individual files, including constraints.

What you...