Re: **to trace what has happened**

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: **to trace what has happened**
    ... SQL Server will not log the events by default. ... write triggers to audit the Delete/Insert and Update events. ... SQL Server MVP ... I don't want to monitor the changes simentanously, I want to refer to them ...
    (microsoft.public.sqlserver.security)
  • Re: Slow performance after restarting
    ... Columnist, SQL Server Professional ... Launch additional instances of Query Analyzer and verify the connection ... Detach/Rename/Re-attach gets me a much smaller transaction ... >> log file is this size or what you do for backups. ...
    (microsoft.public.sqlserver.programming)
  • Re: Transaction Log Failure
    ... A maintenance plan can not create a log file, ... then bring up sql server. ... > maintenance plan that would create a transaction log file every hour. ... > 2004-12-14 21:00:43.51 backup BACKUP failed to complete the command ...
    (microsoft.public.sqlserver.server)
  • Re: Slow performance after restarting
    ... without the hotfix but the problem disappeared when the hotfix ... Columnist, SQL Server Professional ... Launch additional instances of Query Analyzer and verify the connection ... >> log file is this size or what you do for backups. ...
    (microsoft.public.sqlserver.programming)
  • Re: The location of transaction log file
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > log file of existing database? ... >>> How to change the location of transaction log file of existing ... >>> database files into two different drives. ...
    (microsoft.public.sqlserver.server)