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

DDL Triggers Implementation Expand / Collapse
Author
Message
Posted Monday, October 6, 2008 12:16 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 15, 2013 6:55 PM
Points: 137, Visits: 251
Comments posted to this topic are about the item DDL Triggers Implementation
Post #581302
Posted Monday, October 6, 2008 2:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:51 AM
Points: 1,262, Visits: 3,422
nice stuff here!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #581359
Posted Monday, November 23, 2009 4:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 1, 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
Posted Wednesday, February 24, 2010 8:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 6, 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
Posted Friday, February 26, 2010 11:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 15, 2013 6:55 PM
Points: 137, Visits: 251
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
Posted Friday, February 26, 2010 11:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 15, 2013 6:55 PM
Points: 137, Visits: 251
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
Posted Friday, February 26, 2010 11:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 15, 2013 6:55 PM
Points: 137, Visits: 251
Change [Sch_AuditDdl] to proper schema most of the time (dbo).
or create a new schema with name [Sch_AuditDdl]
Post #873625
Posted Wednesday, July 7, 2010 12:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 8:59 AM
Points: 42, Visits: 178
Look here for a full solution: http://www.sqlservercentral.com/Forums/Topic948331-149-1.aspx
Post #948336
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse