InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 01:06:46 GMT20http://www.sqlservercentral.com/Forums/Topic581302-463-1.aspxLook here for a full solution: http://www.sqlservercentral.com/Forums/Topic948331-149-1.aspxWed, 07 Jul 2010 00:45:33 GMTSean Elliott (UK)http://www.sqlservercentral.com/Forums/Topic581302-463-1.aspxChange [Sch_AuditDdl] to proper schema most of the time (dbo).or create a new schema with name [Sch_AuditDdl]Fri, 26 Feb 2010 11:37:40 GMTJorge Novo-@ETLDEVDBAhttp://www.sqlservercentral.com/Forums/Topic581302-463-1.aspxPlease 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.Fri, 26 Feb 2010 11:28:51 GMTJorge Novo-@ETLDEVDBAhttp://www.sqlservercentral.com/Forums/Topic581302-463-1.aspxHow 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).Fri, 26 Feb 2010 11:26:58 GMTJorge Novo-@ETLDEVDBAhttp://www.sqlservercentral.com/Forums/Topic581302-463-1.aspxhello 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 ?Wed, 24 Feb 2010 20:17:23 GMTocp_yanghttp://www.sqlservercentral.com/Forums/Topic581302-463-1.aspxHmm, 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.Mon, 23 Nov 2009 04:19:37 GMTBen-425648http://www.sqlservercentral.com/Forums/Topic581302-463-1.aspxnice stuff here!Mon, 06 Oct 2008 14:11:37 GMTDugihttp://www.sqlservercentral.com/Forums/Topic581302-463-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/DDL+Triggers/64536/">DDL Triggers Implementation</A>[/B]Mon, 06 Oct 2008 12:16:14 GMTJorge Novo-@ETLDEVDBA