Click here to Skip to main content
15,568,965 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen19-May-12 6:05
professionalEddy Vluggen19-May-12 6:05 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201120-May-12 3:42
jojoba201120-May-12 3:42 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen20-May-12 4:03
professionalEddy Vluggen20-May-12 4:03 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201120-May-12 18:38
jojoba201120-May-12 18:38 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen21-May-12 5:30
professionalEddy Vluggen21-May-12 5:30 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:11
jojoba201121-May-12 21:11 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen22-May-12 1:52
professionalEddy Vluggen22-May-12 1:52 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 4:22
jojoba201122-May-12 4:22 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen22-May-12 9:50
professionalEddy Vluggen22-May-12 9:50 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201123-May-12 0:24
jojoba201123-May-12 0:24 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen23-May-12 1:16
professionalEddy Vluggen23-May-12 1:16 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201123-May-12 4:37
jojoba201123-May-12 4:37 
AnswerRe: How to get delete/Update row + SQL Pin
Eddy Vluggen23-May-12 9:23
professionalEddy Vluggen23-May-12 9:23 
AnswerRe: How to get delete/Update row + SQL Pin
Mycroft Holmes20-May-12 13:55
professionalMycroft Holmes20-May-12 13:55 
AnswerRe: How to get delete/Update row + SQL Pin
Corporal Agarn21-May-12 1:49
professionalCorporal Agarn21-May-12 1:49 
GeneralRe: How to get delete/Update row + SQL Pin
Eddy Vluggen21-May-12 4:45
professionalEddy Vluggen21-May-12 4:45 
GeneralRe: How to get delete/Update row + SQL Pin
Corporal Agarn21-May-12 4:51
professionalCorporal Agarn21-May-12 4:51 
GeneralRe: How to get delete/Update row + SQL Pin
Eddy Vluggen21-May-12 5:27
professionalEddy Vluggen21-May-12 5:27 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 14:04
JohnPayton21-May-12 14:04 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:08
jojoba201121-May-12 21:08 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 21:25
JohnPayton21-May-12 21:25 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:34
jojoba201121-May-12 21:34 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 21:51
JohnPayton21-May-12 21:51 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 22:22
jojoba201121-May-12 22:22 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton22-May-12 13:52
JohnPayton22-May-12 13:52 
Yes that's right, you keep the values you are inserting/updating/deleting then call a routine to record the changes in the ascii text audit file. Smile | :)

Re Getting data from the DB, I'm sorry but I don't know how to retrieve data from SQLServer from past transactions, I'm sure it's possible from the transaction log. But in my circumstances it's been easier to just store the old values and new values when they happen to variables then send to the ascii log file.

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.