are you talking about DDL & DML changes to the sql data or change to the actual server, such as a new user has been added, timeout connections setting has been modified?

DDL & DML changes you can capture with sql profiler, look into default trace and expand on that

for the actual change, you might need to write up some of your own code in c# or c++ or buy a 3rd party software.