Tracking SQL Server structure changes

[vibi]

Is there any way I can track if the database structure has changed in SQL Server?

I am generating an XML file that caches database structural information. I need to know when the database structure has changed so I generate the xml file.

Thanks.

Vibi

 

[foxdev]

The only thing I can think of is to put a trigger on SYSOBJECTS, but I wouldn't recommend it. Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause