"John Sheppard" <nospam@spamspam.com> wrote in message
news:fq69ch059m@news1.newsguy.com...
>
> "xman" <xman@xsqlsoftware.com> wrote in message
> news:a5d9c513-804d-4eb4-90c6-e7fe3696c2ed@n75g2000hsh.googlegroups.com...
> 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
>> > that I
>> > 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
>
> Hmm, this looks pretty decent, I'll check it on my database tommorow...see
> if it drops tables or alters..drop is
>
> Thanks!
> John

Ahh dang actually no this wont do what I want...

I think a transaction logger is gonna have to be the go...