SQLServerCentral.com / Administering / SQL Server 2005 / sql auditing triggers / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 16:48:58 GMT20RE: sql auditing triggershttp://www.sqlservercentral.com/Forums/Topic588094-146-1.aspxThanks Gail, created thread 'SQL 2008 R2 - CDC or Trigger'Tue, 08 Jan 2013 15:20:05 GMTkevin_nikolaiRE: sql auditing triggershttp://www.sqlservercentral.com/Forums/Topic588094-146-1.aspxPlease post new questions in a new thread. Thank you.Mon, 07 Jan 2013 15:04:55 GMTGilaMonsterRE: sql auditing triggershttp://www.sqlservercentral.com/Forums/Topic588094-146-1.aspxBoth a trigger and cdc (change data capture) can be enabled to monitor changes to a table. When would you use each of them ?Mon, 07 Jan 2013 14:51:53 GMTkevin_nikolaiRE: sql auditing triggershttp://www.sqlservercentral.com/Forums/Topic588094-146-1.aspx[quote][b]nzubaria (10/28/2008)[/b][hr]HiActually I am Developing a Database Auditing Infrastructure. I am working in SQL Server 2005. So my main focus of area is "SQL Triggers" and "stored Procedures". I ask for help on CLR routine i thought it would help me.[/quote]Anything dealing with data is probably better written in T-SQL than CLR, unless you have a good reason to need the CLR[quote]If you can me some other suggestion. I would be thankful to you. Secondly can you suggest me a way that is there any possibility of writing Generalized DML triggers on all tables of database or not ???[/quote]It is possible, but I would strongly recommend against it. Generic triggers tend to perform poorly, leading to slow data changes, deadlocks and all other such unpleasant things.What I've done in the past is to have a stored procedure that can, using dynamic SQL, create triggers on all tables. That way you only have to write the code once, but the triggers are specific to their tables and hence reasonably fast.Wed, 29 Oct 2008 01:04:19 GMTGilaMonsterRE: sql auditing triggershttp://www.sqlservercentral.com/Forums/Topic588094-146-1.aspxHiActually I am Developing a Database Auditing Infrastructure. I am working in SQL Server 2005. So my main focus of area is "SQL Triggers" and "stored Procedures". I ask for help on CLR routine i thought it would help me.If you can me some other suggestion. I would be thankful to you. Secondly can you suggest me a way that is there any possibility of writing Generalized DML triggers on all tables of database or not ???Thanks for fast ReplyRegardsTue, 28 Oct 2008 23:18:54 GMTnzubariaRE: sql auditing triggershttp://www.sqlservercentral.com/Forums/Topic588094-146-1.aspxThere is information in Books Online on DDL triggers and lots of articles on CLR programming. In addition to Gail's questions, you should do some research and ask specific questions, not an open one about how to do all of some project.Sun, 19 Oct 2008 11:43:10 GMTSteve Jones - SSC EditorRE: sql auditing triggershttp://www.sqlservercentral.com/Forums/Topic588094-146-1.aspxWhat do you want to do with said trigger and why do you have to use CLR?Sat, 18 Oct 2008 03:16:42 GMTGilaMonstersql auditing triggershttp://www.sqlservercentral.com/Forums/Topic588094-146-1.aspxI have to write DDL trigger in sql 2005, using CLR feature. Can anyone provides help in this regardSat, 18 Oct 2008 02:43:25 GMTnzubaria