Click here to Skip to main content
15,509,458 members
Home / Discussions / Database
   

Database

 
AnswerRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
PIEBALDconsult22-Apr-15 6:15
professionalPIEBALDconsult22-Apr-15 6:15 
GeneralRe: Creating SSIS OLE DB Source with Parameters programmatically with .NET Pin
Dr Miroslav Stimac22-Apr-15 6:31
professionalDr Miroslav Stimac22-Apr-15 6:31 
QuestionMaster slave model in databases Pin
holykrish20-Apr-15 20:10
holykrish20-Apr-15 20:10 
SuggestionRe: Master slave model in databases Pin
Richard MacCutchan20-Apr-15 22:45
mveRichard MacCutchan20-Apr-15 22:45 
AnswerRe: Master slave model in databases Pin
Mycroft Holmes21-Apr-15 1:43
professionalMycroft Holmes21-Apr-15 1:43 
QuestionAlert when row deleted (SQL Server 2012) Pin
Member 1151899220-Apr-15 3:03
Member 1151899220-Apr-15 3:03 
AnswerRe: Alert when row deleted (SQL Server 2012) Pin
Tim Carmichael20-Apr-15 3:14
Tim Carmichael20-Apr-15 3:14 
AnswerRe: Alert when row deleted (SQL Server 2012) PinPopular
David Mujica20-Apr-15 4:31
David Mujica20-Apr-15 4:31 
I would not recommend sending an email directly from a delete trigger because you may pay a performance penalty and possibly abort your delete transaction if the email server cannot send your message.

Slight change in approach would be to write a custom "logging" table where you capture the entire row from the table and store it. You can then have a separate program read through this table and send emails notifying your distribution list.

The other advantage is that you have a copy of the deleted data. You can purge this data as you see fit.

Just and idea.
Rose | [Rose] Cool | :cool:
GeneralRe: Alert when row deleted (SQL Server 2012) Pin
Member 1151899221-Apr-15 0:44
Member 1151899221-Apr-15 0:44 
QuestionDebugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 14:20
Kyudos14-Apr-15 14:20 
AnswerRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 15:11
professionalMycroft Holmes14-Apr-15 15:11 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 15:27
Kyudos14-Apr-15 15:27 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 16:19
professionalMycroft Holmes14-Apr-15 16:19 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 16:41
Kyudos14-Apr-15 16:41 
AnswerRe: Debugging DAO to ADO Conversion Errors Pin
Kyudos14-Apr-15 17:02
Kyudos14-Apr-15 17:02 
GeneralRe: Debugging DAO to ADO Conversion Errors Pin
Mycroft Holmes14-Apr-15 18:37
professionalMycroft Holmes14-Apr-15 18:37 
QuestionHow to remove a 1000 seperator from a number Pin
Ambertje14-Apr-15 1:35
Ambertje14-Apr-15 1:35 
AnswerRe: How to remove a 1000 seperator from a number Pin
Jörgen Andersson14-Apr-15 2:30
professionalJörgen Andersson14-Apr-15 2:30 
GeneralRe: How to remove a 1000 seperator from a number Pin
Ambertje14-Apr-15 3:04
Ambertje14-Apr-15 3:04 
GeneralRe: How to remove a 1000 seperator from a number Pin
Mycroft Holmes14-Apr-15 15:15
professionalMycroft Holmes14-Apr-15 15:15 
Questionhow to write xml code to manually create pdf without using third party in oracle apex Pin
Member 1159668313-Apr-15 20:28
Member 1159668313-Apr-15 20:28 
QuestionVB.NET MYSQL loop through records while adding Pin
Pauls Pauls13-Apr-15 10:40
Pauls Pauls13-Apr-15 10:40 
QuestionRe: VB.NET MYSQL loop through records while adding Pin
ZurdoDev13-Apr-15 11:09
professionalZurdoDev13-Apr-15 11:09 
AnswerRe: VB.NET MYSQL loop through records while adding Pin
Pauls Pauls13-Apr-15 11:48
Pauls Pauls13-Apr-15 11:48 
AnswerRe: VB.NET MYSQL loop through records while adding Pin
Mycroft Holmes13-Apr-15 15:21
professionalMycroft Holmes13-Apr-15 15:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.