home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,973 of 19,505   
   JoeM to All   
   Need example showing how to log DML even   
   30 Dec 13 18:42:58   
   
   From: noreply@replytogroup.com   
      
   I need to modify my SQL 2008 R2 database as follows:   
      
   I need to log insert, update, and delete events for a specific   
   table.  I would like the changes logged to a table, and I would   
   also want to receive an email for certain changes.   
      
   Does anyone know of some sample SQL scripts that will create   
   the table and triggers?  Better yet would be an entire SQL   
   sample database which can be downloaded.  Thanks   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca