• 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.