I'm posting on this site cause I have found this site very helpful. I have a question to all the pros here and that is I'm trying to audit all DDLs on SQL 2000 and 2005 databases including the TSQL,username,Server name, database name, the time etc. and was wondering if there is any script that would do this for me. I would like to send an email to a user when ever there is any DDLs change. Any help will be appreciated.