Generating Scripts for Table Alterations in SQLServer

Hi,

I am using SQLServer and I would like to track changes or generate scripts for every change or alteration made to the table.. Please help me with any ideas..

Thank You,

Lesego

Two ways are common.

1. Profiler. Kind of clunky, but more or less guaranteed to see every change made, and cannot be easily overridden

2. In 2005, use a DDL trigger/Event Notification. I use this all of the time to monitor changes to my databases by other people who have dbo rights in cases where things are too political to give more specific rights.