Click here to Skip to main content
14,932,707 members
Home / Discussions / Database


GeneralRe: Unable to Restore MDF file in Vista Pin
Jerry Hammond31-Aug-09 6:13
MemberJerry Hammond31-Aug-09 6:13 
AnswerRe: Unable to Restore MDF file in Vista Pin
Eddy Vluggen31-Aug-09 5:18
professionalEddy Vluggen31-Aug-09 5:18 
Questioner diagram for hospital managment system Pin
noo.dyab28-Aug-09 3:44
Membernoo.dyab28-Aug-09 3:44 
AnswerRe: er diagram for hospital managment system Pin
Ashfield28-Aug-09 4:51
MemberAshfield28-Aug-09 4:51 
AnswerRe: er diagram for hospital managment system Pin
DoctorMick28-Aug-09 5:43
MemberDoctorMick28-Aug-09 5:43 
AnswerRe: er diagram for hospital managment system Pin
Jerry Hammond29-Aug-09 12:01
MemberJerry Hammond29-Aug-09 12:01 
AnswerRe: er diagram for hospital managment system Pin
Eddy Vluggen31-Aug-09 5:20
professionalEddy Vluggen31-Aug-09 5:20 
QuestionLogging Pin
cdpace28-Aug-09 3:03
Membercdpace28-Aug-09 3:03 
Hello guys,

I would like to create a log of what is happening in my database. What i exactly mean is that i need to log every update, insert and delete statement that executes in my database. for example when a delete happens i want to keep the values that have been delete, when an update happens i want to keep the old values and the new ones etc.

Another important thing is that i want to achieve this without the use of triggers is possible.

How can this be done?
AnswerRe: Logging Pin
Ashfield28-Aug-09 4:52
MemberAshfield28-Aug-09 4:52 
GeneralRe: Logging Pin
cdpace28-Aug-09 4:59
Membercdpace28-Aug-09 4:59 
GeneralRe: Logging Pin
Blue_Boy28-Aug-09 5:04
MemberBlue_Boy28-Aug-09 5:04 
GeneralRe: Logging Pin
Ashfield28-Aug-09 8:18
MemberAshfield28-Aug-09 8:18 
GeneralRe: Logging Pin
cdpace28-Aug-09 11:25
Membercdpace28-Aug-09 11:25 
GeneralRe: Logging Pin
Ashfield29-Aug-09 3:57
MemberAshfield29-Aug-09 3:57 
GeneralRe: Logging Pin
εїзεїзεїз30-Aug-09 20:37
Memberεїзεїзεїз30-Aug-09 20:37 
GeneralRe: Logging Pin
Ashfield31-Aug-09 2:42
MemberAshfield31-Aug-09 2:42 
GeneralRe: Logging Pin
εїзεїзεїз5-Sep-09 22:18
Memberεїзεїзεїз5-Sep-09 22:18 
GeneralRe: Logging Pin
Ashfield6-Sep-09 21:19
MemberAshfield6-Sep-09 21:19 
AnswerRe: Logging Pin
εїзεїзεїз30-Aug-09 20:36
Memberεїзεїзεїз30-Aug-09 20:36 
QuestionHelp writing query Pin
michaelgr128-Aug-09 2:04
Membermichaelgr128-Aug-09 2:04 
AnswerRe: Help writing query Pin
Mycroft Holmes29-Aug-09 15:22
professionalMycroft Holmes29-Aug-09 15:22 
QuestionSQL:Problem in dynamic sql query [modified] Pin
xodeblack27-Aug-09 22:37
Memberxodeblack27-Aug-09 22:37 
AnswerRe: SQL:Problem in dynamic sql query Pin
Mycroft Holmes28-Aug-09 0:45
professionalMycroft Holmes28-Aug-09 0:45 
QuestionPlease suggest Pin
ME_Learner27-Aug-09 20:25
MemberME_Learner27-Aug-09 20:25 
AnswerRe: Please suggest Pin
Mycroft Holmes28-Aug-09 0:50
professionalMycroft Holmes28-Aug-09 0:50 

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.