June 30, 2009 at 9:37 am
Anyone have any suggestions on how to monitor DDL level events (CREATE/DROP/ALTER OBEJCT) without using the DDL Trigger eature in SQL Server 2005?
Sadly our primary accounting software app turns off 3 key SET OPTIONS required by SQL Server for DDL triggers to work and so use of DLD Triggers is not an option for our environment. They are
CONCAT_NULL_YIELDS_NULL
ANSI_WARNINGS
ARITHABORT
While it would be nice to have a way to catch (in some form be it a table log, email or anything) changes to objects like is done with DDL triggers. At a minimum I'd like a way to catch DROP/CREATE/ALTER actions against VIEWS at a minimum and if possible SP's & UDF's. I'm not too concerned with table changes because our app doesn't do anything to those without an explcit command by us (like with a SP/Update to the app). We are however having problems withs ome VIEWS getting alytered thru a DROP - CREATE action and I'd like to catch that wehn it happens.
Thanks
Kindest Regards,
Just say No to Facebook!June 30, 2009 at 9:50 am
A permanently running server-side trace.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply