On Feb 26, 3:04*am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> John Sheppard (s...@nospam.com) writes:
> > Does anyone know of a way to track changes to anSQLServerdatabase so
> > that I can easily run those changes at a later date?
>
> > That is, I want to make schema changes, and record those changes so thatI
> > can execute them 6 months later on a copy of the orignal database.
>
> Develop scripts and keep them under source control.
>
> If you forgot to that,SQLComparefrom Red Gate can be your rescue.
>
> --
> Erland Sommarskog,SQLServerMVP, esq...@sommarskog.se
>
> Books Online forSQLServer2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online forSQLServer2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

As can xSQL Object from xSQL Software (http://www.xsqlsoftware.com)
and what's even better you may not have to pay a dime for it as it is
free for SQL Server Express and also free for other editions of SQL
Server with some limitations.

JC