In SQL2000, how can I find what has happened in my DB in particular date?
for example I insert a ne row in table1 and I update 2 rows in table2. now
how can find what did I perfome?
I don't want to monitor the changes simentanously, I want to refer to them
afre some times.
should I refer to .log file of my db?(if ye ,how?) or should I do
something else?
Re: Design question ... I have a table (which I will call table1) that contains rows with ... get tableN FKs to refer to table1.val ... The objective of this exercise is look at the existing design and see ... (comp.databases.oracle.server)
Design question ... I have a table (which I will call table1) that contains rows with ... get tableN FKs to refer to table1.val ... The objective of this exercise is look at the existing design and see ... (comp.databases.oracle.server)
Re: **to trace what has happened** ... in other words, if I want to know what has happened during a period of time should I save the changes as a log file, or is there any place to have it systematically? ...SQL Server will not log the events by default. ... write triggers to audit the Delete/Insert and Update events.... I don't want to monitor the changes simentanously, I want to refer to them ... (microsoft.public.sqlserver.security)
RE: manually incrementing number code does not work in a2003 ... > Mybe, and sorry if it will sound like a silly question, but does the dmax is ... > looking in a table called Table1, but are there any records in this table? ... >>> can refer to it. ... >>> Thank you and Good luck... (microsoft.public.access.formscoding)
RE: Autonumber - with text ... it refer to the table? ... I've created a table (Table1) with two columns - ... use text box with Control Source = ..."Bill" wrote: ... (microsoft.public.access.modulesdaovba)
