Re: **to trace what has happened**

Have a look at these:

http://sqlserver2000.databases.aspfaq.com/are-there-tools-available-for-auditing-changes-to-sql-server-data.html

--
Andrew J. Kelly SQL MVP

"M" <rez1824@xxxxxxxxxxx> wrote in message
news:op.tf33aps8n9ig5y@xxxxxxxxxxxxxxxxxxxxxxxxxxx
I think it does it, cause when we set the database in full mode it somehow
save the changes so it can use it when it wants to restore the db based on
the last changes.
is it right?
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?
thanks

On Mon, 18 Sep 2006 15:17:22 +0330, Hari Prasad
<hari_prasad_k@xxxxxxxxxxx> wrote:

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.





--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/


.

Relevant Pages

  • Re: Attaching a Database
    ... Andrew J. Kelly SQL MVP ... "Tom Moreau" wrote in message ... > Can i attach a database without having its LOG file. ...
    (microsoft.public.sqlserver.server)
  • RE: Cant install Service Pack 3.
    ... When you will refer this log file you will find it is unable to find ... The Sample Installation Log File ... Thus when I attempt to upgrade to SQL Server 2005 SP3, ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting ... A System DSN, specifying windows authentication, and change to an ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting off ... A System DSN, specifying windows authentication, and change to an existing ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: Poor performance after upgrading to sql server 2005
    ... Andrew J. Kelly SQL MVP ... problem if the optimizer could not handle subqueries but I know for a ...
    (microsoft.public.sqlserver.setup)