DDL Triggers Implementation

Question

DDL Triggers Implementation

Jorge Novo-@ETLDEVDBA

Ten Centuries

Points: 1265
More actions
October 6, 2008 at 12:16 pm

#382970

Comments posted to this topic are about the item DDL Triggers Implementation

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

nice stuff here!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Ben-425648 SSC Enthusiast Points: 101 More actions · Answer 2

Hmm, sorry, but I disagree, I think this is pretty damn nasty.

A table for each type of object that is changed each having the same schema?

Columns defined for the tables but not actually used, instead the data is kept in the XML column and the view extracts from it, surly with performance implications.

ocp_yang SSC Rookie Points: 29 More actions · Answer 3

hello all:

I use this scripts to create in someone database,then I create the new procedure,

report error following:

Invalid object name 'Sch_AuditDdl.t_procedure'.?

how to resolve it ?

Jorge Novo-@ETLDEVDBA Ten Centuries Points: 1265 More actions · Answer 4

How the data will be store, used and extract that depends on your application, the word nasty is not the word I will used when I don't understand or disagree with something. This implementation is only a guide line that someone agree or disagree is understandable as long as a proper alternative is provided. Here is the scenario:

On a developers shop where source control hasn't been fully implemented at the database level, ddl triggers is a good way to store a historical record of most objects changes.

If most objects normally never change then please explain how that can cause performance issues. ( This implementation shouldn't be in a production environment)

.

Jorge Novo-@ETLDEVDBA Ten Centuries Points: 1265 More actions · Answer 5

Please ensure than when create object didn't create a separate schema using the user login. The error means or the object doesn't exist or there is a mismatch on the object name. Please provide more information about the error.

Jorge Novo-@ETLDEVDBA Ten Centuries Points: 1265 More actions · Answer 6

Change [Sch_AuditDdl] to proper schema most of the time (dbo).

or create a new schema with name [Sch_AuditDdl]

Sean Elliott (UK) SSCommitted Points: 1626 More actions · Answer 7

Look here for a full solution: http://www.sqlservercentral.com/Forums/Topic948331-149-1.aspx