Re: **to trace what has happened**

Hi,

SQL Server will not log the events by default. In this case probably you can
write triggers to audit the Delete/Insert and Update events.

Thanks
Hari
SQL Server MVP

"M" <rez1824@xxxxxxxxxxx> wrote in message
news:op.tf2mdvein9ig5y@xxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi

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?

any help would be thanked.


.

Relevant Pages

  • 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: decrypt function in SQL Server 2000
    ... refer the below site:- ... SQL Server MVP ... "jzhou" wrote in message ... > anyone know what is the decrypt function in SQL Server 7.0/2000. ...
    (microsoft.public.sqlserver.security)
  • Re: Slow performance after restarting
    ... The hotfix is described in KB article 815495. ... SQL Server MVP ... Columnist, SQL Server Professional ... When you refer to a hotfix, are you talking about one referred to in ...
    (microsoft.public.sqlserver.programming)
  • Re: Cascade update to two fields in a table...
    ... Both of these refer to UserName in tblUsers. ... you cannot set up cascading foreing keys, ... The SQL Server developers ...
    (comp.databases.ms-sqlserver)
  • Re: I cant seem to access my fulltext data
    ... log from messages coming from MSSearch or MSSCi? ... This might refer to your ... The most common reason for such a failure is the the SQL Server Service ...
    (microsoft.public.sqlserver.fulltext)