DDL Triggers Implementation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jorge Novo » DDL Triggers Implementation

DDL Triggers Implementation

Rate Topic

Display Mode

Topic Options

Author

Message

Jorge Novo-@ETLDEVDBA

Posted Monday, October 06, 2008 12:16 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:55 AM
Points: 137, Visits: 250

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

Post #581302

Dugi

Posted Monday, October 06, 2008 2:11 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

nice stuff here!

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

Post #581359

Ben-425648

Posted Monday, November 23, 2009 4:19 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 01, 2013 10:41 AM
Points: 19, Visits: 51

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.

Post #823183

ocp_yang

Posted Wednesday, February 24, 2010 8:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 06, 2012 5:03 AM
Points: 3, Visits: 62

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 ?

Post #872435

Jorge Novo-@ETLDEVDBA

Posted Friday, February 26, 2010 11:26 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:55 AM
Points: 137, Visits: 250

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)
.

Post #873617

Jorge Novo-@ETLDEVDBA

Posted Friday, February 26, 2010 11:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:55 AM
Points: 137, Visits: 250

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.

Post #873618

Jorge Novo-@ETLDEVDBA

Posted Friday, February 26, 2010 11:37 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:55 AM
Points: 137, Visits: 250

Change [Sch_AuditDdl] to proper schema most of the time (dbo).
or create a new schema with name [Sch_AuditDdl]

Post #873625

Sean Elliott (UK)

Posted Wednesday, July 07, 2010 12:45 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 9:32 AM
Points: 42, Visits: 170

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

Post #948336

« Prev Topic | Next Topic »

Permissions