Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Auditing DDL in SQL Server 2005 Expand / Collapse
Author
Message
Posted Wednesday, September 26, 2007 1:25 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, March 27, 2010 5:56 AM
Points: 12, Visits: 79
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.
Post #403199
Posted Wednesday, September 26, 2007 2:02 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, November 18, 2013 12:29 PM
Points: 908, Visits: 2,801
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
Post #403213
Posted Wednesday, July 07, 2010 12:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 20, 2014 1:15 PM
Points: 42, Visits: 177
Look here for a full solution: http://www.sqlservercentral.com/Forums/Topic948331-149-1.aspx
Post #948334
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse