I havethe table and the existing trigger that works. I originally had a server level trigger set up that works good but seemed to have some issues when our environment performed certain task in the database. So i had to figure out a different way to track the ddl events. I found useful info on this site and another. As for now the tracking works with the logging i just need a way to send the email on change as well like this example. I tried creating a new trigger on a table that has this information but when its enabled it disables service broker no errors im sure there is a conflict somewhere. Help is approciated thanks
This is how it works now
Database level event 104 has occurred in database [SChemaChange.[DBA]:
Schema change event type: CREATE_TABLE
Object: [dbo].[Table_2]
Changed by:
Changed datetime: Apr 16 2013 9:59AM
Please verify that this is an Authorized Change.