September 26, 2007 at 1:25 pm
Hi there,
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.
September 26, 2007 at 2:02 pm
Have a look at this article:
http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes
Also, do a search here on DDL and trigger
July 7, 2010 at 12:42 am
Look here for a full solution: http://www.sqlservercentral.com/Forums/Topic948331-149-1.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply