**to trace what has happened**

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.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@.yahoo.co.uk> wrote in message
news:op.tf2mdvein9ig5y@.system109.parskhazar.net...
> 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.|||you could enable c2 auditing as many gov types are forced to do.
mike.menard
"M" <rez1824@.yahoo.co.uk> wrote in message
news:op.tf2mdvein9ig5y@.system109.parskhazar.net...
> 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.|||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@.hotmail.com> 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@.yahoo.co.uk> wrote in message
> news:op.tf2mdvein9ig5y@.system109.parskhazar.net...
>
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/|||Have a look at these:
http://sqlserver2000.databases.aspf...erver-data.html
Andrew J. Kelly SQL MVP
"M" <rez1824@.yahoo.co.uk> wrote in message
news:op.tf33aps8n9ig5y@.system109.parskhazar.net...
>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@.hotmail.com> wrote:
>
>
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

**kill process**

Hi
In SQL 2000, sometimes it takes a long time to fetch data from a very
simple table that in normal cicumestances I can get the information in a
glance. and when I take look at
(enterprise manager->management->current activity->locks/process id)
I'll find some spids with red icon in blocking mode, so by right clicking
and killing the process I can get ride of them.
and I 've found in lock/objects when I have a view or procedure which is
locked all its tables are locked too.
I want to know when this problem occure and why? how can I prevent any
locking?
or how can I be informed when a lock object happened to go and kill
it?(should I accidently discover it?)
any help on this issue would be appreciated.M
http://www.sql-server-performance.c...ucing_locks.asp
"M" <rez1824@.yahoo.co.uk> wrote in message
news:op.tf7puxfcn9ig5y@.system109.parskhazar.net...
> Hi
> In SQL 2000, sometimes it takes a long time to fetch data from a very
> simple table that in normal cicumestances I can get the information in a
> glance. and when I take look at
> (enterprise manager->management->current activity->locks/process id)
> I'll find some spids with red icon in blocking mode, so by right clicking
> and killing the process I can get ride of them.
> and I 've found in lock/objects when I have a view or procedure which is
> locked all its tables are locked too.
> I want to know when this problem occure and why? how can I prevent any
> locking?
> or how can I be informed when a lock object happened to go and kill
> it?(should I accidently discover it?)
> any help on this issue would be appreciated.

**changing the logical name**

Hi
In SQL 2000, How can I change the logical name of a database?
Any help would be greatly appreciated.You can use sp_renamedb to change the name of the database. Another option
is to use ALTER DATABASE with MODIFY option. Check SQL Server Books Online
for exact syntax.
Anith