I am using SQL 2000 and would like to somehow track/log changes made to the database schema (e.g. create/alter/drop on stored procedures, tables, views, etc) the most ideal situation would be if i could log all the changes including the actual change commands but even i could only get what and when objects were changed, that would be ok. the ideas i've come up with include logging all activity via SQL profiler, or putting a trigger on the sysobjects table in the DB (although i tried this and it told me permission denied)
if anyone has any ideas or suggestions, that would be greatly appreciated.
ok well i figured out how to track the changes using a trace in SQL profiler. but this still requires me to have profiler running. now i'm trying to get the trace to run as a SQL Agent job, but so far its not quite working. anyone have any experience with running SQL traces via a stored procedure or Job?